Data Engineer

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

Data Engineer

$55 - $70 per hour | 450 Plymouth Rd, PA | On-site | Consulting

Highly reputable Healthcare Company seeks an experience Data Engineer

A bit about us:

Reputable Healthcare Company

Why join us?

Highly Reputable

Job Details

We are seeking a skilled and experienced Database Engineer to join our team. The ideal candidate will play a critical role in designing, developing, and maintaining our Enterprise Data Warehouse (EDW). The role requires a deep understanding of SQL, data modeling, and optimization to ensure the efficiency, scalability, and reliability of our data infrastructure.

Responsibilities Include:

• Design, develop, and maintain the Enterprise Data Warehouse (EDW) to ensure high performance, scalability, and reliability.


• Write efficient SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes.


• Optimize database performance by analyzing, monitoring, and fine-tuning SQL queries and database structures.


• Collaborate with Enterprise Analytics Sr Director and team to design and implement data models and database structures that support business requirements.


• Manage database security, backup, and recovery strategies to ensure data integrity and availability.


• Develop and maintain data pipelines to ensure seamless data flow between various source systems and the EDW.


• Perform regular data quality checks and troubleshooting to ensure the accuracy and consistency of data in the EDW.


• Monitor and maintain the performance of databases, addressing any issues related to performance, latency, and storage.


• Work with development teams to integrate databases with applications and ensure seamless interaction between data services and business systems.


• Keep up to date with emerging trends and best practices in database engineering, data warehousing, and SQL optimization.

Requirements

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


• Proven experience as a Database Engineer with 10 or more years of experience in a healthcare environment, with a focus on SQL and Enterprise Data Warehousing.


• Proficiency in SQL including query writing, optimization, and troubleshooting.


• Strong knowledge of data modeling and database design principles.


• Experience with ETL processes and data integration tools (e.g., SSIS, Informatica, Talend, etc.).


• Understanding of data security, backup, and recovery procedures.


• Strong problem-solving skills and attention to detail.


• Knowledge of Agile methodologies and experience working in Agile environments.


• Strong communication skills working across business functions (Software Development, Clinical, IT, Client Services, etc.).


• Manage multiple projects, issues, and deliverables in a fast-paced environment. Able to multi-task and prioritize work to meet deadlines.


• Excellent listening, critical thinking, written and verbal skills.


• Works independently and within a team environment.


• Experience working in a professional environment with clinical managed care concepts, practices and procedures preferred.

Jobot is an Equal Opportunity Employer. We provide an inclusive work environment that celebrates diversity and all qualified candidates receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, age (40 and over), disability, military status, genetic information or any other basis protected by applicable federal, state, or local laws. Jobot also prohibits harassment of applicants or employees based on any of these protected categories. It is Jobot’s policy to comply with all applicable federal, state and local laws respecting consideration of unemployment status in making hiring decisions.

Sometimes Jobot is required to perform background checks with your authorization. Jobot will consider qualified candidates with criminal histories in a manner consistent with any applicable federal, state, or local law regarding criminal backgrounds, including but not limited to the Los Angeles Fair Chance Initiative for Hiring and the San Francisco Fair Chance Ordinance.