Azure Data Warehouse Developer

For over half a decade, Hudson Manpower has been a trusted partner in delivering specialized talent and technology solutions across IT, Energy, and Engineering industries worldwide. We work closely with startups, mid-sized firms, and Fortune 500 clients to support their digital transformation journeys. Our teams are empowered to bring fresh ideas, shape innovative solutions, and drive meaningful impact for our clients. If you're looking to grow in an environment where your expertise is valued and your voice matters, then Hudson Manpower is the place for you. Join us and collaborate with forward thinking professionals who are passionate about building the future of work.

Key Responsibilities

• Manage assignments, track progress, and ensure delivery against timelines.

• Plan, organize, and prioritize work, coordinating with the EDW and other teams.

• Participate in status, process, deliverable, and quality assurance reviews.

• Gather business and technical requirements; perform research and make recommendations for solutions.

• Develop and implement efficient data warehousing solutions and technical documentation.

• Participate in solution testing, training, and knowledge transfer sessions.

• Ensure compliance with federal and commonwealth standards and policies.

• Serve as presentations lead for the EDW, DOH offices, and partner agencies.

• Maintain project and process documentation on SharePoint.

• Complete timely weekly reporting via People Fluent/VectorVMS, Daptiv, and SharePoint as required.

Requirements

Required Skills & Qualifications

• Expertise in designing, developing, and maintaining data warehouse and ELT application infrastructure in Azure.

• Significant hands-on experience with Azure, Azure Databricks, Delta Lake, Data Factory, Pipelines, Apache Spark, and Python.

• Strong track record with SQL Server, Azure Synapse, T-SQL, SSIS, and related BI/data warehousing tools.

• Proven experience producing ETL/ELT using SQL Server Integration Services and other tools.

• Experience as an Azure DevOps CI/CD Pipeline Release Manager (including design and maintenance of robust, automated CI/CD pipelines and troubleshooting monorepo environments).

• Proficiency with data formatting, search, retrieval, extraction, classification, quality control, cleansing, and filtering techniques.

• Experience with data mining, modeling standards, analytics/reporting methodologies, and data engineering/API development.

• Ability to analyze and translate business requirements into optimized data designs and solutions.

• Advanced knowledge of relational and dimensional databases; strong understanding of data warehousing, facts, dimensions, and star schema methodologies.

• Documentation skills for technical specifications, diagrams, flowcharts, manuals, and test plans.

• Excellent organizational skills; ability to independently manage multiple priorities.

• Outstanding written and verbal communication skills; able to present technical concepts to diverse audiences.

• Team player with capacity for independent work and minimal supervision.

• At least 5 years of directly relevant experience.

• Bachelor’s degree in Computer Science or related field (advanced study preferred).

Highlights

Azure Data Warehouse Developer // Harrisburg, PA (once a month onsite) Candidate must be located in Pennsylvania