Senior Data Engineer (dbt focus)

Header
ZS is a place where passion changes lives. As a management consulting and technology firm focused on improving life and how we live it, we transform ideas into impact by bringing together data, science, technology and human ingenuity to deliver better outcomes for all. Here you'll work side-by-side with a powerful collective of thinkers and experts shaping life-changing solutions for patients, caregivers and consumers, worldwide. ZSers drive impact by bringing a client-first mentality to each and every engagement. We partner collaboratively with our clients to develop custom solutions and technology products that create value and deliver company results across critical areas of their business. Bring your curiosity for learning, bold ideas, courage and passion to drive life-changing impact to ZS.
Role Description
A Senior Data Engineer is a critical member of this team, specializing in designing, building, and maintaining systems and infrastructure that enable efficient processing, collection, storage, and analysis of large volumes of data. This role collaborates closely with business analysts, data scientists, and other stakeholders to ensure clean, accurate, and readily available data for informed decision-making and operational optimization. We are looking for a Data Engineer who has good experience in dbt for this specific role.
What You'll Do:

• Design and implement enterprise-grade dbt (Core/Cloud) solutions, including project structures, environment strategies, reusable macros, and deployment patterns.
• Build robust transformation layers using advanced SQL and Jinja, producing analytics-ready datasets with clear modelling conventions and maintainable code.
• Lead enterprise data modelling initiatives using Kimball dimensional modelling and Data Vault 2.0 patterns, selecting fit-for-purpose approaches and ensuring cross-team consistency.
• Develop and optimise incremental models and snapshotting strategies to support scalable historical tracking and performant downstream consumption.
• Define and enforce dbt testing frameworks (generic + custom), data validation/reconciliation patterns, and quality gates to ensure data reliability.
• Own source freshness management (expectations, monitoring, alerting) to maintain dependable pipelines and predictable SLAs.
• Drive CI/CD pipeline design for dbt, including automated build/test/deploy workflows, checks, and release governance.
• Establish and maintain engineering standards: Git branching and governance models, code review practices, and quality controls (e.g., SQL style guides, linting such as SQLFluff).
• Optimise performance across cloud data warehouses (e.g., Amazon Redshift) through query tuning, model optimisation, and materialisation strategy.
• Strengthen metadata, lineage, and documentation practices (dbt docs and catalogue standards) to improve transparency, maintainability, and stakeholder trust.
• Integrate dbt with orchestration frameworks (e.g., Airflow) and ensure pipelines are observable, resilient, and support production operations.
• Collaborate with clients and internal stakeholders to translate requirements into scalable data products; contribute to technical requirement gathering, analysis, and solution architecture design.

What You'll Bring:

• A relevant Bachelor's or higher-education degree in Computer Science, Data Science, or a related field.
• Strong hands-on experience with dbt Core and/or dbt Cloud, building production-grade transformation layers using SQL and modern engineering practices.
• Advanced SQL skills, including optimisation, complex transformations, and performance troubleshooting.
• Proven experience with analytics engineering practices: building clean, well-documented datasets aligned to business definitions and reporting use-cases.
• Strong understanding of dimensional modelling (Kimball) and practical familiarity with Data Vault 2.0 approaches for enterprise modelling.
• Experience designing scalable ELT/ETL pipelines and data warehouse architectures, with a focus on reliability, observability, and maintainability.
• Proficiency with Git version control, code reviews, and quality standards (e.g., SQL style guides, SQLFluff).
• Experience designing/using CI/CD pipelines for data transformation workflows and awareness of monitoring practices.
• Experience with orchestration tools such as Airflow and working in agile delivery environments.
• Strong communication skills and confidence engaging with client stakeholders and cross-functional teams.

Footer
How you'll grow:

• Cross-functional skills development & custom learning pathways
• Milestone training programs aligned to career progression opportunities
• Internal mobility paths that empower growth via s-curves, individual contribution and role expansions

Perks & Benefits:
At ZS, your growth matters. We offer a comprehensive total rewards package that supports your health and well-being, financial future, time away, and professional development. With robust skills-building programs, multiple career progression paths, internal mobility, and a deeply collaborative culture, you'll have the opportunity to do meaningful work, expand your capabilities, and thrive as part of a global community. For details on total rewards in Poland , visit ZS Poland office locations | Where we work | ZS .
Hybrid working model:
We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients/ZS offices for the majority of our week. The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections.
Travel:
Travel is a requirement at ZS for client facing ZSers; business needs of your project and client are the priority. While some projects may be local, all client-facing ZSers should be prepared to travel as needed. Travel provides opportunities to strengthen client relationships, gain diverse experiences, and enhance professional growth by working in different environments and cultures.
Considering applying?
At ZS, we honor the visible and invisible elements of our identities, personal experiences, and belief systems-the ones that comprise us as individuals, shape who we are, and make us unique. We believe your personal interests, identities, and desire to learn are integral to your success here. We are committed to building a team that reflects a broad variety of backgrounds, perspectives, and experiences. Learn more about our inclusion and belonging efforts and the networks ZS supports to assist our ZSers in cultivating community spaces and obtaining the resources they need to thrive.
If you're eager to grow, contribute, and bring your unique self to our work, we encourage you to apply.
ZS is an equal opportunity employer and is committed to providing equal employment and advancement opportunities without regard to any class protected by applicable law.
To complete your application:
Candidates must possess or be able to obtain work authorization for their intended country of employment. An on-line application, including a full set of transcripts (official or unofficial), is required to be considered.
NO AGENCY CALLS, PLEASE.
Find Out More At:
www.zs.com