Senior Data Engineer

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

📋 Description

• Design, develop, optimize, and maintain scalable ETL pipelines and data integration solutions for enterprise reporting, analytics, and data delivery.

• Create and enhance complex SQL queries, stored procedures, data transformations, and data models utilizing Amazon Redshift and Microsoft SQL Server.

• Revamp legacy SQL Server and SSRS reporting solutions by transitioning pipelines, reporting processes, and analytics capabilities to AWS architectures.

• Design and oversee cloud-based data warehouses leveraging Amazon Redshift and AWS services.

• Develop governed data models, datasets, and data products for Tableau reporting, enterprise analytics, and self-service access.

• Construct scalable data extraction, file delivery, and reporting solutions to minimize manual processes and enhance data delivery reliability.

• Analyze and refine ETL workflows, SQL queries, data models, and warehouse performance.

• Collect requirements from business and technical stakeholders and convert them into scalable technical solutions.

• Implement data security measures, role-based access controls, and governance standards.

• Monitor, troubleshoot, and address data pipeline, data quality, performance, and reporting challenges.

• Employ source control, code review, testing, CI/CD, documentation, and automation practices.

• Assess cloud-native services, automation, and AI-assisted development tools.

• Collaborate with Data, Engineering, Product, and business teams to create sustainable data solutions and advance the enterprise data platform.

⛳️ Requirements

• Bachelor's degree in Data Management, Information Systems, Computer Science, Analytics, or a related field required, or an equivalent combination of education and experience.

• 7+ years of experience in ETL development, data engineering, business intelligence, data warehousing, or a related discipline required.

• Practical experience in designing, developing, optimizing, and supporting enterprise data warehouse and ETL solutions, including Amazon Redshift, required.

• Advanced SQL development skills, including complex query creation, data transformation, and performance optimization required.

• Strong understanding of data warehousing concepts, dimensional modeling, enterprise reporting architectures, and large-scale data processing required.

• Experience in gathering business requirements and converting them into scalable data integration, reporting, and analytics solutions required.

• Experience with Microsoft SQL Server, including legacy data extraction and migration support, required.

• Experience with SSRS and the migration of legacy SQL Server/SSRS environments to modern cloud-based data platforms preferred.

• Experience in developing cloud-native data pipelines using AWS Glue, S3, Lambda, Athena, ECS/EKS, or similar technologies preferred.

• Experience in creating Tableau dashboards, semantic data models, governed data products, and enterprise self-service analytics solutions preferred.

• Experience in implementing data governance, role-based security, Git, CI/CD pipelines, and modern software development practices preferred.

• Experience in PBM, healthcare, pharmacy claims, 340B, rebate, or claims adjudication environments preferred.

• Familiarity with AI-assisted development tools or creating AI-enabled automation, analytics, monitoring, or reporting solutions preferred.

• Candidates must be able to articulate all experience listed clearly and confidently.

• Work samples, portfolio links, or other forms of validation may be requested.

• Successful completion of a pre-employment background check, including employment and education verification, and a 4-panel drug screen is required for offers.

🏝️ Benefits

• Recognized as the Best Employer in Ohio for the 5th consecutive year in 2025.

• Engaging work that contributes to enhancing healthcare quality and efficiency.

• Collaborative work environment.

• Fully remote work opportunity.

• Pre-employment background check and 4-panel drug screen as offer contingencies.