Senior Business Execution Consultant

About this role:

Wells Fargo is seeking a Senior Business Execution Consultant (Sr. AVP).

In this role you will:

Data Governance, Security and Controls

• Understanding of data classification, lineage, metadata, retention, access control, privacy and audit requirements in a regulated environment.
• Ability to implement validation, reconciliation, exception management, logging, monitoring and evidence-based controls.
• Knowledge of development, test and production environment separation; least-privilege access; and secure data handling.

Analytical and Communication Skills

• Strong problem-solving skills with ability to break down ambiguous business questions and validate conclusions against source data.
• Ability to communicate technical designs, data limitations, assumptions, risks and insights clearly and confidently.
• Experience partnering across Operations, Front Office, Risk, Product and Technology teams and constructively challenging requirements or designs.
• Ability to manage multiple priorities while maintaining high standards of documentation, testing and production support.

Required Qualifications:

• 4+ years of Business Execution, Implementation, or Strategic Planning experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education.
• 3 years hands-on experience with Microsoft Fabric components such as One Lake, Lakehouse, Warehouse, Data Factory, notebooks and dataflows.
• 10 years strong SQL skills and working knowledge of Python for data transformation, analysis and automation.
• Experience with data modelling, ETL/ELT, dimensional modelling, semantic models, data quality and performance tuning.
• Hands-on experience with Power BI, including Power Query, DAX, visualization design, security and report optimization.
• Experience with Power Apps, Power Automate, Dataverse, SharePoint, REST APIs and enterprise data sources.
• Working knowledge of Git, Azure DevOps or equivalent CI/CD tooling, testing practices and release management.

Desired Qualifications:

• Experience delivering analytics or automation solutions in financial services or another regulated industry.
• Familiarity with Azure data services, APIs and enterprise architecture patterns.
• Relevant Microsoft certifications in Fabric Analytics Engineering, Power BI Data Analytics, Azure Data Engineering, or Power Platform are advantageous.

Job Expectations:

1. Microsoft Fabric Data Engineering

• Design and build end-to-end data solutions using Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory pipelines, notebooks and Gen2 dataflows.
• Ingest, transform and integrate structured and semi-structured data from SQL databases, files, SharePoint, APIs and approved enterprise platforms.
• Develop reusable ETL/ELT frameworks using SQL, Python and Fabric-native capabilities.
• Implement medallion-style data layers where appropriate and optimize pipelines for reliability, performance, scalability and cost.
• Apply data quality checks, reconciliation, lineage, metadata, access controls and monitoring across data pipelines.

2. Data Analysis and Business Intelligence

• Partner with stakeholders to translate business questions into analytical requirements, data models, metrics and actionable insights using AI capabilities.
• Perform data profiling, exploratory analysis, trend analysis, root-cause analysis and validation using SQL, Python, Excel and Power BI.
• Design dimensional models and governed semantic models for consistent reporting and self-service analytics.
• Build and enhance Power BI reports and dashboards using Power Query, DAX, row-level security and performance optimization practices.
• Communicate findings clearly through visual storytelling, concise commentary and decision-focused recommendations.

3. Power Platform Development and Automation

• Design and enhance Power Apps, including Canvas and Model-Driven applications, for data capture, workflow and operational use cases.
• Build Power Automate cloud flows for approvals, notifications, data movement, exception handling and process orchestration.
• Use Dataverse, SharePoint, SQL, APIs and approved connectors to integrate applications with enterprise data and services.
• Apply environment strategy, solution packaging, deployment, permissions, connector controls and application lifecycle management standards.

4. Architecture, Engineering and Integration

• Translate functional requirements into technical designs, data architectures, integration patterns and scalable solution components.
• Develop maintainable code and reusable assets using version control, peer review, testing, documentation and CI/CD practices.
• Build secure integrations with REST APIs and enterprise platforms, with appropriate authentication, error handling, logging and recovery.
• Ensure solutions meet non-functional requirements for security, resilience, performance, supportability and scalability.

5. Delivery and Lifecycle Management

• Support the complete delivery lifecycle: discovery, requirements, design, development, testing, UAT, deployment, production support and continuous improvement.
• Prepare technical documentation, source-to-target mappings, data dictionaries, test evidence, runbooks and release records.
• Identify delivery, data, security and operational risks early; track dependencies and support timely remediation.
• Monitor production solutions, investigate failures and data issues and implement sustainable corrective actions.

6. Stakeholder Collaboration and Enablement

• Work with Product Owners, business analysts, data owners, architects, engineers, QA, DevOps, Risk and control partners.
• Explain technical concepts and analytical findings to non-technical stakeholders in clear business language.
• Facilitate requirement workshops, design walkthroughs, demos and knowledge-transfer sessions. Promote governed self-service analytics, reusable patterns and responsible adoption of Microsoft Fabric and Power Platform.
  

Working hours: 1:30 PM IST thru 10:30 PM IST (including 1 hour break).

Hybrid working model subject to change as per team / organization's guidance.