Senior Data Architect - Snowflake Migration & Governance

Black Rock Groups; Massachusetts; On-site; USD 115,000 - 120,000; Full time

Job summary

Tech Mahindra is seeking an experienced Data Architect to lead the design and implementation of modern data products and drive the migration from Oracle to Snowflake. The role involves re-platforming Informatica IICS workflows onto Snowflake and instituting governance, data modeling, and cloud data platform practices.

The candidate should have hands-on expertise with ERwin Data Modeler, Snowflake, and IICS, along with strong SQL skills and experience partnering with engineers and business

Qualifications

• Proven experience designing and delivering enterprise data solutions.
• Hands-on data product delivery and data platform architecture.
• Strong experience with Erwin Data Modeler for enterprise models.
• Experience in data governance (quality, lineage, metadata, cataloging, access).
• Practical Oracle experience (data modeling, PL/SQL, performance tuning).
• Snowflake knowledge (warehouses, stages, Streams, Tasks, Stored Procedures, Time Travel, RBAC).
• Experience with IICS for data integration/ETL/ELT workflows.
• Migration experience from Oracle to Snowflake.
• Strong SQL skills with complex queries and optimization.
• Understanding of data warehousing concepts and dimensional modeling.

Responsibilities

• Define end-to-end data architecture for data products from source to consumption.
• Design and maintain conceptual, logical, and physical data models with Erwin.
• Lead migration from Oracle to Snowflake including schema conversion and data validation.
• Re-engineer IICS workflows to Snowflake-native pipelines or ELT patterns.
• Create data products with ownership, documentation, SLAs, and reusability.
• Enforce data governance standards including data quality, lineage, and metadata management.
• Define data modeling standards and Medallion architecture patterns.
• Implement RBAC, data security, and compliance within Snowflake.
• Collaborate with engineers, analysts, and stakeholders to align architecture with goals.
• Provide technical leadership, code/design reviews, and mentorship.
• Optimize performance, scalability, and cost on Snowflake.
• Maintain architecture documentation, data models, and migration runbooks.

Skills

Data Architecture

Data Modeling

SQL Proficiency

Cloud Data Platforms

Communication

Education

Bachelor's degree in CS/IT

Master's degree in related field

Tools

Erwin Data Modeler

Snowflake

Informatica IICS

PL/SQL

Job description

Tech Mahindra is seeking an experienced Data Architect to lead the design and implementation of modern data products and drive the migration from Oracle to Snowflake. The role involves re-platforming Informatica IICS workflows onto Snowflake and instituting governance, data modeling, and cloud data platform practices.

The candidate should have hands-on expertise with ERwin Data Modeler, Snowflake, and IICS, along with strong SQL skills and experience partnering with engineers and business