Data Engineer (Reporting & Analytics) — United States

About The Company

Cobalt Benefits Group has been recognized as one of the Best Companies to Work for in NH 2026 by NH Business Magazine. As a trusted third-party administrator (TPA) specializing in self-funded benefit plans, Cobalt Benefits Group (CBG) is dedicated to helping employers secure high-quality insurance coverage at an affordable cost. Operating through four lines of business—EBPA, Blue Benefit Administrators of Massachusetts, CBA Blue, and Great Bay Administrators—CBG leverages over 30 years of industry experience and a team of more than 300 professionals. The company collaborates closely with employers to design customized self-funded health plans, manage claims and disputes, and administer specialized programs such as FSAs, HSAs, COBRA, and retiree billing. CBG fosters a culture of teamwork and innovation, striving to deliver tailored solutions that meet the evolving needs of employers and their employees in the region.

About The Role

The Reporting Data Engineer plays a critical role in designing, developing, and maintaining data warehouse, integration, reporting, and monitoring solutions that ensure trusted data is readily available for client, operational, financial, management, and regulatory purposes. This position works closely with analysts, business stakeholders, vendors, and technical teams to enhance data quality, automate recurring processes, reduce technical debt, and build scalable reporting capabilities. The ideal candidate will be responsible for creating robust data models, ETL processes, and reports, while implementing automated validation and monitoring systems to ensure data integrity and reliability. This role also involves assessing legacy systems for improvement opportunities and adopting emerging technologies, including AI-enabled tools, to optimize development and reporting workflows.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field; equivalent relevant experience may be considered.

• Minimum of 4 years of progressive experience in data engineering, database development, data warehousing, reporting development, systems integration, or a related technical area.

• Advanced proficiency in Microsoft SQL Server, including expertise in complex queries, stored procedures, views, performance tuning, and data transformations.

• Hands-on experience developing and maintaining ETL or data integration processes using SSIS, Visual Studio, or comparable tools.

• Strong knowledge of data warehouse design, data modeling, scheduled job management, reporting datasets, and reporting platforms such as SSRS, Actuate/OpenText, or Power BI.

• Proven ability to troubleshoot complex data, reporting, ETL, and integration issues with implementation of validation, reconciliation, logging, and error-handling mechanisms.

• Excellent communication skills with the ability to translate business requirements into practical technical solutions and manage multiple priorities independently.

Preferred Qualifications

• Experience in healthcare, insurance, pharmacy benefit management, employee benefits, or other regulated industries, with knowledge of HIPAA, PHI, data privacy, security, and audit standards.

• Experience creating, deploying, maintaining, or troubleshooting Actuate/OpenText reports.

• Familiarity with data integration via APIs, SFTP, flat files, vendor feeds, Salesforce or other CRM platforms, and SaaS systems.

• Experience with modern Microsoft data and analytics technologies such as Power BI, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, VB, dbt, PostgreSQL, or comparable tools, including responsible use of AI-enabled tools.

Responsibilities

• Design, develop, enhance, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and associated technical infrastructure to provide reliable access to approved data for Reporting Analysts and business users.

• Support the development, deployment, maintenance, and troubleshooting of reports using Actuate/OpenText, SSRS, Power BI, or comparable reporting platforms.

• Integrate data from internal and external systems by designing, implementing, maintaining, and troubleshooting inbound and outbound electronic data feeds including claims, pharmacy benefit, vendor, Salesforce, and other operational platforms.

• Build automated validation, reconciliation, logging, monitoring, and exception-based alerting systems for data loads, feeds, reports, and scheduled processes; investigate discrepancies and failures, identify root causes, and implement durable improvements.

• Assess legacy reports, ETL processes, SQL logic, and manual workflows to reduce technical debt, improve performance, eliminate duplicate efforts, and standardize business logic.

• Partner with analysts, business owners, vendors, and technical teams to translate reporting and operational needs into practical technical solutions.

• Maintain source control, change management, testing, deployment, documentation, and audit compliance for data and reporting assets.

• Research and responsibly apply emerging tools, including AI-enabled technologies, to enhance development, documentation, testing, troubleshooting, monitoring, and reporting processes.

Benefits

After successfully completing a waiting period, eligible full-time employees gain access to a comprehensive benefits package that includes:

• Competitive medical, dental, and vision insurance plans.

• Twice annual employer HSA contributions covering 50% of the HDHP plan's annual deductible.

• Company-provided Basic Life and AD&D insurance.

• Company-paid Short-Term and Long-Term Disability coverage.

• Flexible Spending Accounts (FSAs).

• 401(k) Retirement Plan with up to a 6% employer match, fully vested after 3 years.

• More than 10 paid holidays annually.

• Fully paid half-day Summer Fridays.

• Generous paid vacation and sick time policies.

• Annual paid volunteer day.

• Tuition reimbursement program.

• Annual health and wellness reimbursement.

• Engaging company events fostering team spirit and collaboration.

Equal Opportunity

Cobalt Benefits Group is an Equal Employment Opportunity employer. We are committed to creating an inclusive environment for all employees and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected status. CBG participates in E-Verify to confirm the employment eligibility of all new hires and ensures compliance with all applicable federal, state, and local laws regarding nondiscrimination and equal opportunity in employment.