Data Engineer: Analytics, Reporting & ETL Specialist

Cobalt Benefits Group, LLC; Raleigh (NC); On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

HSA contributions

401(k) Retirement Plan with employer-m

Paid holidays

Tuition 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 ensure trusted data for client, operational, financial, and regulatory needs while collaborating with analysts and vendors.

The role focuses on automating processes, reducing technical debt, and building scalable reporting capabilities using SQL Server, SSIS, Power BI, SSRS, and modern data tools.

Qualifications

• Bachelor's degree in CS/IS/Data Analytics/Engineering/Math or related field; equivalent experience may be considered.
• At least 4 years of progressive data engineering/warehousing experience.
• Advanced SQL Server skills including complex queries and ETL development.

Responsibilities

• Design, develop, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and related infrastructure.
• Support the development, deployment, maintenance, and troubleshooting of reports using SSRS, Power BI, or Actuate/OpenText.
• Integrate data from internal and external systems and design, implement, maintain, and troubleshoot data feeds.
• Build automated validation, reconciliation, logging, monitoring, and alerting for data loads, feeds, reports, and processes; investigate discrepancies and failures.
• Assess legacy reports, ETL processes, SQL logic, and manual workflows to reduce technical debt and standardize business logic.
• Partner with analysts and stakeholders to translate reporting and operational needs into technical solutions.
• Maintain source control, change-control, testing, deployment, documentation, and audit practices.
• Research and apply emerging tools including AI-enabled tools to improve development and reporting.

Skills

SQL Server

SSIS

Data modeling

ETL development

Reporting platforms

Problem solving

Stakeholder communication

Education

Bachelor's degree

Equivalent experience

Tools

Power BI

SSRS

Actuate/OpenText

Azure Data Factory

Git

Azure DevOps

Python

PowerShell

dbt

PostgreSQL

Job description

Cobalt Benefits Group, LLC is seeking a Reporting Data Engineer to design, develop, and support data warehouse, integration, and reporting solutions. You will ensure trusted data for client, operational, financial, and regulatory needs while collaborating with analysts and vendors.

The role focuses on automating processes, reducing technical debt, and building scalable reporting capabilities using SQL Server, SSIS, Power BI, SSRS, and modern data tools.