056454-Delivery Architect – Microsoft BI Solution Architect

Candidate with extensive experience working with the Microsoft SQL Server BI stack.  

Candidates having 8 years or more experience working with Microsoft SQL Server and / or Microsoft SQL Data Warehouse appliance with legacy on-prem BI stack (Analysis Services Multidimensional MDX and Tabular DAX, Reporting Services, Integration Services).  

Candidate should have expert level expertise with up-to-date knowledge within the Microsoft Azure BI Solution Architecture technology stack:

•    Enterprise and ML Models – Microsoft Azure Synapse Architecture and Enterprise Deployment
o    Up to date in-depth knowledge of tools, technology features, and usage scenarios
o    Synapse Workspaces and Synapse Studio
o    Dedicated and Serverless SQL Pools
o    Enterprise Data Model (data mart star schema design in dedicated SQL Pool)
o    Azure Data Factory (both pipeline and dataflow)
    Self-hosted integration runtime architecture and config
    Data Factory Managed VNet and Private Endpoint Architecture and Configuration
o    Microsoft Enterprise Data Gateway and Azure Logic Apps
o    Serverless Apache Spark Pools and ML (Python)
o    Shared Metadata
o    Maintenance schedule
o    Source control with Git integration
o    CI/CD
o    Synapse Link for CosmosDb and Dataverse
o    Security
o    Azure Purview
o    Power BI Workspace Linking
o    ADLS Gen2 Storage Accounts
o    Monitoring and Capacity Planning
o    Cost Estimation and Planning
o    Consumption patterns (business users, data analysts, bi developers, data scientists)
•    BI Semantic Models and Consumption – Microsoft Power BI Architecture and Enterprise Deployment
o    Up to date in-depth knowledge of tools, technology features, and usage scenarios
o    Power BI Service
o    Power BI Premium (both EM-Series and P-Series SKUs)
o    Power BI Dataflows and the Common Data Model (CDM)
o    Power BI Report Server
o    Power BI Embedded
o    Power BI User-based (free vs. pro) and capacity-based (premium vs. embedded) licensing
o    Power BI License acquisition and automation (Power Automate integration)
o    Power BI Dataset Storage Modes (Import, live connection, DirectQuery, Composite, Aggregations, Near real-time)
    Handling large datasets with bootstrapping / partitioning
o    Power BI Data Refresh scenarios and Enterprise Data Gateway
    Gateway clusters, management and monitoring refresh workloads
o    Power BI Dataset XMLA Endpoint (SSAS Tabular Development using Power BI Workspaces and SSDT)
o    Separating Power BI Dataset from Power BI Report Development Techniques (dataset consolidation practices)
o    Power BI Dataset Design best practices (and code-quality automation)
o    Power Query (M)
o    DAX Patterns (time patterns, bucketing patterns, etc.)
o    Python
o    Paginated Report Scenarios and required architecture / capacities
o    Workspace management and CI/CD integration (Power BI Pipelines vs Azure Devops Pipelines
o    Premium Capacity Management and Monitoring (Capacity Metrics App vs Azure Monitor)
o    Audit Logs
o    Power BI Apps distribution framework
o    Security
    Dataset
•    Shared dataset
•    Row-level and dataset roles
    Workspace
    Apps
o    Consumption patterns (business users, data analysts, bi developers, data scientists)
o    Power BI Desktop, Power BI Report Builder (use case scenarios)
o    Source control (Git / OneDrive with File Versioning)
o    Collaboration, Sharing, and Distribution
    Workspaces and scopes
    Shared datasets (Promoted datasets, Certified Datasets)
    Apps
    Role memberships (AD groups and O365 workgroup membership)
    separating workspaces for dev, test, and production
    content deployment methods (CI/CD)
o    Azure Purview Integration
o    Power BI Administration
    Tenant Level
    Capacity Level
o    Power BI Automation
    Logic Apps
    API and PowerShell
    Power Automate


Candidates should be flexible / willing to work across this delivery landscape which includes and not limited to Agile Applications Development, Support and Deployment.




Delivery Architects assess a project’s technical feasibility, as well as implementation risks.  They are responsible for designing and implementing a project’s technical architecture. They define the structure of a system, its interfaces, and the principles that guide its organization, software design and implementation. The scope of the Delivery Architect’s role is bounded by the business issue at hand. A Delivery Architect needs to have knowledge of all the different aspects of the technical Delivery as well as robust business knowledge. This includes the Software Architect.


Day to Day Responsibilities:


• You are responsible for the end-to-end architecture of a Delivery, including its assembly and integration into the IT architecture principles defined with the client.

• You define the structure of the system, its interfaces, and the principles that guide its organization, software design and implementation.

• You are responsible for the management and mitigation of technical risks, ensuring that the Delivery services can be realistically delivered by the underlying technology components.


Required Skills and Experience:

• Qualification: Minimum 7-10 years (3 years min relevant experience in the role) years experience, Bachelor’s Degree.

• Certification: Has or seeking IAF level 1.

• Should be proficient in foundation, People Leadership, client acquisition & development, service & delivery and business leadership.

• Should be experienced in technology awareness & leveraging and innovation & growth capability.



Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.





This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship. 



Click the following link for more information on your rights as an Applicant – http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law




About Capgemini






A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50 year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. It is a multicultural company of 200,000 team members in more than 40 countries. The Group reported 

2019 global revenues of EUR 17 billion.






Visit us at www.capgemini.com. People matter, results count.                                                                                            




Posted on:

October 5, 2021

Experience level:


Education level:

Bachelor's Degree (±16 years)

Contract type: