Data Engineer – Reporting & Analytics

This is a fully remote position, open to applicants in North Carolina.

📋 Description

• Design, develop, enhance, and maintain processes for data warehousing, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and associated technical infrastructure.

• Assist in the development, deployment, maintenance, and troubleshooting of reports utilizing Actuate/OpenText, SSRS, Power BI, or similar reporting platforms.

• Integrate data from both internal and external systems, managing inbound and outbound electronic data feeds, including claims, pharmacy benefits, vendor data, Salesforce, and other operational platforms.

• Create automated processes for validation, reconciliation, logging, monitoring, and exception-based alerts for data loads, feeds, reports, and scheduled tasks.

• Investigate discrepancies and failures, determine root causes, and implement sustainable improvements.

• Evaluate legacy reports, ETL processes, SQL logic, and manual workflows to minimize technical debt, enhance performance, eliminate redundancy, and standardize business logic.

• Collaborate with analysts, business owners, vendors, and technical teams to convert reporting and operational requirements into effective technical solutions.

• Maintain practices for source control, change control, testing, deployment, documentation, and auditing of data and reporting assets.

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

⛳️ Requirements

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

• 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 in Microsoft SQL Server, including complex queries, stored procedures, views, performance optimization, and data transformations, with practical experience in developing and maintaining ETL or data-integration processes using SSIS, Visual Studio, or similar tools.

• Strong understanding of data warehouse design, data modeling, scheduled jobs, reporting datasets, and reporting platforms like SSRS, Actuate/OpenText, or Power BI.

• Proven ability to troubleshoot complex issues related to data, reporting, ETL, and integration, while implementing reliable validation, reconciliation, logging, and error-handling controls.

• Capability to translate business requirements into practical technical solutions, communicate effectively with both technical and non-technical stakeholders, manage multiple priorities, and deliver precise work independently.

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

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

• Experience in data integration through APIs, SFTP, flat files, vendor feeds, Salesforce or other CRM platforms, or other SaaS applications.

• Familiarity 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 similar tools, with responsible use of AI-enabled tools.

🏝️ Benefits

• Exceptional medical, dental, and vision coverage

• Biannual employer HSA contributions, covering 50% of the HDHP plan’s annual deductible

• Company-provided Basic Life and AD&D insurance

• Company-funded Short-Term and Long-Term Disability

• Flexible Spending Accounts

• 401(k) Retirement Plan with up to a 6% employer match

• Over 10 paid holidays

• Fully paid half-day Summer Fridays

• Generous paid vacation and sick leave

• Annual Paid Volunteer Day

• Annual Tuition Reimbursement

• Annual Health and Wellness Reimbursement

• Numerous enjoyable company events