Data Engineer, Reporting & Analytics — United States

About Our Client:

The organization operates as a third-party administrator specializing in self-funded benefit plans, addressing the challenge employers face in securing high-quality, affordable insurance coverage. With over 30 years of experience and a team exceeding 300 employees, the company manages customized health plans, claims, and specialized programs such as FSAs, HSAs, COBRA, and retiree billing, thereby supporting employers across its region with tailored employee benefits solutions.

About the Opportunity:

The DATA ENGINEER, REPORTING & ANALYTICS is responsible for designing, developing, and maintaining data warehouse and reporting solutions that provide accurate and trusted data to support operational, financial, management, and regulatory needs. This role significantly impacts the organization by ensuring data quality, automating processes, reducing technical debt, and enabling scalable reporting capabilities that support business decision-making.

Responsibilities:

• Design and maintain data warehouse processes, reporting datasets, data models, and SQL objects.

• Develop and troubleshoot reports using reporting platforms such as Actuate/OpenText, SSRS, and Power BI.

• Integrate data from internal and external systems and manage electronic data feeds.

• Implement automated validation, reconciliation, logging, monitoring, and alerting mechanisms for data processes.

• Assess and improve legacy reports, ETL processes, and workflows to reduce technical debt.

• Collaborate with analysts, business owners, vendors, and technical teams to translate needs into technical solutions.

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

• Research and apply emerging tools, including AI-enabled solutions, to enhance development and reporting.

Requirements:

• Bachelor's degree in a relevant field or equivalent experience.

• Minimum 4 years of experience in data engineering, database development, or related technical roles.

• Advanced skills with Microsoft SQL Server, including complex queries and ETL development.

• Strong knowledge of data warehouse design, data modeling, and reporting platforms.

• Proven ability to troubleshoot complex data and integration issues.

• Effective communication skills and ability to deliver accurate work independently.

Pay Range and Compensation Package:

• The pay range and compensation package for this role will be determined based on the candidate's experience, skills, and other relevant factors.

Benefits & Perks:

• Medical, dental, and vision insurance.

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

• Flexible Spending Accounts.

• 401(k) Retirement Plan with up to a 6% employer match, fully vested after 3 years.

• Paid holidays, vacation, sick time, and volunteer day.

• Half-day Summer Fridays.

• Tuition reimbursement and health and wellness reimbursement.

• Various company events.

Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

Note:

2HnaFw7wQXyF is a recruitment partner of this role. Please note that all employment decisions, including candidate assessment, interviews, hiring, compensation, and employment terms, are made exclusively by the hiring employer.