Job Title: [TMC-013-004] Data Engineer – Mid & Senior-Level

Job Description:

The TMCI Data Quality Group is seeking a talented and experienced Mid and Senior Level Data Engineers to join our dedicated team. As a Healthcare IT Data Engineer, you will play a pivotal role in designing, developing, and maintaining data pipelines, databases, and analytics solutions that support data-driven decision-making and patient care improvements in the healthcare industry. This position requires a thorough understanding of modern data warehousing concepts like data lakes and data lakehouses. The ideal candidate will be familiar with data modeling techniques such as Data Vault and Star Schema, and should be proficient in building, testing, and implementing data pipelines. They should also have experience with products like DBT and understand Directed Acyclic Graphs (DAGs). This role is within a government context requiring U.S. citizenship, a college degree, and eligibility to obtain a security clearance.

Key Responsibilities:

1. Data Integration and ETL:

Design and build data integration pipelines for collecting, cleansing, and transforming healthcare data from various sources, including electronic health records (EHR), medical devices, and clinical systems.

2. Database Management:

Develop and maintain healthcare databases, ensuring data accuracy, reliability, and compliance with industry standards and regulations, including HIPAA.

3. Data Architecture:

Collaborate with data scientists, analysts, and healthcare professionals to design data architectures that enable advanced analytics, machine learning, and reporting.

4. Optimization and Performance:

Continuously optimize data processing and storage systems for enhanced performance and scalability, enabling real-time data access and analytics.

5. Data Security and Compliance:

Implement robust data security measures to protect sensitive patient information, adhere to healthcare compliance standards, and perform routine audits.

6. Data Warehousing:

Develop and maintain data warehousing solutions for efficient storage, retrieval, and analysis of large healthcare datasets.

7. Data Documentation:

Create and maintain documentation for data models, data dictionaries, and data lineage to support transparency and data governance.

8. Collaboration:

Collaborate with cross-functional teams, including data scientists, analysts, clinicians, and IT professionals, to ensure data infrastructure meets healthcare data requirements.

Required Qualifications:

• U.S. Citizenship and the ability to obtain a DOD clearance required
• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Statistics, or a related field from an accredited institution
• Candidates local to the DMV (DC Metro, Southern MD, Northern VA) preferred, however all qualified CONUS-based candidates will be considered
• Minimum 5 years’ proven experience as a Data Engineer in the healthcare industry, or relevant role in the field
• Ability to communicate complex technical issues clearly in English
• Proficiency in ETL tools, data integration platforms, and database management systems (e.g., SQL, NoSQL)
• Strong knowledge of healthcare data standards, terminologies (ICD-10, SNOMED), and electronic health records (EHR) systems
• Understanding of healthcare compliance and regulations, including HIPAA
• Expertise in data modeling and data architecture
• Understanding of modern data warehousing concepts and experience with environments, such as RedShift
• Proficiency in Python and SQL, with exposure to PySpark
• Familiarity with Python packages like Pandas, Spark.sql, and DuckDB
• Knowledge in DBT and understanding of DAGs
• Hands-on experience with cloud platforms AWS, GCP, or Azure
• Experience in data modeling techniques, including Data Vault and Star Schema
• Prior experience in building, testing, and implementing data pipelines
• Excellent problem-solving, communication, and teamwork skills
• Ability to work in a dynamic and fast-paced information technology data quality team environment servicing the healthcare industry

Desired Skills:

• Experience with machine learning pipelines.
• Basic understanding