Data Engineer

TaskVerse; EUA; Presencial; USD 110 000 - 150 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical, dental, and vision insurance

HSA contributions twice yearly

Life and AD&D insurance

Short- and long-term disability

Flexible spending accounts

401(k) with up to 6% match

Paid holidays and vacation; wellness/é

Resumo da oferta

Cobalt Benefits Group LLC seeks a Reporting Data Engineer to design, develop, and support data warehouse, integrations, and reporting that power decisions across the organization.

You will work with analysts, vendors, and tech teams to improve data quality, automate processes, and reduce tech debt while delivering scalable reporting capabilities.

Qualificações

• Bachelor’s degree or equivalent experience in a technical field.
• 4+ years in data engineering, data warehousing or related work.
• Advanced SQL Server skills with complex queries and data transformations.
• Experience ETL/ data integration with SSIS, Visual Studio, or similar tools.
• Knowledge of data warehouse design, modeling, and reporting datasets.
• Familiarity with Power BI, SSRS/OpenText, or similar reporting platforms.
• Experience with APIs, SFTP, vendor feeds, Salesforce or SaaS data sources.
• Strong troubleshooting, communication, and independent work skills.
• Healthcare/benefits industry knowledge and HIPAA privacy familiarity is a plus.

Responsabilidades

• Design, develop, and maintain data warehouse processes and data models.
• Enable reliable reporting for analysts with validated datasets and reports.
• Build data integration, ETL packages, and scheduled jobs; monitor loads and logs.
• Collaborate with stakeholders to translate needs into practical solutions.
• Maintain source control, testing, and audit practices; explore AI-enabled tooling.

Conhecimentos

Advanced SQL Server

ETL/Data Integration

Data Warehousing

Power BI

API/SFTP/SaaS data feeds

Python/PowerShell/C# scripting

Git / Azure DevOps

Troubleshooting / debugging

Formação académica

Bachelor’s degree in CS / IS / data analytics or related

Ferramentas

SSIS

Visual Studio

SSRS OpenText Power BI tooling

Azure Data Factory

Power BI

Git

Azure DevOps

dbt

PostgreSQL

Descrição da oferta de emprego

About The Company

Cobalt Benefits Group LLC (CBG) is a trusted third-party administrator specializing in self-funded employee benefit plans. With more than 30 years of experience and a team of over 300 employees, CBG works with employers to deliver customized benefit solutions and administer health claims, disputes, and programs such as flexible spending accounts, health savings accounts, COBRA, and retiree billing. Through its four lines of business—EBPA, Blue Benefit Administrators of Massachusetts, CBA Blue, and Great Bay Administrators—the company helps employers provide high-quality coverage at a cost they can afford. CBG was named one of the Best Companies to Work for in New Hampshire in 2026 by NH Business Magazine.

About The Role

Cobalt Benefits Group is seeking a Reporting Data Engineer to design, develop, and support the data warehouse, integrations, reporting, and monitoring solutions that power informed decisions across the organization. In this role, you will make trusted data available for client, operational, financial, management, and regulatory needs. You will work closely with analysts, business stakeholders, vendors, and technical teams to improve data quality, automate recurring processes, reduce technical debt, and build scalable reporting capabilities. The successful candidate is curious, collaborative, self-directed, and committed to dependable, well-documented delivery.

Qualifications

A bachelor’s degree in computer science, information systems, data analytics, engineering, mathematics, or a related field is preferred; equivalent relevant experience may be considered. Candidates should bring at least four years of progressively responsible experience in data engineering, database development, data warehousing, reporting, systems integration, or a related technical discipline. Advanced Microsoft SQL Server skills are required, including complex queries, stored procedures, views, performance optimization, and data transformations. You should have hands‑on experience developing and maintaining ETL or data integration processes with SSIS, Visual Studio, or comparable tools, as well as working knowledge of data warehouse design, data modeling, scheduled jobs, reporting datasets, and platforms such as SSRS, Actuate/OpenText, or Power BI. Strong troubleshooting, communication, prioritization, and independent work skills are essential. Healthcare, insurance, pharmacy benefit management, employee benefits, or other regulated-industry experience is preferred, particularly familiarity with HIPAA, PHI, privacy, security, and audit requirements. Experience with APIs, SFTP, vendor feeds, Salesforce, or other SaaS platforms is an asset. Familiarity with Power BI, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, VB, dbt, PostgreSQL, or comparable tools is also valued.

Responsibilities

Design, develop, enhance, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and supporting infrastructure. Help Reporting Analysts and business users access reliable, approved data, and support the deployment, maintenance, and troubleshooting of reports using Actuate/OpenText, SSRS, Power BI, or comparable platforms.

Integrate information from internal and external systems and manage inbound and outbound data feeds, including claims, pharmacy benefit, vendor, Salesforce, and operational data. Build validation, reconciliation, logging, monitoring, and exception‑alerting controls for loads, feeds, reports, and scheduled processes. Investigate errors, identify root causes, and implement durable improvements.

Assess legacy reports, ETL, SQL logic, and manual workflows to improve performance, standardize business logic, eliminate duplicate effort, and reduce technical debt. Partner with business owners, analysts, vendors, and technical teams to translate needs into practical solutions. Maintain source control, testing, change control, deployment, documentation, and audit practices. Research and responsibly apply emerging and AI‑enabled tools to improve development, testing, documentation, troubleshooting, and monitoring.

Benefits

• medical, dental, and vision insurance
• twice-yearly employer HSA contributions covering 50% of the HDHP annual deductible
• company-provided basic life and AD&D insurance
• company-paid short- and long-term disability
• flexible spending accounts
• 401(k) plan with an employer match of up to 6%, fully vested after three years
• 10 or more paid holidays, paid half-day Summer Fridays, generous vacation and sick time, an annual volunteer day, tuition and wellness reimbursements, and company events

Equal Opportunity

Cobalt Benefits Group LLC is an equal opportunity employer, including disability and protected veteran status. The company participates in E-Verify to confirm the employment eligibility of all new hires.