Data Warehouse Developer

Our client is a non-profit home infusion therapy services provider in New England, collaborating with over 70 hospital systems across Maine, New Hampshire, and Massachusetts. Established by local hospitals, it ensures patient access to care that aligns with hospital commitments to quality and service in home infusion therapy.

About the Role

The Data Warehouse Developer will support the design, development, and maintenance of the enterprise data warehouse and analytics infrastructure. This role is key to building scalable data models and data integration pipelines that enable reliable business intelligence and operational decision-making by transforming data from multiple operational systems into accessible information.

Responsibilities

• Design and maintain enterprise data warehouse architecture supporting reporting and analytics.
• Develop dimensional data models using industry best practices.
• Create and implement ETL/ELT pipelines for data extraction, transformation, and loading.
• Ensure efficient and consistent data processing, including validation and reconciliation.
• Optimize SQL queries and database performance.
• Automate and monitor data integration jobs.
• Collaborate with analysts and technical teams to translate business requirements into data solutions.
• Provide technical expertise for BI and reporting tools such as Microsoft PowerBI.
• Document architecture, data models, ETL processes, and definitions.
• Identify improvements for data integration, performance, and reporting.
• Support data governance and quality initiatives.
• Adhere to policies and compliance standards including HIPAA.
• Participate in professional development and training activities.
• Perform additional duties and travel as required.

Qualifications

• Bachelor’s degree in computer science, information systems, engineering, or related field, or equivalent experience.
• 3 to 7 years of experience in data warehouse development.
• Proficiency with Microsoft SQL Server or similar relational databases.
• Experience developing ETL pipelines using tools like SSIS or Azure Data Factory.
• Expertise in designing dimensional data models including fact tables, dimension tables, surrogate keys, and SCD.
• Advanced SQL development and query optimization skills.
• Experience with large datasets and complex data transformations.
• Familiarity with BI platforms such as Power BI or Tableau.
• Knowledge of HIPAA privacy and security requirements.
• Understanding of federal and state fraud and abuse laws.