Data Warehouse Developer

New England Life Care; Woburn (MA); Hybrid; USD 120,000 - 139,000; Full time

Benefits offered by this job

Hybrid Position

Health Insurance

Vision Insurance

Generous 403b

Job summary

New England Life Care is seeking a Data Warehouse Developer to design, build, and maintain the organization's data warehouse and analytics infrastructure. This hybrid, full-time role collaborates with stakeholders to transform data from multiple systems into reliable information for business intelligence platforms.

The ideal candidate will have strong SQL and ETL expertise, experience with dimensional modeling, and a track record of delivering scalable data solutions using SSIS, Azure Data

Qualifications

• Bachelor’s degree in computer science or related field.
• 3+ years of experience in data warehouse development.
• Strong experience with Microsoft SQL Server and enterprise relational databases.
• Experience developing ETL pipelines using SSIS or Azure Data Factory.
• Demonstrated experience designing and implementing dimensional data models.
• Strong experience designing fact and dimension tables, surrogate keys, and SCDs.
• Advanced SQL development and query optimization skills.
• Experience with BI tools such as Power BI or Tableau.

Responsibilities

• Design, develop, and maintain the enterprise data warehouse architecture to support reporting, analytics, and business intelligence initiatives.
• Design and implement ETL/ELT pipelines to extract, transform, and load data from multiple systems into staging, transformation, and warehouse layers.
• Ensure data consistency, naming conventions, and attribute value integrity.
• Optimize SQL queries, indexing strategies, and performance for data retrieval and warehouse processing.
• Automate, schedule, and monitor data integration jobs for reliable data loading.
• Ensure data accuracy and quality with validation checks and reconciliations between sources and warehouse.
• Collaborate with analysts to translate requirements into scalable data models and warehouse solutions.
• Provide technical expertise for BI/reporting tools (Power BI, Tableau).
• Document architecture, models, ETL processes, and data definitions for maintainability and governance.
• Identify opportunities to improve data integration and reporting capabilities.
• Support data governance and data quality initiatives.
• Travel to remote sites as needed.

Skills

SQL development

Data warehouse architecture

Dimensional modeling

ETL/ELT

Data quality

Cross-functional collaboration

Education

Bachelor's degree in computer science or related field

Tools

SSIS

Azure Data Factory

Power BI

Tableau

Microsoft SQL Server

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Warehouse Developer

Full Time Technical Canton, MA, US

Salary Range: 120,000.00 To 139,000.00 Annually

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 hybridposition is full-time, Monday – Friday position.

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
• 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.
• 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 development lifecycle (SDLC) and data engineering best practices.
• Ensure professional practices comply with HIPAA Privacy and Security regulations and the organization’s Corporate Compliance Program.
• Build strong working relationships across departments and collaborate effectively with business and technical teams.
• Demonstrate strong problem-solving skills by identifying data issues, diagnosing root causes, and implementing effective solutions.
• Participate in the company Performance Improvement Program and provide recommendations for improvements based on data insights.
• Assist in training or mentoring staff on data warehouse concepts, reporting tools, or data access processes as needed.
• Participate in ongoing professional development through departmental meetings, technical training, and industry learning opportunities.
• Perform additional duties or special projects as assigned by the direct supervisor.
• Travel to remote sites as needed.

Educational Requirements:

• Bachelor’s degree in computer science, information systems, engineering, or other related discipline and/or 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 (SCD).
• 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.

Regulatory Requirements:

• Knowledge of HIPAA Privacy and Security requirements.
• Working knowledge of federal / state fraud and abuse laws required.
• Valid driver’s license with excellent driving record required.

Skills:

• Strong SQL programming and database development skills.
• Experience with data warehouse architecture and dimensional modeling techniques.
• Knowledge of ETL/ELT processes and data integration best practices.
• Ability to analyze complex datasets and translate business requirements into technical solutions.
• Strong communication and collaboration skills when working with cross-functional teams.
• Strong organizational and problem-solving skills.
• Self-motivated with the ability to work both independently and in team environments.
• Ability to design scalable, maintainable data solutions that support enterprise analytics.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

EOE

Monday through Friday from 8:00am until 5:00pm