Data Warehouse Developer

• *1.

About Our

Client**

: The organization operates in the home infusion therapy services sector in New England and is the region’s only non-profit provider in this space. It functions as a hospital collaborative supporting over 70 hospital systems across Maine, New Hampshire, and Massachusetts. Established by local hospitals, the organization aims to ensure patients receive care aligned with high standards of quality and service, with a focus on patient-centered care.

• *2. About the Opportunity**

: The

• *Data Warehouse Developer**

will design, develop, and maintain the enterprise data warehouse and analytics infrastructure. This role is essential for building scalable data models and integration pipelines that enable accurate, accessible data for reporting, analytics, and decision-making. The position collaborates with business stakeholders and technical teams to transform data from multiple sources into actionable business intelligence.

• *3. Responsibilities**

:

• Design, develop, and maintain enterprise data warehouse architecture
• Develop dimensional data models including fact and dimension tables, surrogate keys, and slowly changing dimensions
• Design and implement ETL/ELT pipelines for data extraction, transformation, and loading from multiple sources
• Ensure data consistency, naming standards, and data attribute accuracy
• Optimize SQL queries and database performance for efficient data retrieval
• Automate, schedule, and monitor data integration jobs for reliable data loading
• Validate data accuracy and integrity through reconciliation processes
• Collaborate with analysts and technical teams to translate requirements into data models and solutions
• Provide technical expertise for BI and reporting tools such as Power BI
• Document data warehouse architecture, ETL processes, and data definitions
• Identify improvements for data integration, warehouse performance, and reporting
• Support data governance and quality initiatives
• Follow organizational policies and compliance requirements including HIPAA
• Build collaborative relationships across departments
• Troubleshoot data issues and implement effective solutions
• Participate in performance improvement programs and training initiatives
• Engage in professional development and special projects as assigned
• Travel to remote sites as necessary
• *4. Requirements**

:

• Bachelor’s degree in computer science, information systems, engineering, or related discipline, or equivalent experience
• 3 to 7 years of experience in data warehouse development
• Strong experience with Microsoft SQL Server or similar enterprise relational databases
• Experience developing ETL pipelines using SSIS, Azure Data Factory, or comparable tools
• Proven expertise in designing and implementing dimensional data models
• Knowledge of fact tables, dimension tables, surrogate keys, and slowly changing dimensions
• Advanced SQL development and query optimization skills
• Experience handling large datasets and complex data transformations
• Experience supporting business intelligence platforms such as Power BI or Tableau
• *5.

Pay Range and Compensation Package**

:

• The pay range and compensation package for this role will be determined based on the candidate’s experience, skills, and other relevant factors.
• *6.

Benefits & Perks**

:

• Health Insurance
• Dental Insurance
• Vision Insurance
• Employer-matched 403b savings program
• Company-paid life insurance, short- and long-term disability insurance
• Paid Time Off
• *7.

Equal Opportunity Statement**

: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

Note: RemoteHunter is not the Employer of Record (EOR) for this role. Our purpose in this opportunity is to connect exceptional candidates with leading employers. We help job seekers worldwide discover roles that match their goals and guide them to complete their full application directly through the hiring company’s career page or ATS.