Junior Data Engineer [TMC-013-002]

Job Description

Job Description

TMCI is seeking a Junior Data Engineer to join our team, playing a 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. Understanding of modern data warehousing concepts like data lakes and data lakehouses is preferred. The ideal candidate will be familiar with data modeling techniques such as Data Vault and Star Schema, and should have familiarity in building, testing, and implementing data pipelines. Experience with products like DBT and understanding of Directed Acyclic Graphs (DAGs) is also favorable. 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
• On-site requirement at our McLean, VA office – only candidates local to the DMV (DC Metro, Southern MD, Northern VA) will be considered
• 0 – 2 years of experience in data engineering, database development, software development, or a related technical field
• Basic knowledge of SQL and relational database concepts
• Familiarity with at least one programming language such as Python, Java, or C#
• Ability to communicate complex technical issues clearly in English
• 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 Qualifications:

• 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
• Proficiency in ETL tools, data integration platforms, and database management systems (e.g., SQL, NoSQL)
• 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

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 by 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.