Snowflake Solution Architect - DBT

Cognizant; Stockholms kommun; Hybrid; SEK 1,100,000 - 1,500,000; Full time

Job summary

Cognizant Stockholm is seeking a Snowflake Solution Architect - DBT to design and govern scalable test data solutions across hybrid environments. You will define reusable data patterns, optimize test data provisioning, and ensure high quality data practices for complex applications and asset management domains.

Responsibilities include building robust Snowflake and DBT architectures, developing modular models, creating macros, and leveraging DBT Cloud for deployments and observability.

Qualifications

• Hands-on Snowflake experience with data modeling and performance tuning.
• Advanced DBT core and DBT Cloud skills for modular projects and automated runs.
• Strong understanding of data warehousing concepts and test data principles.

Responsibilities

• Design robust test data architecture using Snowflake and DBT for scalable provisioning.
• Develop and maintain modular DBT models and macros for test datasets.
• Utilize DBT Cloud to manage deployments, runs, and observability of data transformations.
• Collaborate with QA, engineering, and business teams to define data needs and validation criteria.
• Establish data governance practices including masking and synthetic data for testing.

Skills

Snowflake

DBT Core & Cloud

Test Data

Data Modeling

Hybrid Collaboration

Tools

DBT Cloud

Snowflake Tasks

Job description

Snowflake Solution Architect - DBT

Snowflake Solution Architect - DBT
Location: Stockholm / Sweden

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.