Senior Snowflake Data Modeler & Lead Engineer

Mphasis; New York (NY); On-site; USD 150,000 - 190,000; Full time

Job summary

Mphasis in New York, NY is seeking a Sr. Data Architect / Snowflake Data Modeler Lead Engineer to translate Finance requirements into Snowflake data models and semantic definitions.

You will lead hands-on implementation and collaborate with Finance stakeholders. The role requires 8-12 years in data warehousing, Snowflake, advanced SQL, and leadership in regulated environments; you will mentor engineers and contribute to CI/CD and production-readiness.

Qualifications

• 8-12 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.
• Proven ability to lead architecture discussions and work with business, data, security, governance and engineering stakeholders in a regulated environment.

Responsibilities

• 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 prioritized 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.
• Optimize 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.

Skills

Advanced SQL

Data modeling

Leadership

Architecture reviews

Stakeholder collaboration

Education

Bachelor's or Master's degree

Tools

Snowflake

Job description

Mphasis in New York, NY is seeking a Sr. Data Architect / Snowflake Data Modeler Lead Engineer to translate Finance requirements into Snowflake data models and semantic definitions.

You will lead hands-on implementation and collaborate with Finance stakeholders. The role requires 8-12 years in data warehousing, Snowflake, advanced SQL, and leadership in regulated environments; you will mentor engineers and contribute to CI/CD and production-readiness.