Data Engineer, Reporting & Analytics

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

📋 Description

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

• Provide support for the development, deployment, maintenance, and troubleshooting of reports using Actuate/OpenText, SSRS, Power BI, or similar platforms.

• Integrate data from both internal and external systems while managing inbound and outbound electronic data feeds.

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

• 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 and enhance performance.

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

• Manage source control, change-control, testing, deployment, documentation, and audit practices.

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

⛳️ Requirements

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

• A minimum of 4 years of progressively responsible experience in data engineering, database development, data warehousing, reporting development, systems integration, or a related technical field.

• Advanced expertise in Microsoft SQL Server, encompassing complex queries, stored procedures, views, performance optimization, and data transformations.

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

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

• Capability to troubleshoot intricate data, reporting, ETL, and integration challenges and implement validation, reconciliation, logging, and error-handling controls.

• Proficiency in translating business requirements into technical solutions, effectively communicating with both technical and non-technical stakeholders, managing multiple priorities, and delivering accurate work independently.

• Preferred: Experience in healthcare, insurance, pharmacy benefit management, employee benefits, or another regulated industry, including HIPAA, PHI, data privacy, security, and audit standards.

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

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

• Preferred: Familiarity with Power BI, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, VB, dbt, PostgreSQL, comparable tools, and the responsible use of AI-enabled technologies.

• Personal attributes: curious, collaborative, self-directed, detail-oriented, adaptable, and focused on practical, sustainable improvements.

🏝️ Benefits

• Exceptional medical, dental, and vision insurance.

• Biannual employer contributions to HSA, 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.

• 401(k) Retirement Plan with an employer match of up to 6%.

• Fully vested after 3 years.

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

• Enjoyable company events.