Snowflake Data Modeler

Job Role: Snowflake Data Modeler

Job Location: London, UK

Experience: Mid-Senior Level

Work Type: Hybrid / Open for full-time & Contract

About Company:

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,700+ and has 55 offices in 20 countries within key global markets. For more information on the company, please visit our website or LinkedIn community.

Diversity, Equity, and Inclusion

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and an affirmative-action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Position Summary:

We are seeking an experienced Snowflake Data Modeler to lead and support data modelling and data management initiatives across the organization. The successful candidate will be responsible for designing scalable, high-quality data models in Snowflake and other database environments, supporting data migration and modernization programs, and collaborating with business and technical teams to ensure data is structured, governed, and fit for purpose.

The key focus of this role will be the transformation and migration of data from on-premises platforms to Snowflake in the cloud.

Key Responsibilities

• Lead and support the design, development, and maintenance of conceptual, logical, and physical data models.
• Develop scalable and performant data models for Snowflake and other relational or analytical database platforms.
• Apply dimensional modelling techniques, including the design of:
• Star and snowflake schemas
• Fact and dimension tables
• Slowly changing dimensions
• Conformed dimensions
• Aggregated and analytical structures
• Translate business requirements into effective data structures and models.
• Support data migration initiatives where Snowflake is the target platform, including:
• On-premises-to-cloud transformation
• Source-to-target analysis
• Data mapping and modelling
• Data profiling and data quality assessment
• Data reconciliation and validation
• Migration impact analysis
• Review existing on-premises data models and recommend suitable cloud-based and Snowflake-native designs.
• Collaborate with data architects and engineers to ensure models align with enterprise architecture and implementation standards.
• Define and maintain data model documentation, source-to-target mappings, business definitions, and technical metadata.
• Support the development of data management and governance practices, including data ownership, lineage, quality, and standards.
• Work with ETL/ELT teams to ensure transformation logic is consistent with approved data models.
• Review and optimize SQL queries, model structures, and data access patterns for performance and maintainability.
• Participate in data design reviews, solution reviews, migration planning, and technical discussions.
• Identify data modelling risks, dependencies, and opportunities for standardization and reuse.
• Provide guidance and support to developers, analysts, and other project team members on data structures and modelling approaches.

Required Qualifications and Experience:

• Proven experience as a Data Modeler, Data Architect, or similar data-focused role.
• Strong hands-on experience with data modelling in Snowflake and at least one other database platform.
• Demonstrated experience with dimensional modelling and analytical data warehouse design.
• Experience designing logical and physical data models for enterprise data environments.
• Experience with data migration projects where Snowflake is the target platform.
• Practical experience supporting on-premises-to-cloud data transformation or modernization initiatives.
• Understanding of relational database concepts, data warehouse architecture, normalization, denormalization, and data integration patterns.
• Ability to interpret business requirements and convert them into clear, practical data models.
• Experience producing data model documentation and source-to-target mapping specifications.
• Strong communication and collaboration skills, with the ability to work effectively with both technical and non-technical stakeholders.

Preferred Qualifications and Experience:

• Experience with data management, data governance, metadata management, or data quality practices.
• Experience with ETL/ELT processes and transformation mapping using cloud or on-premises tools.
• Familiarity with tools such as Informatica, Talend, dbt, Matillion, Azure Data Factory, AWS Glue, SSIS, or equivalent platforms.
• Experience with Snowflake features and design considerations, including:
• Schemas, databases, and warehouses
• Clustering and micro-partitioning concepts
• Secure views and data sharing
• Data types and semi-structured data
• Streams, tasks, and dynamic tables
• Proficiency in SQL, including complex queries and data validation scripts.
• Experience with PL/SQL or another transactional query language.
• Knowledge of data lineage, business glossaries, reference data, master data, and data ownership frameworks.
• Experience with data profiling, reconciliation, quality rules, and migration testing.
• Familiarity with Agile delivery methodologies and tools such as Jira or Azure DevOps.

Key Skills:

• Snowflake data modelling
• Dimensional modelling
• Data warehouse and analytical design
• Data migration and modernization
• On-premises-to-cloud transformation
• Source-to-target mapping
• Data profiling and reconciliation
• SQL and database development
• Data management and governance
• Stakeholder engagement
• Technical documentation
• Problem-solving and analytical thinking.