Data Warehouse Developer

New England Life Care (NELC) is one of the fastest growing home infusion therapy services companies in New England and is the region’s only non-profit home infusion provider. NELC is a hospital collaborative serving more than 70 hospital systems in Maine, New Hampshire, and Massachusetts. NELC was created by local hospitals to ensure their patients have access to a provider that reflects their commitment to excellence in patient care, quality, and service. Like our owner hospitals, NELC provides patient focused care. New England Life Care has and continues to build a diverse, inclusive, and authentic workplace, so if you’re energized by this opportunity, you may be the person we are looking for! New England Life Care is hiring a full-time Data Warehouse Developer to join our growing team! This **hybrid** position is full-time, Monday – Friday position. **\*\*Currently only hiring for remote positions in the following states: Maine, Massachusetts, and New Hampshire\*\*** **Job Summary*:*** *New England Life Care is seeking a qualified Data Warehouse Developer to support the design, development, and ongoing maintenance of the organization’s enterprise data warehouse and analytics infrastructure. The Data Warehouse Developer will play a key role in building scalable data warehouse architecture, dimensional data models, and data integration pipelines that support enterprise reporting, analytics, and operational decision-making. This role will work closely with business stakeholders, analysts, and application teams to transform data from multiple operational systems into reliable and accessible information for business intelligence platforms. The ideal candidate will possess strong SQL development skills, ETL experience, and expertise in dimensional modeling (star and snowflake schemas) to support reporting and analytics initiatives across the organization.* **Benefits:** - Hybrid Position - Health Insurance - Dental Insurance - Vision Insurance - Generous employer-matched 403b savings program - Company paid: Life insurance, Short- and long-term disability insurance - Paid Time Off - And much more! **Primary Job Responsibilities:** - Design, develop, and maintain the enterprise data warehouse architecture to support reporting, analytics, and business intelligence initiatives. - Develop dimensional data models including fact tables, dimension tables, surrogate keys, and slowly changing dimensions using industry best practices. - Design and implement ETL/ELT pipelines to extract, transform, and load data from multiple operational systems into staging, transformation, and warehouse layers. - Ensure efficient processing on an ongoing basis including data consistency of data attributes, naming conventions, and element value types. - Optimize SQL queries, indexing strategies, and database performance to ensure efficient data retrieval and warehouse processing. - Automate, schedule, and monitor data integration jobs to ensure reliable and consistent data loading processes. - Ensure data accuracy, consistency, and integrity by implementing validation checks and reconciliation processes between source systems and the data warehouse. - Collaborate with business analysts, data analysts, and technical teams to translate business requirements into scalable data models and warehouse solutions. - Provide technical expertise for business intelligence and reporting tools such as Microsoft Power BI and other analytics platforms. - Document data warehouse architecture, data models, ETL processes, and data definitions to support long-term maintainability and governance. - Identify opportunities to improve data integration processes, warehouse performance, and reporting capabilities. - Support ongoing data governance and data quality initiatives across the organization. **Additional Job-Related Duties:** - Follow New England Life Care policies and procedures in the normal conduct of company business. - Maintain a strong understanding of software devel…