Company:
TechDigital Corporation
Location: Lawrenceville
Closing Date: 29/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Hybrid worker - 50% on-site
This position will be dedicated to the Clinical Data Warehousing & Delivery function within the Clinical Data Reporting & Analytics group and contribute to the improvement of clinical data review, cleaning efficiency and formal statistical analyses by providing innovative and forward-thinking Extract Transform and Load (ETL) solutions. Responsible for planning, connecting to the different data sources, designing and developing the mappings, scheduling those mappings within the Clinical Data Warehouse, monitoring and maintaining the ETL process within the Clinical Data warehouse.
Key Responsibilities and Major Duties
• Leverage technical expertise to define feasible solutions and understand limitations.
• Can create/develop prototypes for new solutions as applicable.
• Create best practices for data loading, transformation, and extraction.
• Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
• Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
• Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
• Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
• Maintain data integrity and traceability across the transformation lifecycle from the Source to Target
Qualifications
1. 8+ years of experience with any ETL tool.
2. Minimum 5+ years of experience in SQL language.
3. Minimum 3+ years of experience with cloud technologies.
4. Minimum 3+ years of experience in SAS programming.
5. Minimum 5+ years of experience in shell scripting.
6. Good to have experience with ECS (eClinical Solution) ETL tool.
Education: Minimum bachelor's degree in computer science
This position will be dedicated to the Clinical Data Warehousing & Delivery function within the Clinical Data Reporting & Analytics group and contribute to the improvement of clinical data review, cleaning efficiency and formal statistical analyses by providing innovative and forward-thinking Extract Transform and Load (ETL) solutions. Responsible for planning, connecting to the different data sources, designing and developing the mappings, scheduling those mappings within the Clinical Data Warehouse, monitoring and maintaining the ETL process within the Clinical Data warehouse.
Key Responsibilities and Major Duties
• Leverage technical expertise to define feasible solutions and understand limitations.
• Can create/develop prototypes for new solutions as applicable.
• Create best practices for data loading, transformation, and extraction.
• Develop data architecture, data modeling, and ETL mapping solutions within structured data warehouse environment.
• Develop and implement ETL routines according to the Data Warehouse (DWH) design and architecture.
• Support the development and validation required through the lifecycle of the DWH, maintain user connectivity and provide adequate security for data warehouse.
• Monitor the DWH systems performance and integrity; provide corrective and preventative maintenance as required.
• Maintain data integrity and traceability across the transformation lifecycle from the Source to Target
Qualifications
1. 8+ years of experience with any ETL tool.
2. Minimum 5+ years of experience in SQL language.
3. Minimum 3+ years of experience with cloud technologies.
4. Minimum 3+ years of experience in SAS programming.
5. Minimum 5+ years of experience in shell scripting.
6. Good to have experience with ECS (eClinical Solution) ETL tool.
Education: Minimum bachelor's degree in computer science
Share this job
Useful Links