Sr Consultant - Technical lead

Vantive is a vital organ therapy company on a mission to extend lives and expand possibilities for patients and care teams everywhere. For 70 years, our team has driven meaningful innovations in kidney care. As we build on our legacy, we are deepening our commitment to elevating the dialysis experience through digital solutions and advanced services, while looking beyond kidney care and investing in transforming vital organ therapies. Greater flexibility and efficiency in therapy administration for care teams, and longer, fuller lives for patients— that is what Vantive aspires to deliver.

We believe Vantive will not only build our leadership in the kidney care space, it will also offer meaningful work to those who join us. At Vantive, you will become part of a community of people who are focused, courageous and don’t settle for the mediocre. Each of us is driven to help improve patients’ lives worldwide. Join us in advancing our mission to extend lives and expand possibilities.

·        Provide technical leadership for EDH, AWS S3 ingestion patterns, Snowflake, and enterprise data engineering delivery.

·        Own end-to-end technical design for data ingestion, transformation, orchestration, and curated data product delivery.

·        Establish reusable engineering standards, development patterns, naming conventions, code quality expectations, and operational best practices.

·        Lead technical design reviews and partner with architecture teams to ensure scalable, secure, and maintainable solutions.

·        Drive modernization toward domain-driven data architecture and trusted data products.

·        Design, develop, and maintain scalable ETL and ELT pipelines across batch, incremental, CDC, and file-based ingestion patterns.

·        Build and enhance pipelines from source systems into AWS S3 and downstream Snowflake layers.

·        Implement transformation logic, business rules, validations, enrichment, data harmonization, and audit controls.

·        Support common EDH layers and patterns such as collect, translate, curate, and Snowflake consumption layers.

·        Partner with application and BI teams to ensure data pipelines meet business reporting and analytics requirements.

·        Lead Snowflake development activities including schemas, tables, views, stages, tasks, stored procedures, streams, and secure data access patterns.

·        Optimize Snowflake performance, compute utilization, storage design, query execution, and cost efficiency.

·        Implement role-based access controls, data sharing patterns, security standards, and platform governance expectations.

·        Enable curated datasets and reusable data products for reporting, analytics, AI, and advanced analytics use cases.

·        Lead and mentor data engineers, consultants, and technical delivery teams across design, build, test, deployment, and production support.

·        Review technical designs, code, data models, and deployment packages to ensure quality and adherence to standards.

·        Manage technical dependencies across infrastructure, security, platform, application, and business teams.

·        Drive issue resolution, root-cause analysis, and operational readiness for production releases.

·        Provide hands-on technical guidance when complex pipeline, integration, performance, or data quality issues arise.

·        Implement data quality checks, reconciliation controls, observability, lineage, and monitoring across critical data pipelines.

·        Partner with data governance teams to support metadata, cataloging, ownership, access management, and compliance expectations.

·        Ensure pipelines are reliable, supportable, secure, and aligned with enterprise standards for privacy, security, and regulatory needs.

·        Create operational runbooks, support documentation, and transition materials for steady-state operations.

·        Translate business and product requirements into scalable technical solutions and delivery plans.

·        Collaborate with data architects, product owners, business SMEs, BI teams, AI/ML teams, and platform engineering groups.

·        Communicate complex technical topics clearly to both engineering teams and business stakeholders.

·        Proactively identify risks, dependencies, and design tradeoffs, and recommend practical options for resolution.

·        Bachelor's degree in Computer Science, Information Systems, Engineering, Data Analytics, or a related discipline.

·        Master's degree preferred.

·        10+ years of experience in data engineering, ETL/ELT, data warehousing, or enterprise data platform development.

·        5+ years of experience leading technical teams or enterprise-scale data delivery initiatives.

·        5+ years of hands-on experience with Snowflake development, optimization, and secure data design.

·        Strong experience with AWS data services, especially S3-based data ingestion and processing patterns.

·        Proven experience designing pipelines for large-scale enterprise reporting, analytics, and data product use cases.

We understand compensation is an important factor as you consider the next step in your career. At Vantive, we are committed to equitable pay for all employees, and we strive to be more transparent with our pay practices. The estimated base salary for this position is $152,000 - $190,000 annually. The estimated range is meant to reflect an anticipated salary range for the position. We may pay more or less than of the anticipated range based upon market data and other factors, all of which are subject to change. Individual pay is based upon location, skills and expertise, experience, and other relevant factors. For questions about this, our pay philosophy, and available benefits, please speak to the recruiter if you decide to apply and are selected for an interview.

US Benefits at Vantive

This is where your well-being matters. Vantive offers comprehensive compensation and benefits packages for eligible roles. Our health and well-being benefits include medical, dental and vision coverage that start on day one, as well as insurance coverage for basic life, accident, short-term and long-term disability, and business travel accident insurance. Financial and retirement benefits include the Aon Pooled Employer Plan (“Aon PEP”), Vantive’s 401(k) retirement savings plan, to help you prepare for your future.  The Aon PEP is designed to help improve retirement outcomes by providing retirement resources more efficiently.  The plan offers a robust set of investment options, financial education, and a suite of resources to support your retirement goals.

We also offer Flexible Spending Accounts, educational assistance programs, and time-off benefits such as paid holidays, paid time off ranging from 20 to 35 days based on length of service, family and medical leaves of absence, and paid parental leave. Additional benefits include commuting benefits, the Employee Discount Program, the Employee Assistance Program (EAP), and childcare benefits. Join us and enjoy the competitive compensation and benefits we offer to our employees. For additional information regarding Vantive’s US Benefits, please speak with your recruiter or visit our Benefits site: Benefits | Vantive

Equal Employment Opportunity

Vantive is an equal opportunity employer. Vantive evaluates qualified applicants without regard to race, color, religion, gender, national origin, age, sexual orientation, gender identity or expression, protected veteran status, disability/handicap status or any other legally protected characteristic.
                                                                                                                                                               
Know Your Rights: Workplace Discrimination is Illegal

Reasonable Accommodation

Vantive is committed to working with and providing reasonable accommodations to individuals with disabilities globally. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application or interview process, please click on the link here and let us know the nature of your request along with your contact information. Form Link

Recruitment Fraud Notice
Vantive has discovered incidents of employment scams, where fraudulent parties pose as Vantive employees, recruiters, or other agents, and engage with online job seekers in an attempt to steal personal and/or financial information. To learn how you can protect yourself, review our Recruitment Fraud Notice.