Data Engineer [TMC-011-005]

Job Description

Job Description

The TMCI Data Quality Group is seeking a talented and experienced Data Engineer 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.

Qualifications:

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• U.S. Citizenship required and the ability to obtain a DOD clearance.
• Must reside in Virginia, Maryland, or DC Metro Area.
• Eligibility for Government security clearance.
• 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.
• Some experience in data modeling techniques, including Data Vault and Star Schema.
• Prior experience in building, testing, and implementing data pipelines.
• Experience with machine learning pipelines is a plus, but not required.
• 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.

Recommended Skills:

• Comfortable working with large data sets and databases.
• Basic understanding of data management fundamentals: ETL, data governance, and data quality.
• Familiarity with cloud platforms like AWS, GCP, or Azure.
• Knowledge of software development methodologies and processes.
• Understanding of data warehousing design principles and industry best practices.
• Ability to write readable, maintainable, and performant code.
• Prior healthcare IT project-based consulting experience, highly desirable.

Salary Range: The salary range noted represents the company’s minimum and maximum range for this role at the time of posting. The salary made at offering for this position is based on a comprehensive evaluation of candidates' skills, years of experience, and directly related expertise to the specific requirements of the role. Compensation will be determined considering various factors, including but not limited to the individual's qualifications, competencies, and alignment with the responsibilities outlined in the job description.

TMCI is an Equal Opportunity Employer, including disability and protected veteran status.

TMCI - The McVey Company, Inc. brings over 25 years of corporate experience within and in support of the Department of Defense (DOD). With a proven track record, TMCI has been involved as both a prime and sub-contractor for various projects within the Defense Health Agency (DHA) and Military Health System (MHS). We actively collaborate with companies of all sizes to expand our capabilities and better serve our customers.

Company Description

TMCI - The McVey Company, Inc. brings over 25 years of corporate experience within and in support of the Department of Defense (DOD). With a proven track record, TMCI has been involved as both a prime and sub-contractor for various projects within the Defense Health Agency (DHA) and Military Health System (MHS). We actively collaborate with companies of all sizes to expand our capabilities and better serve our customers.