Senior Data Engineer, EDW & SQL Optimization (On-site)

Jobot; Plymouth Township (PA); On-site; USD 76,000 - 96,000; Full time

Job summary

Jobot is seeking a seasoned Data Engineer to design, build, and optimize our Enterprise Data Warehouse (EDW) in a healthcare context. You will write SQL, model data, and manage ETL pipelines to ensure high performance and data integrity across source systems.

Collaborating with Analytics and IT teams, you will implement robust data solutions, maintain security, and stay current with best practices in data warehousing and SQL optimization.

Qualifications

• Bachelor's degree in CS/IT or related field.
• 10+ years of experience as Database/Data Engineer in healthcare environment preferred.
• Proficiency in SQL, data modeling, and ETL processes.
• Knowledge of Agile methodologies and cross-functional collaboration.

Responsibilities

• Design, develop, and maintain the Enterprise Data Warehouse (EDW).
• Write efficient SQL queries and scripts for ETL processes.
• Optimize database performance and tune SQL queries and structures.
• Collaborate with Analytics and IT teams to design data models.
• Manage database security, backup, and recovery strategies.
• Develop and maintain data pipelines between source systems and EDW.
• Perform data quality checks and troubleshoot data accuracy.

Skills

SQL

Data modeling

ETL

Query optimization

Data quality

Education

Bachelor’s degree in Computer Science, Information Technology, or related field

Tools

SSIS

Informatica

Talend

Job description

Jobot is seeking a seasoned Data Engineer to design, build, and optimize our Enterprise Data Warehouse (EDW) in a healthcare context. You will write SQL, model data, and manage ETL pipelines to ensure high performance and data integrity across source systems.

Collaborating with Analytics and IT teams, you will implement robust data solutions, maintain security, and stay current with best practices in data warehousing and SQL optimization.