Snowflake Solution Architect - DBT

Job Summary

Test Data Architect role for an international organization focused on designing and governing scalable test data solutions using Snowflake and DBT across hybrid work environments. The position involves defining reusable data patterns optimizing test data provisioning and ensuring high quality data practices that support efficient delivery for complex applications and asset management operations domains.

Responsibilities

• Design robust test data architecture leveraging Snowflake and DBT to enable reliable repeatable and efficient test data provisioning across multiple application platforms and environments ensuring alignment with enterprise data standards and quality objectives.
• DBT Snowflake Testing
• Develop and maintain advanced Snowflake tasks that orchestrate test data pipelines automate refresh cycles and synchronize datasets across non production environments optimizing performance and resource usage for large scale testing needs.
• Configure and refine DBT core projects to implement modular reusable models that transform raw data into structured well governed test datasets supporting complex analytical and transactional test scenarios with high consistency.
• Create and optimize DBT macros that encapsulate common transformation logic and validation rules for test data improving maintainability reducing duplication and enabling rapid adaptation of data flows to evolving testing requirements.
• Utilize DBT cloud capabilities to manage deployments run schedules and monitor test data transformations ensuring predictable pipeline behavior and clear observability for quality assurance and engineering teams.
• Collaborate with quality engineering and application development teams to analyze test data requirements define coverage criteria and design domain specific datasets that meet functional integration and performance testing objectives.
• Establish and enforce test data governance practices including data masking synthetic data generation and controlled data subsets to safeguard sensitive information while preserving data realism and usability for testing.
• Analyze and optimize Snowflake data models storage strategies and query patterns used for test data reducing execution time improving cost efficiency and ensuring scalability for growing volumes and complexity.
• Document end to end test data architecture including data lineage transformation logic and environment specific configurations enabling transparent onboarding easier troubleshooting and clear communication across stakeholders.
• Partner with operations and business analysts in asset management operations to understand key data flows position records and transaction lifecycles translating them into representative test datasets that support credible scenario based validation.
• Implement data quality checks and reconciliation routines within DBT models and Snowflake processes to detect anomalies ensure completeness and maintain high confidence in the reliability of test data used in critical validation cycles.
• Coordinate with environment management and release teams to integrate test data provisioning into continuous integration and continuous delivery processes reducing manual effort and enabling more frequent reliable releases.
• Mentor peers in effective use of Snowflake and DBT for test data sharing best practices and standards that enhance adoption of the architecture and contribute to more consistent data driven testing across the organization.

Qualifications

• Demonstrate deep hands on experience with Snowflake including tasks data modeling performance tuning and orchestrated processing specifically focused on enabling test data solutions for complex enterprise systems.
• Show advanced proficiency with DBT core and DBT cloud including design of modular projects development of reusable macros and configuration of automated runs that support high quality test data transformation workflows.
• Apply strong understanding of data warehousing and data engineering concepts such as dimensional modeling incremental loads and data quality frameworks to design resilient test data pipelines that support diverse test scenarios.
• Utilize analytical and problem solving skills to interpret testing requirements design appropriate data subsets and resolve issues in data flows ensuring that test data remains accurate timely and fit for each validation purpose.
• Bring domain exposure to asset management operations as a beneficial capability by translating business processes positions trades and reconciliations into realistic test datasets that improve relevance of system validation.
• Operate effectively in a hybrid work model by communicating clearly documenting decisions comprehensively and collaborating across time zones and locations while maintaining accountability for deliverables in a day shift.

Über Cognizant  
Cognizant (NASDAQ: CTSH) i ist ein Technologiedienstleister und Entwickler von KI-Lösungen. Wir schlagen die Brücke zwischen KI-Investitionen und echtem unternehmerischem Mehrwert, indem wir ganzheitliche Full-Stack-KI-Lösungen für unsere Kunden entwickeln. Mit unserer fundierten Branchen-, Prozess- und Engineering-Expertise integrieren wir die spezifischen Anforderungen von Unternehmen passgenau in Technologiesysteme. So entfalten wir das menschliche Potenzial, erzielen greifbare Ergebnisse und sichern globalen Unternehmen in einer sich rasant wandelnden Welt den entscheidenden Vorsprung. Erfahren Sie mehr unter cognizant.ai oder @cognizant.

Zusätzliche Informationen zur Beschäftigung
Die Vergütungsinformationen sind zum Zeitpunkt der Veröffentlichung dieser Stellenausschreibung korrekt. Cognizant behält sich das Recht vor, diese Informationen jederzeit unter Beachtung der geltenden gesetzlichen Bestimmungen zu ändern.

Bewerberinnen und Bewerber können verpflichtet sein, an Vorstellungsgesprächen persönlich oder per Videokonferenz teilzunehmen. Darüber hinaus kann es erforderlich sein, bei jedem Gespräch einen gültigen staatlichen Lichtbildausweis vorzulegen.

Cognizant ist ein Arbeitgeber mit Chancengleichheit. Ihre Bewerbung und Kandidatur werden nicht aufgrund von Rasse, Hautfarbe, Geschlecht, Religion, Glaubensbekenntnis, sexueller Orientierung, Geschlechtsidentität, nationaler Herkunft, Behinderung, genetischen Informationen, Schwangerschaft, Veteranenstatus oder sonstiger durch bundes‑, landes‑ oder kommunalrechtliche Vorschriften geschützter Merkmale berücksichtigt oder abgelehnt.