Azure Data Warehouse Developer

e&e is seeking an Azure Data Warehouse Developer for a hybrid contract opportunity in Harrisburg, PA! The Azure Data Warehouse Developer will play a critical role in supporting a large-scale Data Modernization Initiative aimed at transforming public health operations through data-driven policies and interventions. This role will focus on designing, developing, and implementing enterprise data warehouse solutions in Microsoft Azure. The developer will support both current reporting and analytical needs while helping build a modernized Azure-based data environment utilizing Databricks, Delta Lake, Synapse, and other advanced cloud technologies. This position requires hands-on technical expertise, strong collaboration skills, and the ability to deliver secure, scalable, and high-performance data solutions. Responsibilities: • Design, develop, and maintain enterprise data warehouse (EDW) solutions in Microsoft Azure. • Build and optimize ELT/ETL pipelines using Azure Data Factory, Synapse, SQL Server Integration Services (SSIS), and other tools. • Implement and manage Azure Databricks, Delta Lake, and Spark-based data processing for large datasets. • Create centralized data models to support advanced analytics and reporting requirements. • Translate business requirements into optimized technical designs and implement robust data solutions. • Manage and enhance CI/CD pipelines using Azure DevOps for efficient build, test, and deployment processes. • Ensure data quality, integrity, and compliance with federal and state standards. • Conduct performance tuning and optimization of database and warehouse systems. • Prepare and maintain documentation, including system diagrams, test plans, procedures, and technical standards. • Collaborate with business analysts, application developers, DBAs, and infrastructure teams to ensure seamless solution delivery. • Participate in technical reviews, testing, and user acceptance sessions. • Provide knowledge transfer, training, and ongoing support for implemented systems. • Contribute to strategic initiatives such as the Data Modernization Initiative, LIMS replacement, NEDSS NextGen, and other statewide projects. Requirements: • 4-year degree in Computer Science, Information Systems, or related field (advanced study preferred). • 5+ years of experience in data warehousing and business intelligence solution design, implementation, and maintenance. • Strong hands-on expertise with Azure Synapse, Azure Databricks, Azure Delta Lake, Azure Data Factory, Apache Spark, and Python. • Proficiency in SQL Server, T-SQL, and complex query development. • Proven experience producing ETL/ELT pipelines with SSIS or equivalent tools. • Experience in CI/CD pipeline design and maintenance using Azure DevOps, including Monorepo-based pipelines. • Advanced knowledge of relational and dimensional modeling, star schema design, and data warehousing best practices. • Experience with data mining, data quality, cleansing, classification, and data governance processes. • Strong analytical and problem-solving skills, with the ability to translate business needs into scalable technical solutions. • Excellent communication skills, with the ability to present technical concepts to both technical and non-technical stakeholders. • Ability to manage multiple projects simultaneously with minimal supervision. Preferred Experience • Background working with healthcare or public health data sets. • Experience with analytics as a service, APIs, and database file system optimization. • Familiarity with state and federal data compliance frameworks.