Job Title: Data Architect
Location: Nissan, USA Tennessee Franklin
Years of Experience: 7 10 Years
Job Summary
We are seeking an experienced Data Architect to lead the design and implementation of modern data products and drive our migration from Oracle to Snowflake, including the re-platforming of existing Informatica Intelligent Cloud Services (IICS) workflows onto Snowflake. The ideal candidate combines strong architectural expertise with hands-on experience in data governance, data modeling, and cloud data platforms, and can translate business needs into scalable, governed, and reusable data products.
Key Responsibilities
- Define and own the end-to-end data architecture for data products, from source ingestion through to consumption layers.
- Design and maintain conceptual, logical, and physical data models using erwin Data Modeler, ensuring consistency and alignment with enterprise standards.
- Lead the migration strategy and execution for moving data and workloads from Oracle to Snowflake, including schema conversion, data migration, validation, and performance tuning.
- Re-engineer and migrate existing IICS (Informatica Intelligent Cloud Services) workflows to Snowflake-native pipelines (e.g., Streams, Tasks, Stored Procedures, Snowpipe) or modern ELT patterns.
- Design and implement data products with clear ownership, documentation, SLAs, and reusability in mind.
- Establish and enforce data governance standards, including data quality, metadata management, lineage, cataloging, and access controls.
- Define data modeling standards and modern architecture patterns such as the Medallion architecture (Bronze/Silver/Gold).
- Implement role-based access control (RBAC), data security, and compliance measures within Snowflake.
- Partner with data engineers, analysts, and business stakeholders to align architecture with business and product goals.
- Provide technical leadership, conduct design/code reviews, and mentor engineering teams.
- Optimize for performance, scalability, and cost efficiency across the Snowflake platform.
- Create and maintain architecture documentation, data models, migration runbooks, and governance artifacts.
Required Skills & Qualifications
- Proven experience as a Data Architect designing and delivering enterprise data solutions.
- Hands-on experience implementing data products and data platform architectures.
- Strong hands-on experience with erwin Data Modeler for designing and managing enterprise data models.
- Strong experience in data governance (data quality, lineage, metadata, cataloging, access management).
- Practical experience with Oracle (data modeling, PL/SQL, performance tuning).
- Working knowledge of Snowflake (warehouses, stages, Streams, Tasks, Stored Procedures, Time Travel, RBAC).
- Experience with IICS (Informatica Intelligent Cloud Services) for data integration and ETL/ELT workflows.
- Hands-on experience with database/platform migration, ideally Oracle to Snowflake.
- Strong SQL skills, including complex queries and query optimization.
- Solid understanding of data warehousing concepts, dimensional modeling, and ELT best practices.
- Excellent communication skills and the ability to work with both technical teams and business stakeholders.
Good to Have (Preferred)
- Experience with cloud platform AWS and cloud storage (e.g., S3) for staging and integration
- Experience with schema conversion / migration accelerator tools (e.g., SnowConvert).
- Knowledge of Python or Snowpark for data transformation and automation.
- Exposure to CI/CD, Git-based workflows, and DataOps practices.
- SnowPro Advanced Architect certification.
Education
Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or a related field.
The pay range for this role is $115k - $120k per annum including any bonuses or variable pay. Tech Mahindra also offers benefits like medical, vision, dental, life, disability insurance and paid time off (including holidays, parental leave, and sick leave, as required by law). Ask our recruiters for more details on our Benefits package. The exact offer terms will depend on the skill level, educational qualifications, experience, and location of the candidate.
Tech Mahindra is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator at ADA_Accomodations@TechMahindra.com."