Data Architect

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