Role OverviewNew England Life Care is seeking a Data Warehouse Developer to support the design, development, and ongoing maintenance of the organization's enterprise data warehouse and analytics infrastructure. The ideal candidate will possess strong SQL development skills, ETL experience, and expertise in dimensional modeling to support reporting and analytics initiatives across the organization.
What You Will Do
Design, develop, and maintain the enterprise data warehouse architecture, develop dimensional data models, design and implement ETL/ELT pipelines, optimize SQL queries, and automate data integration jobs.
Why It Might Be a Fit
The ideal candidate will possess strong SQL development skills, ETL experience, and expertise in dimensional modeling to support reporting and analytics initiatives across the organization.
Requirements
- Bachelor's degree in computer science, information systems, engineering, or other related discipline
- 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
Benefits
- 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
]]>