Snowflake Data Modeler

• Role : Snowflake Data Modeler / Lead Engineer
• Location : New York City, NY – Onsite from day 1
• Duration : Contract

End client interview will be an In person interview in NYC, NY Client location.

About:

The Snowflake Data Modeler / Lead Engineer will work closely with Finance and data stakeholders to translate business requirements into detailed Snowflake data and semantic models. The role will lead hands-on implementation of Finance measures and modelling patterns supporting Revenue, Spend and General Ledger use cases, including Snowflake equivalents for the identified GL measures.

• Translate Finance requirements, business questions and reporting needs into logical, dimensional and physical Snowflake data models.
• Design fact, dimension, aggregate and consumption structures supporting Revenue, Spend and General Ledger use cases.
• Implement Snowflake equivalents for prioritised GL measures using reusable SQL and dynamic calculation patterns.
• Build and apply MTD, QTD, YTD and related period-based calculation utilities, using dynamic tables where appropriate.
• Develop source-to-target mappings, transformation rules, joins, hierarchies, conformed dimensions and data contracts.
• Collaborate with the Finance Semantic & Snowflake Data Architect to implement approved semantic definitions, ontology mappings and metadata requirements.
• Optimise Snowflake models and queries for performance, scalability, maintainability and cost-aware operation.
• Embed data-quality checks, reconciliation controls and traceability from source data to published Finance measures.
• Support unit, integration, regression, performance and user-acceptance testing with clear evidence and defect resolution.
• Provide technical leadership, conduct design and code reviews, and mentor Snowflake data engineers and SQL developers.
• Contribute to CI/CD pipelines, release controls, documentation, runbooks and production-readiness activities.

Responsibilities:

• Proven years of overall experience in data warehousing, data modelling, data engineering or business-intelligence platforms.
• Strong hands-on experience with Snowflake, advanced SQL and enterprise-scale analytical data models.
• Practical experience modelling Finance or regulated-industry data, preferably including GL, P&L, Revenue or Spend reporting.
• Experience designing dimensional models, transformation logic, reusable measures and data-quality controls.
• Experience leading engineering delivery, reviewing technical work and collaborating directly with business and data stakeholders.

• Capability Area
• Expected Proficiency

• Snowflake engineering
• Advanced SQL, dynamic tables, views, performance tuning and workload optimisation
• Data modelling
• Dimensional, logical and physical modelling; facts, dimensions, aggregates and hierarchies
• Finance data
• GL, Revenue, Spend, P&L concepts, measures, reconciliation and drill-down
• Data pipelines
• ETL/ELT patterns, source-to-target mapping, transformation and orchestration
• Quality & controls
• Profiling, unit testing, reconciliation, lineage, auditability and defect management
• Delivery leadership
• Technical design, code reviews, mentoring, Agile execution and stakeholder communication

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf