HRUCKUS · 6 hours ago
Senior Data Engineer
Washington, DC
Contract
Hybrid
Senior Level
$157K/yr - $169K/yr
7+ years expHRUCKUS is a veteran-owned consulting firm focused on strategic sourcing, supply chain, and IT staffing. They are seeking a Senior Data Engineer to lead modernization efforts for the Medicaid data ecosystem, ensuring the stability of current reporting while executing a cloud modernization roadmap.
Business DevelopmentIT ManagementManagement Consulting
Hiring Manager
Mandy Arevalo
Responsibilities
ETL Management: Maintain, troubleshoot, and modify complex SSIS packages handling high-volume Medicaid claims, provider, and member data
Version Control: Manage code deployments and branching strategies within TFS, ensuring continuous integration of legacy SQL assets
Legacy Reporting Support: Support and optimize SSRS report queries and SSAS tabular/multidimensional models to ensure federal and state compliance reporting remains uninterrupted
Cloud Development: Implement "Medallion Architecture" (Bronze/Silver/Gold) using Azure Databricks (PySpark/SQL) as designed by the Lead Architect
Pipeline Refactoring: Lead the transition of legacy SSIS logic into Azure Data Factory (ADF) and Databricks notebooks
DevOps Transformation: Facilitate the migration of source control and CI/CD pipelines from TFS to Azure DevOps (Git)
Synapse Integration: Build and tune Dedicated and Serverless SQL Pools within Azure Synapse to facilitate advanced analytics and AI-readiness
Medicaid Compliance: Implement Row-Level Security (RLS) and automated data masking for PHI/PII in accordance with HIPAA, CMS MARS-E, and NIST standards
Data Quality: Develop automated data validation frameworks to ensure data parity between legacy SQL systems and the new Cloud Lakehouse
Qualification
Required
Maintaining SQL Server (SSIS/SSAS/SSRS) while concurrently deploying Azure cloud solutions
Expert-level proficiency in SSIS and T-SQL. Advanced proficiency in Azure Databricks (Unity Catalog, Delta Lake) and Azure Synapse
Deep experience with TFS (Team Foundation Server) and a strong desire to migrate workflows to Git/Azure DevOps
Mastery of SQL and Python (PySpark)
7-10 yrs. leading advanced technology projects or service projects
7-10 yrs. full system engineering lifecycle
Bachelor's degree
Preferred
Experience with Microsoft Purview for data cataloging
Extensive experience with Medicaid/Medicare data structures (e.g., MMIS, EDI 837/835, claims processing)
Microsoft Certified: Azure Data Engineer Associate or Databricks Certified Professional Data Engineer
Experience in a government or highly regulated environment
Company
HRUCKUS
Hruckus is a management consultancy that offers strategic sourcing, IT strategy, business case analysis and program management services.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase