Job Description
This role requires a deep understanding of data warehousing, business intelligence (BI), and data governance principles, with a strong focus on the Microsoft technology stack. The Data Architect & Solutions Specialist will be responsible for developing and maintaining the overall data architecture, including data models and data flows. They will design and implement data warehouses, data marts, and data lakes on the Microsoft Azure platform. This role also involves designing and developing complex BI reports, dashboards, and scorecards using Microsoft Power BI, and working with data engineers to implement ETL/ELT pipelines using Azure Data Factory. Additionally, this role entails establishing and enforcing data governance policies and standards.
Good To Have:
- Excellent communication and interpersonal skills.
- Strong analytical and problem-solving abilities.
- Ability to work independently and as part of a team.
- Strong attention to detail and organizational skills.
Must Have:
- Develop and maintain data architecture, models, and flows.
- Design and implement data warehouses and data lakes on Azure.
- Design and develop BI reports using Power BI.
- Implement ETL/ELT pipelines with Azure Data Factory.
- Establish and enforce data governance policies and standards.
- Strong proficiency in data warehousing concepts and methodologies.
- Expertise in Microsoft Power BI.
- Experience with Azure Data Factory, Azure Synapse Analytics, and Azure Databricks.
- Knowledge of SQL and scripting languages (Python, PowerShell).
- Strong understanding of data modeling and ETL/ELT processes.
Job Description
This role requires deep understanding of data warehousing, business intelligence (BI), and data governance principles, with strong focus on the Microsoft technology stack.
- Data Architecture:
- Develop and maintain the overall data architecture, including data models, data flows, data quality standards.
- Design and implement data warehouses, data marts, data lakes on Microsoft Azure platform
- Business Intelligence:
- Design and develop complex BI reports, dashboards, and scorecards using Microsoft Power BI.
- Data Engineering:
- Work with data engineers to implement ETL/ELT pipelines using Azure Data Factory.
- Data Governance:
- Establish and enforce data governance policies and standards.
Primary Skills
- Experience:
- 15+ years of relevant experience in data warehousing, BI, and data governance.
- Proven track record of delivering successful data solutions on the Microsoft stack.
- Experience working with diverse teams and stakeholders.
Required Skills and Experience:
- Technical Skills:
- Strong proficiency in data warehousing concepts and methodologies.
- Expertise in Microsoft Power BI.
- Experience with Azure Data Factory, Azure Synapse Analytics, and Azure Databricks.
- Knowledge of SQL and scripting languages (Python, PowerShell).
- Strong understanding of data modeling and ETL/ELT processes.
Secondary Skills
- Soft Skills
- Excellent communication and interpersonal skills.
- Strong analytical and problem-solving abilities.
- Ability to work independently and as part of a team.
- Strong attention to detail and organizational skills.
Set alerts for new jobs by Capgemini
Set alerts for new jobs in India
