New England Life Care

Data Engineer

• 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.

Data Warehouse Developer