Role Overview :

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.

Duties :

- Report into the Delivery Squad Product Lead.
- Design and implement effective datawarehouse solutions and models to store and retrieve company data.
- Examine and identify datawarehouse structural necessities by evaluating client operations, applications, and programming.
- Assess datawarehouse implementation procedures to ensure they comply with internal and external regulations.
- Oversee the migration of data from legacy systems to current solutions.
- Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
- Recommend solutions to improve new and existing datawarehouse 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.
- Prioritising 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.
- 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), BigQuery, CosmosDB, databricks, Redshift.
- Knowledge of ELT/ETL and data streaming engineering with relevant technologies (i.e. Kafka, dbt).
- Evidential experience of data analysis and data modelling.
- Extensive practical SQL experience.
- Strong knowledge of datawarehouse structures.
- Understanding of metadata standards.
- Practical experience of data modelling standards.
- Ability to work with technical stakeholders to assess potential risks.
- Ability to analyse 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.

📌 Data Architect - ETL/Data Warehousing (India)
🏢 SGC It Solutions
📍 India