Lead Data Architect

Title: Lead Data Architect Schedule: Hybrid Role (3 days remote 2 days onsiteLocation: Must be Local in Maryland - 5052 Dorsey Hall Dr, Ste. 203, Ellicott City, MD 21042 - visit various State of Maryland agency offices as needed (travel at their own expense)Status: U.S. Citizens or Permanent Resident (Green Card) holders Overview: Emerge Solutions Group, LLC, is seeking an Information Technology Architect (Senior) who will provide expertise in the most current principles and practices of architecture, data management systems, and experience in large system designs, including Enterprise Data Warehouse (EDW) and cloud-based Data Lake solutions. The individual must have experience in data modelling in the information management arena, including Medallion Architecture and Dimensional Data Modelling (e.g., Star and Snowflake schemas). This role requires knowledge of healthcare data standards and interoperability, such as EDI X 12, FHIR, and HL7, as well as expertise in AWS or equivalent platforms. The individual provides expertise in modelling and organizing information to facilitate support of projects or information architectures and provides guidance on how and what to data and process model. The position primarily deals with transition planning from legacy to modern systems by concentrating on information flows, data exchange, and data translation standardization services. This includes leading a team responsible for designing, building, and maintaining scalable data pipelines, implementing Iceberg or Delta Lake-based OLAP solutions, and ensuring regulatory compliance with HIPAA and CMS standards. Additional Key Responsibilities Include: Lead and mentor a team of data engineers in developing and maintaining scalable, automated data pipelines. Hands-on experience in architecture and implementing a Medallion Architecture-based Data Lakehouse with Bronze (Raw), Silver (Cleansed), and Gold (Aggregated) layers. Design and develop an EDW on cloud platforms (e.g., AWS) using technologies such as Apache Iceberg or Delta Lake. Build and optimize Dimensional Data Models using Star Schema and Snowflake Schema. Work with AWS services (e.g., Glue, Redshift, Athena, EMR, HealthLake, Lake Formation) or equivalent platforms. Process and integrate healthcare data in EDI X 12 formats (837, 835, 278, etc.) and map to FHIR and HL7 standards. Ensure compliance with HIPAA and CMS interoperability standards through data governance, lineage, access controls, and encryption Collaborate with business and technical stakeholders to align data architecture with organizational goals. Drive the adoption of CI/CD, automation, and infrastructure-as-code practices in data engineering workflows. Education: Bachelor's Degree from an accredited college or university with a major in Engineering, Computer Science, Mathematics or a related field. Master's degree preferred. General Experience: At least ten (10) years of experience planning, designing, building, and implementing IT systems, including at least seven (7) years of experience in data engineering, ETL development, or cloud data architecture, with at least two (2) years in a technical leadership role. Hands-on engineering lead: designing, developing, and optimizing pipelines, ingestion, and data lake/EDW solutions. Specialized Experience: 5+ years supervising/managing major projects, lead architect for large-scale IT implementations, especially healthcare. Recognized expert; advanced mentoring, written & verbal communication. Prefer 2+ years hands-on experience with Medallion, EDW (Iceberg/Delta), EDI X12, Spark/Flink. Strong stakeholder management, but more technical team-focused. Leadership & Team Role: Strategic directs large teams/projects; ensures transition from legacy to modern; emphasizes mentoring and client engagement. More Tactical: leads team of engineers; drives coding standards, automation, CI/CD, and infrastructure-as-code. Additional specialized expertise includes: Architecting and implementing cloud-based EDW and Data Lakes using Medallion Architecture. Proficiency with AWS services such as Glue, Redshift, Athena, EMR, S3, HealthLake, and Lake Formation. Development and optimization of scalable ETL/ELT workflows using Apache Spark, Airflow, or similar tools. Hands-on experience with EDI X 12 transactions (e.g., 837, 835, 278) and healthcare data integration. Implementation of data quality, lineage, security, and governance controls in compliance with HIPAA and CMS regulations. Strong programming skills in SQL, Python, or Scala. Job Type: Contract Pay: $60.00 - $65.00 per hour Expected hours: 40 per week Ability to Commute: Ellicott City, MD 21042 (Required) Ability to Relocate: Ellicott City, MD 21042: Relocate before starting work (Required) Work Location: Hybrid remote in Ellicott City, MD 21042