Sr. Data Engineer, Payment Operations

LE013 Zelis Payments, LLC; St. Louis (MO); Hybrid; USD 127,000 - 161,000; Full time

Benefits offered by this job

401k match

PTO

Holidays

Parental leave

Life insurance

Health benefits

Job summary

Zelis invites a Senior Data Engineer to lead Snowflake-driven data pipelines supporting Payment Operations monitoring. You will design, build, and maintain the KPI infrastructure used for executive reporting across platforms.

You’ll serve as the Snowflake SME, guiding operations in data literacy, architecture documentation, and practical SQL practices with onshore and offshore teams.

Qualifications

• Bachelor's degree or equivalent professional experience.
• 7 years of data engineering experience; 3+ years in Snowflake environments.
• Expert SQL including recursive CTEs, procedures, performance tuning.
• Snowflake-native patterns: Snowpipe, streams & tasks, clustering, virtual warehouses.
• Ability to quickly understand unfamiliar data architectures and map data flows.
• Experience building production data pipelines and monitoring workflows.
• Experience with enterprise schedulers (Automic, Airflow, dbt Cloud).

Responsibilities

• Design, build, and maintain Snowflake tables and pipelines for payment monitoring.
• Develop stored procedures, delay thresholds, business-day timing, and diagnostic tagging.
• Maintain the analysis-ready platform table for top-down alerting across payment lifecycle.
• Activate monitoring scenarios in sequenced sprints based on cost, risk, revenue exposure.
• Design and maintain KPI computation pipelines with joins across tables and sources.
• Establish data quality controls including forward-fill logic and validation checks.
• Lead Snowflake guidance and knowledge transfer with onshore/offshore partners.
• Document data architecture, schemas, data flows, and runbooks.

Skills

SQL proficiency

Snowflake expertise

Data pipelines

Production workloads

Workflow scheduling

Data governance

BI tooling familiarity

Education

Bachelor's degree in Computer Science / Information Systems / Data Engineering

Tools

Automic

Airflow

dbt Cloud

Job description

A Little About Us

Zelis is modernizing the healthcare financial experience across payers, providers, and healthcare consumers. We serve more than 750 payers, including the top five national health plans, regional health plans, TPAs and millions of healthcare providers and consumers across our platform of solutions. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts - driving real, measurable results for clients. At Zelis, AI is woven into the fabric of how we work. Every associate is expected - and empowered - to partner with AI to challenge the status quo, accelerate innovation, and amplify their impact. This is a place for builders with a growth mindset who act with agility, embrace change, and use modern technology to shape smarter solutions, exceptional experiences, and the future of our industry for our clients, customers, and our culture.

A Little About You

You bring a unique blend of personality and professional expertise to your work, inspiring others with your passion and dedication. Your career is a testament to your diverse experiences, community involvement, and the valuable lessons you've learned along the way. You are more than just your resume; you are a reflection of your achievements, the knowledge you've gained, and the personal interests that shape who you are.

Position Overview

The Senior Data Engineer leads the engineering workstreams that underpin the Payment Operations monitoring transformation program at Zelis. This role designs, builds, and maintains Snowflake data pipelines; activates payment monitoring scenarios; and delivers the KPI infrastructure used for executive reporting across multiple platforms. As the primary Snowflake subject matter expert for Payment Operations, the role also strengthens data literacy, documents the data architecture, and provides technical guidance that enables the broader operations organization to use data more independently.

Key Responsibilities

• Payment Monitoring Engineering: Design, build, deploy, and maintain Snowflake tables and pipelines that support payment monitoring.
• Develop stored procedures, status-specific delay thresholds, business-day aware timing windows, and root cause diagnostic tagging.
• Maintain the combined platform monitoring table that supports top-down alerting across the full payment lifecycle.
• Monitoring Scenario Activation: Execute activation of inactive monitoring scenarios in sequenced sprints with prioritization based on cost, risk, and revenue exposure.
• KPI Infrastructure: Design and maintain the Payment Lifecycle KPI calculation pipeline, including query logic, data joins across tables and source payment records, and automated refresh cadence - with slicing by any required dimension such as platform, payer, and payment modality.
• Data Quality Management: Establish and maintain data quality controls within payment pipelines, including forward-fill logic, export grouping, source system column validation, and definitional consistency checks between payment-related data sources.
• Technical Leadership and Enablement: Serve as the primary Snowflake subject matter expert for Payment Operations. Lead working sessions with onshore and offshore partners to build practical SQL and Snowflake proficiency, review technical approaches, and promote maintainable engineering practices.
• Architecture and Documentation: Document the Payment Operations data architecture, including platform schemas, table structures, data flows, dependencies, stored procedures, operational runbooks, and monitoring logic to ensure knowledge is accurate, transferable, and sustainable.
• Cross-Functional Partnership: Translate business monitoring needs into scalable technical solutions and communicate technical findings, risks, tradeoffs, and recommendations in clear language to operations leaders and non-technical stakeholders.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related technical field; or equivalent professional experience in lieu of degree.
• 7 years of experience in data engineering, with at least 3 years in production Snowflake environments.
• Expert SQL proficiency, including recursive common table expressions, stored procedures, and performance tuning on large-scale datasets.
• Hands-on experience with Snowflake-native patterns, including Snowpipe, streams and tasks, clustering, and virtual warehouse configuration.
• Demonstrated ability to absorb an unfamiliar data architecture quickly – reading existing schemas, reverse-engineering legacy stored procedures, and mapping undocumented data flows.
• Experience building and supporting production data pipelines, monitoring workflows, automated batch processes, and data quality controls.
• Experience with enterprise job scheduling tools such as Automic, Airflow, or dbt Cloud for managing production batch workloads.

Preferred Skills

• Experience working as an embedded data engineer within a business operations team, with the ability to translate technical work into plain language for non-technical colleagues.
• Comfort working with AI tools and applying them to accelerate data engineering workflows, analysis, and documentation.
• Experience in healthcare payment processing, including ACH, EDI 835 delivery, virtual card (VCC or VRA), or provider payment disbursement workflows.
• Familiarity with SIGMA or equivalent cloud-native BI platforms (Looker, Hex, or similar) connected to a Snowflake backend.
• Exposure to HIPAA-compliant data handling practices and healthcare data governance frameworks.
• Experience conducting peer reviews of Python, SQL or pipeline code in a cross-functional setting.
• Snowflake SnowPro Core or Advanced certification.

Location and Workplace Flexibility

Zelis is headquartered in the U.S., with multiple locations across the country and in Hyderabad, India. All employee work locations are based on the needs of the position and are determined by the Leadership team. In-office work and activities vary based on work and team objectives in accordance with Company policies. While location expectations vary by role, candidates within approximately 50 miles of a U.S. office are generally preferred to support collaboration when needed. Our hybrid approach is flexible, and in-office presence is guided by team and business needs rather than a fixed weekly schedule.

Base Salary Range

Base Salary Range $127,000.00 - $160,550.00

Benefits

• 401k plan with employer match
• flexible paid time off
• holidays
• parental leaves
• life and disability insurance
• health benefits including medical, dental, vision, and prescription drug coverage

Equal Employment Opportunity

Equal Employment Opportunity Zelis is proud to be an equal opportunity employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

We welcome applicants from all backgrounds and encourage you to apply even if you don’t meet 100% of the qualifications for the role.

We believe in the value of diverse perspectives and experiences and are committed to building an inclusive workplace for all.

Accessibility Support

Accessibility Support We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability or a disabled veteran and require a reasonable accommodation with any part of the application and/or interview process, please email [e-mail].

Recruitment Process

Zelis maintains a transparent, fee-free recruitment process. All genuine offers originate from our Talent Acquisition team using the "@zelis.com" domain. We do not use WhatsApp or personal emails for recruitment. Forward any suspected fraud to [e-mail] for prompt investigation. Thank you for staying vigilant.