Data Engineer, Reporting & Analytics

Cobalt Benefits Group LLC

United States

Remote

USD 90,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, dental, vision insurance
HSA contributions
401(k) with company match
Paid holidays
Tuition reimbursement
Wellness reimbursement

Job summary

Cobalt Benefits Group LLC is seeking a Reporting Data Engineer to design, develop, and support data warehouse, integration, and reporting solutions. You will work with Analysts and stakeholders to improve data quality and automate processes.

The role focuses on SQL, ETL, and reporting platforms like SSRS, Power BI, and Actuate/OpenText, with opportunities to apply emerging AI tools.

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or equivalent experience.
  • At least 4 years of data engineering, data warehousing, or related technical experience.

Responsibilities

  • Design, develop, and maintain data warehouse processes and reporting datasets.
  • Support reports via SSIS, SSRS, Power BI, Actuate/OpenText, or equivalents.

Skills

SQL
ETL
Power BI
SSRS
Actuate/OpenText
Data modeling
Python
Azure Data Factory
Git
Azure DevOps
dbt
PostgreSQL
Visual Studio
C#
VB

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS
Visual Studio
Power BI
SSRS
Actuate/OpenText
Azure Data Factory
Git
Azure DevOps
dbt
PostgreSQL

Job description

The Reporting Data Engineer designs, develops, and supports data warehouse, integration, reporting, and monitoring solutions that make trusted data available for client, operational, financial, management, and regulatory needs. This role partners with analysts, business stakeholders, vendors, and technical teams to improve data quality, automate recurring processes, reduce technical debt, and build scalable reporting capabilities.

Responsibilities
  • Design, develop, enhance, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and related technical infrastructure that give Reporting Analysts and business users reliable access to approved data.
  • 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 and design, implement, maintain, and troubleshoot 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 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 effort, 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-control, testing, deployment, documentation, and audit practices for data and reporting assets.
  • Research and responsibly apply emerging tools, including AI-enabled tools, to improve development, documentation, testing, troubleshooting, monitoring, and reporting.
  • Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field; equivalent relevant experience may be considered.
  • At least 4 years of progressively responsible experience in data engineering, database development, data warehousing, reporting development, systems integration, or a related technical role.
  • Advanced proficiency with Microsoft SQL Server, including complex queries, stored procedures, views, performance optimization, and data transformations, with hands‑on experience developing and maintaining ETL or data‑integration processes using SSIS, Visual Studio, or comparable tools.
  • Strong working knowledge of data warehouse design, data modeling, scheduled jobs, reporting datasets, and reporting platforms such as SSRS, Actuate/OpenText, or Power BI.
  • Demonstrated ability to troubleshoot complex data, reporting, ETL, and integration issues and implement reliable validation, reconciliation, logging, and error‑handling controls.
  • Ability to translate business needs into practical technical solutions, communicate with technical and non-technical stakeholders, manage multiple priorities, and deliver accurate work independently.
Preferred Qualifications
  • Experience in healthcare, insurance, pharmacy benefit management, employee benefits, or another regulated industry, including familiarity with HIPAA, PHI, data privacy, security, and audit requirements.
  • Experience creating, deploying, maintaining, or troubleshooting Actuate/OpenText reports.
  • Experience integrating data through APIs, SFTP, flat files, vendor feeds, Salesforce or another CRM platform, or other SaaS platforms.
  • Experience with modern Microsoft data, analytics, development, and source-control technologies, including 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.
Personal Attributes

The successful candidate will be curious, collaborative, self-directed, detail-oriented, adaptable, and focused on practical, sustainable improvements. They will take ownership of quality, documentation, testing, communication, and reliable delivery while translating effectively between technical detail and business needs.

Benefits

After successfully completing a waiting period, eligible Full-time employees have access to our comprehensive benefits package, including:

  • Fantastic medical, dental, and vision insurance*
  • Twice annual employer HSA contributions, covering 50% of the HDHP plan’s annual deductible!
  • Company provided Basic Life and AD&D
  • Company paid Short-Term and Long-Term Disability**
  • Flexible Spending Accounts*
  • 401(k) Retirement Plan with up to a 6% employer-match** WOW! (100% fully vested after 3 years)
  • 10+ paid holidays
  • Fully Paid half day Summer Fridays
  • Generous paid vacation and sick time
  • Annual Paid Volunteer Day
  • Annual Tuition Reimbursement
  • Annual Health and Wellness Reimbursement
  • Lots of fun company events

*60 day waiting period**90 day waiting period

Who We Are

Cobalt Benefits Group has been named 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 committed to helping employers find high‑quality coverage at a cost they can afford. We administer self‑funded insurance benefits through our four lines of business: EBPA, Blue Benefit Administrators of Massachusetts, CBA Blue, and Great Bay Administrators. With over 30 years of experience and a dedicated team of more than 300 employees, we work collaboratively to build customized self‑funded health plans, manage claim payments and disputes, and administer other specialized programs such as FSAs, HSAs, COBRA, and retiree billing. Join us as we match employers across our region with the right solutions for their employee benefit needs. To learn more about working at CBG, visit https://www.cobaltbenefitsgroup.com/careers/.

Cobalt Benefits Group is an Equal Employment Opportunity employer

Cobalt Benefits Group participates in E-Verify to confirm the employment eligibility of all new hires.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer, Reporting & Analytics
Data Engineer, Reporting & Analytics

Cobalt Benefits Group, LLC • New Hampshire

On-site
USD 90,000 - 130,000
Medical insurance
Dental and vision insurance
Retirement plan with match
+5
Data Engineer, Reporting & Analytics
Data Engineer, Reporting & Analytics

Cobalt Benefits Group, LLC • Raleigh (NC)

On-site
USD 90,000 - 150,000
Medical insurance
HSA contributions
401(k) Retirement Plan with employer-m
+2
Data Engineer, Reporting & Analytics
Data Engineer, Reporting & Analytics

Cobalt Benefits Group, LLC • Bogart (GA)

On-site
USD 100,000 - 140,000
Fantastic medical, dental, and vision
HSA contributions
401(k) with employer match
+5
AI Developer
AI Developer

Cobalt Benefits Group, LLC • Atlanta (GA)

On-site
USD 120,000 - 180,000
Fantastic medical, dental, and vision
Twice annual employer HSA contribution
Company provided Life and AD&D
+8
AI Developer
AI Developer

Cobalt Benefits Group • United States

Remote
USD 120,000 - 160,000
Medical Insurance
401(k) Retirement Plan with match
Paid time off
Senior Stop Loss Specialist
Senior Stop Loss Specialist

Cobalt Benefits Group, LLC • Boston (MA)

On-site
USD 120,000 - 170,000
Medical Insurance
HSA contributions
Life Insurance
+5
Systems Support Specialist
Systems Support Specialist

Cobalt Benefits Group, LLC • Exeter (NH)

On-site
USD 60,000 - 80,000
Medical Insurance
401k Match
Paid Holidays
+2
Account Manager, Core Business
Account Manager, Core Business

Cobalt Benefits Group Llc • Exeter (NE)

On-site
USD 55,000 - 90,000
Medical, dental, and vision insurance
Employer HSA contributions
Life and AD&D insurance
+7
Healthcare Claims Quality Assurance Specialist
Healthcare Claims Quality Assurance Specialist

Cobalt Benefits Group, LLC • Portsmouth (NH)

On-site
USD 65,000 - 90,000
Medical, dental, vision insurance
HSA contributions
Life and AD&D insurance
+5
AI Developer
AI Developer

Cobalt Benefits Group LLC • Richmond (VA)

On-site
USD 120,000 - 180,000
Medical Insurance
HSA contributions
401(k) employer match
+6