Data Engineer - Mid & Senior-Level in McLean

Job DescriptionJob Description 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) , 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 of data management fundamentals: ETL, data governance, and data quality 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 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 and protected veteran status. \nCompany 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. Company DescriptionTMCI - 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. Energy Jobline ZR