Data Architect & Solutions Specialist

1 Month ago • 15 Years +

Job Summary

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.
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.
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.

Job Details

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.

Similar Jobs

Saviynt - Sr. Engineer, Solutions Engineering

Saviynt

United States (Remote)
8 Months ago
Egnyte - Sr DevOps Engineer - Azure

Egnyte

India (Remote)
4 Months ago
SciPlay - Senior Software Engineer

SciPlay

Cedar Falls, Iowa, United States (Hybrid)
5 Months ago
Neolytix - Full Stack Developer

Neolytix

Gurugram, Haryana, India (Hybrid)
1 Month ago
Temporal Technologies - Senior Software Engineer - Open-Source Server

Temporal Technologies

(Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Zazz - Cloud Engineer (Azure)

Zazz

(Remote)
4 Months ago
ARHS - Cloud Delivery Manager

ARHS

Luxembourg (On-Site)
2 Months ago
Info Stretch - .Net Architect

Info Stretch

Mechanicsburg, Pennsylvania, United States (On-Site)
7 Months ago
Ziff Davis - Senior Software Engineer, Backend - Lose It!

Ziff Davis

United States (On-Site)
7 Months ago
PwC - Expert AI Developer

PwC

Kraków, Lesser Poland Voivodeship, Poland (Hybrid)
8 Months ago
London stock Exchange - Category Manager - Infrastructure & Cloud

London stock Exchange

London, England, United Kingdom (On-Site)
1 Month ago
HCL Tech - Technical Specialist .net,azure,c#

HCL Tech

Vermont, United States (On-Site)
3 Weeks ago
Inworld AI - Staff Platform Engineer - USA

Inworld AI

Mountain View, California, United States (On-Site)
6 Months ago
HCL Tech - Kubernetes Technical Lead

HCL Tech

California, United States (On-Site)
3 Weeks ago
Veeam Software - Site Reliability Engineer

Veeam Software

Warsaw, Masovian Voivodeship, Poland (Remote)
1 Month ago

Get notifed when new similar jobs are uploaded

Jobs in Mumbai, Maharashtra, India

London stock Exchange - Senior Engineer, Windows

London stock Exchange

Bengaluru, Karnataka, India (On-Site)
3 Weeks ago
conga - Sr. Dotnet Fullstack Developer

conga

Pune, Maharashtra, India (On-Site)
1 Month ago
Assystems - Lead Electrical Engineer (LV/HT/ELV)

Assystems

Gurugram, Haryana, India (On-Site)
7 Months ago
SparkCognition - Senior Software Engineer (Frontend)

SparkCognition

Bengaluru, Karnataka, India (On-Site)
8 Months ago
Info Stretch - Engineer II

Info Stretch

Bengaluru, Karnataka, India (On-Site)
8 Months ago
Qualcomm - CPU Micro-architect/RTL Designer -Sr Lead

Qualcomm

Bengaluru, Karnataka, India (On-Site)
2 Weeks ago
Nagarro - Senior Engineer, ETL

Nagarro

Pune, Maharashtra, India (On-Site)
8 Months ago
Tide - Business Development Executive - German Speaking (Mandatory)

Tide

Hyderabad, Telangana, India (On-Site)
1 Month ago
hogarth - QA Engineer

hogarth

Hyderabad, Telangana, India (Hybrid)
1 Month ago
cyara - Senior Support Engineer

cyara

Hyderabad, Telangana, India (Hybrid)
3 Months ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

We are a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. Capgemini is a global leader in partnering with companies to transform and manage their business. Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.

Bengaluru, Karnataka, India (On-Site)

Pune, Maharashtra, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Mumbai, Maharashtra, India (On-Site)

Pune, Maharashtra, India (On-Site)

Kolkata, West Bengal, India (On-Site)

Noida, Uttar Pradesh, India (On-Site)

Bengaluru, Karnataka, India (On-Site)

Noida, Uttar Pradesh, India (On-Site)

Mumbai, Maharashtra, India (On-Site)

View All Jobs

Get notified when new jobs are added by Capgemini