Data Engineer - Baltimore City, MD - Creative Information Technology India

Creative Information Technology Inc (CITI) is an esteemed IT enterprise renowned for its exceptional customer service and innovation. We serve both government and commercial sectors, offering a range of solutions such as Healthcare IT, Human Services, Identity Credentialing, Cloud Computing, and Big Data Analytics. With clients in the US and abroad, we hold key contract vehicles including GSA IT Schedule 70, NIH CIO-SP3, GSA Alliant, and DHS-Eagle II.

Join us in driving growth and seizing new business opportunities.

Background

Client is seeking a hands-on Data Engineer to design, develop, and optimize large-scale data pipelines in support of our Enterprise Data Warehouse (EDW) and Data Lake solutions. This role requires deep technical expertise in coding, pipeline orchestration, and cloud-native data engineering on AWS. The Data Engineer will be directly responsible for implementing ingestion, transformation, and integration workflows — ensuring data is high-quality, compliant, and analytics-ready. This role may support other projects or teams within MDH as needed.

Role and Responsibilities

Responsible for designing, building, and maintaining data pipelines and infrastructure to support data-driven decisions and analytics. The individual is responsible for the following tasks:

• Design, develop and maintain data pipelines, and extract, transform, load (ETL) processes to collect, process and store structured and unstructured data
• Build data architecture and storage solutions, including data lakehouses, data lakes, data warehouse, and data marts to support analytics and reporting
• Develop data reliability, efficiency, and qualify checks and processes
• Prepare data for data modeling
• Monitor and optimize data architecture and data processing systems
• Collaboration with multiple teams to understand requirements and objectives
• Administer testing and troubleshooting related to performance, reliability, and scalability

Hands-On Data Pipeline Development

• Design, code, and deploy ETL/ELT pipelines across bronze, silver, and gold layers of the Data Lakehouse.
• Build ingestion pipelines for structured (SQL), semi-structured (JSON, XML), and unstructured data using PySpark/Python programming language using AWS Glue or EMR.
• Implement incremental loads, deduplication, error handling, and data validation.

EDW & Data Lake Implementation

• Develop dimensional data models (Star Schema, Snowflake Schema) for analytics and reporting.
• Build and maintain tables in Iceberg, Delta Lake, or equivalent OTF formats.

Healthcare Data Integration

• Build ingestion and transformation pipelines for EDI X12 transactions (837, 835, 278, etc.).
• Implement mapping and transformation of EDI data with FHIR and HL7 frameworks.

Data Quality, Security & Compliance