Apply on Employer Site

ADC Management Solutions · 11 hours ago

Senior Data Engineer

DC - Washington, DC 20010

Full-time

Onsite

Senior Level

$55/hr - $60/hr

ADC Management Solutions is a small woman-owned business located in Washington, DC, offering IT consulting and administrative solutions to Government and Commercial Clients. They are seeking a Senior Data Engineer to serve as the primary technical engine for the agency's Medicaid data ecosystem, requiring mastery of legacy environments and spearheading cloud modernization efforts.

Human Resources

Diversity & Inclusion

Responsibilities

Maintain, troubleshoot, and modify complex SSIS packages handling high-volume Medicaid claims, provider, and member data

Manage code deployments and branching strategies within TFS, ensuring continuous integration of legacy SQL assets

Support and optimize SSRS report queries and SSAS tabular/multidimensional models to ensure federal and state compliance reporting remains uninterrupted

Implement "Medallion Architecture" (Bronze/Silver/Gold) using Azure Databricks (PySpark/SQL) as designed by the Lead Architect

Lead the transition of legacy SSIS logic into Azure Data Factory (ADF) and Databricks notebooks

Facilitate the migration of source control and CI/CD pipelines from TFS to Azure DevOps (Git)

Build and tune Dedicated and Serverless SQL Pools within Azure Synapse to facilitate advanced analytics and AI-readiness

Implement Row-Level Security (RLS) and automated data masking for PHI/PII in accordance with HIPAA, CMS MARS-E, and NIST standards

Develop automated data validation frameworks to ensure data parity between legacy SQL systems and the new Cloud Lakehouse

Qualification

SSISAzure SynapseDatabricksAzure Data FactoryTFSSQLHIPAA ComplianceTechnical AgilityCollaborationAttention to Detail

Required

Bachelor's degree in Information Technology or related field or equivalent experience

Training or certification in a particular product or IT platform/service, as required

Must be able to pass a criminal history background investigation and fingerprinting

Benefits

Great flexibility and compensation

Solid benefits package

An opportunity to advance quickly

Company

ADC Management Solutions

ADC is a woman and minority-owned human capital outsourcing company providing consulting and administrative management solutions.

Founded in 2003

Washington, District of Columbia, USA

51-200 employees

https://www.adc-ms.com

Funding

Current Stage

Growth Stage

Leadership Team

Kodjo G Ahiake

Controller/CFO

M. Harrison Boyd

Vice President, Chief Operating Officer

Company data provided by crunchbase