Data Engineer, Reporting – Analytics

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

📋 Description

• Design, develop, enhance, and maintain processes for data warehousing, reporting datasets, data models, SQL objects, ETL packages, scheduled jobs, and related 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.

• Design, implement, maintain, and troubleshoot inbound and outbound electronic data feeds, including claims, pharmacy benefits, vendor data, Salesforce, and other operational platforms.

• 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 reduce technical debt, enhance performance, eliminate duplicate efforts, and standardize business logic.

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

• Maintain source control, change-control, testing, deployment, documentation, and audit procedures for data and reporting assets.

• Research and responsibly implement emerging tools, including AI-enabled tools, 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 also be considered.

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

• Practical experience in developing and maintaining ETL or data integration processes utilizing 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 issues.

• Ability to establish dependable validation, reconciliation, logging, and error-handling controls.

• Proficient in translating business requirements into feasible technical solutions.

• Effective communication skills with both technical and non-technical stakeholders, capable of managing multiple priorities and delivering precise work independently.

• Preferred: experience in healthcare, insurance, pharmacy benefit management, employee benefits, or another regulated industry, with familiarity in HIPAA, PHI, data privacy, security, and audit requirements.

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

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

• Preferred: familiarity with Power BI, Azure Data Factory, Microsoft Fabric, Git, Azure DevOps, Python, PowerShell, C#, VB, dbt, PostgreSQL, or similar tools, including responsible utilization of AI-enabled tools.

🏝️ Benefits

• Excellent medical, dental, and vision insurance.

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

• Flexible Spending Accounts.

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

• 100% fully vested after 3 years.

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

• Company events.