Data Warehouse Developer

New England Life Care•Canton, MA

1d•$120,000 - $139,000•Hybrid

About The Position

New England Life Care (NELC), a nonprofit home infusion therapy provider serving more than 70 hospital systems in Maine, New Hampshire, and Massachusetts, is seeking a full-time Data Warehouse Developer. The role supports the design, development, and ongoing maintenance of the organization’s enterprise data warehouse and analytics infrastructure. It focuses on building scalable warehouse architecture, dimensional data models, and data integration pipelines that turn data from multiple operational systems into reliable, accessible information for reporting, analytics, and operational decision-making. The developer works with business stakeholders, analysts, and application teams and provides technical expertise for business intelligence platforms. The position is described as hybrid and full-time, Monday through Friday, with working hours of 8:00 a.m. to 5:00 p.m. The posting also states that remote hiring is limited to Maine, Massachusetts, and New Hampshire, and that travel to remote sites may be needed.

Requirements

Bachelor’s degree in computer science, information systems, engineering, or a related discipline, or an equivalent combination of education and relevant experience.
3–7+ years of experience in data warehouse development.
Strong experience with Microsoft SQL Server or other enterprise relational databases.
Experience developing ETL pipelines using SSIS, Azure Data Factory, or comparable ETL tools.
Demonstrated experience designing and implementing dimensional data models.
Strong experience designing fact tables, dimension tables, surrogate keys, and slowly changing dimensions.
Advanced SQL development and query optimization skills.
Experience working with large datasets and complex data transformations.
Experience supporting business intelligence and reporting platforms such as Power BI, Tableau, or similar tools.
Knowledge of HIPAA Privacy and Security requirements.
Working knowledge of federal and state fraud and abuse laws.
Valid driver’s license and excellent driving record.
Strong SQL programming and database development skills.
Knowledge of data warehouse architecture, dimensional modeling, ETL/ELT processes, and data integration best practices.
Ability to analyze complex datasets and translate business requirements into technical solutions.
Strong communication, collaboration, organizational, and problem-solving skills.
Ability to work independently and in a team environment.
Ability to design scalable, maintainable data solutions that support enterprise analytics.

Responsibilities

Design, develop, and maintain enterprise data warehouse architecture for reporting, analytics, and business intelligence.
Develop dimensional data models, including fact and dimension tables, surrogate keys, and slowly changing dimensions.
Design and implement ETL/ELT pipelines to load data from operational systems into staging, transformation, and warehouse layers.
Maintain efficient processing and consistency in data attributes, naming conventions, and element value types.
Optimize SQL queries, indexing strategies, and database performance.
Automate, schedule, and monitor data integration jobs.
Implement validation and reconciliation processes to ensure data accuracy, consistency, and integrity.
Collaborate with 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 warehouse architecture, data models, ETL processes, and data definitions.
Identify opportunities to improve data integration, warehouse performance, and reporting capabilities.
Support data governance and data quality initiatives.
Follow company policies and procedures and comply with HIPAA requirements and the Corporate Compliance Program.
Maintain knowledge of the software development lifecycle and data engineering best practices.
Build working relationships and collaborate across departments.
Identify data issues, diagnose root causes, and implement solutions.
Participate in the Performance Improvement Program and recommend improvements based on data insights.
Assist with training or mentoring staff on data warehouse concepts, reporting tools, or data access processes as needed.
Participate in professional development, departmental meetings, technical training, and industry learning opportunities.
Perform additional duties or special projects assigned by the direct supervisor.
Travel to remote sites as needed.