Data Warehouse Developer

Vaga não está no LinkedIn

🕒 Maio 7

🦞 Maine, New Hampshire, +1 estados a mais – Remoto

🦞 Maine – Remote 🗻 New Hampshire – Remote 🍂 Massachusetts – Remote

💵 $115.000 - $130.000 / ano

⏰ Tempo Integral

🟡 Pleno

🟠 Sênior

🚰 Engenheiro de Dados

🦅 Patrocina Visto H1B

Esta empresa já patrocinou vistos H1B no passado.

Candidatar-se

Encontrar Vagas Remotas Similares

Receber Emails de Vagas Remotas

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo

New England Life Care

SiteLinkedInTodas as Vagas

201 - 500 funcionários

Fundada em 1987

A New England Life Care é reconhecida nacionalmente como uma fornecedora sem fins lucrativos e orientada por uma missão de serviços de terapia de infusão domiciliar e farmácia de especialidade, afiliada a mais de 60 dos principais centros médicos da Nova Inglaterra. Somos uma organização orientada pela comunidade com um foco caritativo no qual nossos vizinhos em Massachusetts, New Hampshire, Maine e Vermont confiam para as terapias de infusão domiciliar necessárias para uma recuperação rápida e confortável em casa.

Descrição

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

🎯 Requisitos

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

🏖️ Benefícios

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