Data Architect

Tata Consultancy Services; Ernakulam; On-site; INR 1,800,000 - 2,800,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Data Architect to design and migrate data warehouse structures, lead a data analysts team, and define future data architectures. You will collaborate with stakeholders to document as-is pipelines, ensure data governance, and drive migration strategies across cloud platforms.

The role requires deep SQL skills, experience with Snowflake, and strong communication to coordinate cross-functional teams in a product-led, Agile environment.

Qualifications

• 5+ years of data architecture experience or related field.
• Experience with AWS (primary) or other cloud data engineering (Azure, GCP).
• Exposure to data governance, data lineage and quality.

Responsibilities

• Design and implement data warehouse solutions and models.
• Lead data analysts and define ‘To-Be’ data architecture.
• Document data lineage from source to target and ensure compliance.
• Monitor performance, test systems, and integrate new features.
• Provide guidance to junior analysts and stakeholders.

Skills

Team player

Analytical skills

Problem solving

Multi-tasking

Communication

Documentation

Analytical thinking

Fast learner

Tools

Snowflake

SQL

Confluence

Jira

BigQuery

Redshift

Data Vault

Job description

Role Description Data Architect

The Discovery Data Architect on the Sainsburys Transformation Factory (TF) Programme is a key role that sits within Core Management Team along with other TCS Data Architects, Product Leads, Analyst Leads, Engineering Leads and Solution Architects. You will work alongside data analysts and report directly to the Delivery Squad Product Lead. To succeed in this role, you should know how to understand and document ‘As-Is’ data warehouse and examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.

Duties:

• Design and implement effective data warehouse solutions and models to store and retrieve company data.
• Examine and identify data warehouse structural necessities by evaluating client operations, applications, and programming.
• Assess data warehouse implementation procedures to ensure they comply with internal and external regulations.
• Oversee the migration of data from legacy systems to new solutions.
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
• Recommend solutions to improve new and existing data warehouse systems.
• Lead the data analysts in understanding ‘As-is’ data pipelines and databases, data warehouses at the entity and attribute levels.
• Analyse and document the data lineage of data from source to target of ‘As-Is’ data environments.
• Work with key data architects and lead a data analysts’ team in defining the ‘To-Be’ data architecture.
• Implement best practices in processing confidential and personal data and information according to guidelines.
• Leading a Data Analysts team in evaluating data pipelines, anticipating requirements, uncovering areas for improvement
• Conducting meetings and presentations to share ideas and findings.
• Leading on identifying data requirements analysis
• Documenting and communicating the results of your efforts.
• Effectively communicating your insights and plans to cross-functional team members and management.
• Gathering critical information from meetings with various stakeholders and producing useful reports
• Working closely with clients, client data architects, and management
• Providing leadership, training, coaching, and guidance to junior data analysts and architects
• Inputting into projects plans, risks and dependencies logs.
• Prioritizing initiatives based on data requirements needs and requirements.
• Managing competing resources and priorities
• Monitoring deliverables and ensuring timely completion of your work
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.

Experience:

• A minimum of 5 years of experience in data architecture or a related field.
• Work experience as a data architect or in a related field.
• Practical AWS (primarily) or other public cloud data engineering experience (Azure, GCP).
• Exposure to Data Vault principles.
• Application of data governance (data lineage, data quality, cataloguing, etc).
• Practical Knowledge of Snowflake(primarily), Big Query, Cosmos DB, data bricks, Redshift.
• Knowledge of ELT/ETL and data streaming engineering with relevant technologies
• Evidential experience of data analysis and data modelling.
• Extensive practical SQL experience.
• Strong knowledge of data warehouse structures.
• Understanding of metadata standards.
• Practical experience of data modelling standards.
• Ability to work with technical stakeholders to assess potential risks.
• Ability to analyze existing tools and data platforms and provide recommendations.
• Demonstrated experience in working with large data sets and relational databases.
• The ability to influence stakeholders and work closely with them to determine acceptable solutions.
• Competency in Microsoft applications including Word, Excel, and Outlook.
• Experience in Confluence and Jira.
• Retail or Consumer Packaged Goods (CPG) experience.
• Has experience of working in Product led and Agile workstreams.
• Good written and verbal communication skills.

Skills:

• A team player but can work independently.
• Excellent organizational and analytical abilities.
• Outstanding problem solver.
• Excellent multi-tasking, planning, organizational, and time management skills.
• Excellent communications skills, listening, written and oral.
• Advanced technical skills.
• Excellent documentation skills.
• Good-level written and verbal communication skills.
• Analytical and conceptual thinking skills.
• Fundamental analytical and conceptual thinking skills.
• Quick learner