Senior Azure Data & .NET Developer

• Azure Data Engineering and Data Mart Development (Primary Focus)
• Design, develop, enhance, and maintain Azure-based Data Warehouse and Data Mart solutions.
• Develop and maintain ETL/ELT pipelines using Azure Data Factory and Azure Databricks.
• Implement data transformations using SQL, PySpark, and Spark SQL.
• Develop and optimize SQL queries, stored procedures, and database objects.
• Support ingestion, transformation, and integration of data from legacy systems, relational databases, files, and APIs.
• Perform data profiling, validation, reconciliation, and conversion testing.
• Investigate data discrepancies, pipeline failures, performance bottlenecks, and production defects.
• Develop automated deployment processes and support CI/CD for ADF, Databricks, and database changes.
• .NET Application Development and Integration (Secondary Focus)
• Support enhancements and defect fixes for an existing Medicaid Portal application developed using .NET/C#.
• Develop, modify, and troubleshoot ASP.NET Core application components and REST APIs.
• Support application integration with SQL databases, backend services, and Data Mart components.
• Troubleshoot application defects, data-access issues, and API integration problems.
• Participate in unit, integration, regression, and user acceptance testing.
• Work across application and data engineering tasks based on project priorities.
• Delivery and Collaboration
• Work independently on assigned development tasks from requirements through deployment.
• Collaborate with technical leads, business analysts, QA teams, and project management.
• Produce and maintain technical documentation, data mappings, and test evidence.
• Participate in code reviews, defect triage, and production support.
• Deliver maintainable, tested, production-ready code.

Experience: 7+ years of hands-on software development, including strong Azure data engineering experience

We are supporting a long-running Medicaid/MMIS modernization program for a state government client, involving the modernization of legacy applications, Data Warehouses, and Data Marts on Microsoft Azure.

We are seeking two hands-on Senior Developers who can contribute primarily to Azure Data Warehouse/Data Mart development using Azure Databricks, Azure Data Factory (ADF), SQL, and PySpark, while also supporting our .NET/C#-based Medicaid Portal application, API integrations, and testing activities as project priorities require.

This is an individual contributor position focused on hands-on development, troubleshooting, testing, and delivery. We are not looking for candidates whose recent experience is primarily architecture, project management, or team leadership., * 7+ years of hands-on development experience, with significant Data Warehouse/Data Mart or data engineering experience.

• Strong hands-on Azure Data Factory experience, including pipelines, triggers, linked services, parameterization, and monitoring.
• Hands-on Azure Databricks development experience using notebooks, PySpark, or Spark SQL.
• Advanced SQL development skills, including complex queries, stored procedures, joins, performance tuning, and data transformations.
• Experience developing and maintaining ETL/ELT pipelines.
• Experience with data migration, data reconciliation, and validation of large datasets.
• Experience with Git, Azure DevOps, and CI/CD processes.
• Working experience with C#/.NET application or backend development, sufficient to implement enhancements and resolve defects.
• Strong debugging, troubleshooting, and problem-solving skills.
• Ability and willingness to work directly on code, testing, and production issues.

Preferred Skills:

• ASP.NET Core / .NET 6 or later, including .NET 8.
• Experience with REST API development and integration.
• Experience with SQL Server, Azure SQL Database, or Azure SQL Managed Instance.
• Experience with Delta Lake, Databricks Workflows, and incremental data processing.
• Familiarity with Azure storage services such as ADLS Gen2.
• Experience with automated testing and application deployment.
• Experience supporting legacy system modernization or cloud migration.
• Medicaid, MMIS, Medicare, healthcare claims, eligibility, provider, or state government systems experience.