Data Engineer – Reporting & Analytics

Cobalt Benefits Group, LLC (DBA: Blue Benefit Administrators, CBA Blue & EBPA)

. Design, develop, enhance, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and related technical infrastructure.

Posted 11/6/2026full-timeRemote • North Carolina • United StatesMid-LevelSenior💰 $85,000 - $125,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced proficiency in Microsoft SQL Server and ETL processes, with a strong focus on data warehouse design, reporting development, and systems integration. Capable of translating business needs into technical solutions while ensuring compliance with data privacy and security regulations.

Highest-signal resume keywords

Microsoft SQL ServerETL Development Using SSISData Warehouse DesignReporting Development With Power BIHealthcare Industry Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data EngineeringDatabase DevelopmentData WarehousingSQL QueriesData ModelingPerformance OptimizationData TransformationsTroubleshooting ETL IssuesIntegration Through APIsData Validation

Soft Skills

Communication With StakeholdersIndependent WorkPrioritization

Tools & Technologies

Actuate/OpenTextSSRSPower BIAzure Data FactoryMicrosoft FabricGitAzure DevOpsPythonPowerShellPostgreSQL

Industry Keywords

HealthcareInsurancePharmacy Benefit ManagementData PrivacyHIPAAPHIAudit Requirements

Tech Stack

Tools & technologies

AzureETLMS SQL ServerPostgresPythonSQLSSIS

About the role

Key responsibilities & impact

Design, develop, enhance, and maintain data warehouse processes, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and related technical infrastructure.
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 manage 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.

Requirements

What you’ll need

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

Benefits

Comp & perks

Website LinkedIn All Job Openings 51 - 200 employees 💼 Consulting ⚖️ Legal 🛡️ Insurance Consulting
Legal
Insurance Cobalt Benefits Group, LLC (DBA: Blue Benefit Administrators, CBA Blue & EBPA) is a full service Third Party Administrator (TPA) that specializes in the customization, marketing, and operation of self-funded employee benefit plans. With over 30 years of experience and a team of over 195 employees, CBG provides a wide array of products and services including self-funded medical and dental plans, Flexible Spending Accounts, Health Reimbursement Arrangements, and COBRA management. CBG aims to assist employers in building custom benefit plans while managing costs and ensuring compliance with regulations.