MS Fabric Consultant

About the Role

Wells Fargo is seeking a highly technical contractor to join the Market & Counterparty Regulatory Reporting team, supporting the delivery of accurate, timely, and regulator-aligned reporting (e.g., FR Y 14Q, CCAR). This role sits at the intersection of risk subject matter expertise and technology delivery, with a primary mandate to:

• Learn and deconstruct current reporting and stress processes
• Identify inefficiencies and manual dependencies
• Design and propose scalable automation solutions
• Partner with technology teams to deliver these solutions into production

The position directly supports ongoing efforts to modernize reporting infrastructure, improve operational efficiency, and reduce regulatory risk. The team has completed foundational infrastructure work and is now shifting focus to visualization tools, process improvement, and AI-driven automation in the market and counterparty risk area.

Responsibilities

Process Analysis & SME Partnership

• Partner with Market Risk and Counterparty Risk subject matter experts (SMEs) to:
• Understand end-to-end regulatory reporting workflows (data sourcing → transformation → aggregation → submission)
• Document current-state processes, controls, and data dependencies
• Identify manual touchpoints, reconciliation gaps, data lineage issues, and opportunities for standardization

Automation & Solution Design

• Develop future-state automation proposals aligned with enterprise technology strategy
• Translate business processes into scalable technical designs, including data pipelines, aggregation logic, and reporting layers
• Evaluate modernization opportunities such as migration of legacy SQL-based processes to modern application frameworks (e.g., Java-based ETL) and consolidation of fragmented reporting workflows
• Ensure solutions meet regulatory accuracy, auditability, performance, scalability, and control requirements

Requirements & Delivery Management

• Capture detailed business and technical requirements in Jira, including epics, features, user stories, and acceptance criteria aligned with regulatory and data validation standards
• Partner with technology developers to refine backlog items, ensure correct interpretation of requirements, and support testing and validation
• Drive end-to-end delivery lifecycle: Design → Build → Test → Production deployment

Data & Technology Engineering Oversight

• Analyze and work within complex reporting data environments involving large-scale relational datasets, risk aggregation frameworks, and regulatory reporting tables
• Ensure robustness across data integrity, reconciliation, transformation logic, and performance optimization

Reporting & Visualization Enablement

• Incorporate modern visualization and analytics tools (Power BI, Tableau) to reduce manual report generation and enable self-service analytics
• Improve transparency into risk metrics and reporting outputs

Emerging Technology & AI Adoption

• Evaluate and recommend use of emerging technologies, including AI/GenAI copilots for documentation, reconciliation, or anomaly detection, and advanced analytics platforms (e.g., Fabric-like ecosystems, semantic layers)
• Ensure new technologies align with enterprise governance and risk standards and provide measurable efficiency or control improvements

Requirements

Technical Expertise

• Advanced proficiency in SQL (complex queries, stored procedures, performance optimization)
• Expertise in Microsoft Fabric
• Experience with Java (enterprise applications, batch processing frameworks such as Spring Boot / Spring Batch preferred)
• Strong understanding of data architecture, infrastructure design, ETL, data pipeline development, and distributed/scalable processing frameworks

Regulatory & Domain Experience

• Experience working in Market Risk or Counterparty Risk environments (preferred)
• Regulatory reporting experience (e.g., FR Y 14Q, CCAR, Basel) is a plus
• Familiarity with stress testing processes, risk aggregation, and reporting controls
• Investment banking/capital markets product experience (e.g., derivatives, interest rate products) is a plus

Delivery & Collaboration

• Proven experience writing detailed requirements in Jira (user stories, acceptance criteria)
• Experience operating within Agile/hybrid delivery environments
• Strong ability to translate SME discussions into concrete technical solutions
• Ability to partner across risk, data, and technology teams

Process Improvement & AI

• Experience with process improvement and change management
• Exposure to AI tools for Jira work and data analysis (not required to be an expert)
• Ability to design and create agents to automate processes

Skills

• MS Fabric
• SQL
• Artificial intelligence software
• Data analysis and infrastructure design
• Power BI / Tableau
• Jira
• Process automation
• Capital markets / investment banking product knowledge
• Regulatory reporting (FR Y 14Q, CCAR)
• Java (Spring Boot / Spring Batch)

Pay

The pay range for this position is $53.00 - $55.00/hour. Individual compensation offered within this range will depend on qualifications, skills, relevant experience, job knowledge, geographic location, and internal equity.

Benefits

Eligibility requirements apply to some benefits and may depend on job classification and length of employment. Benefits are subject to change and may include:

• Medical, dental, and vision insurance
• Critical illness, accident, and hospital insurance
• 401(k) Retirement Plan (pre-tax and Roth post-tax contributions available)
• Life insurance (voluntary life & AD&D for employee and dependents)
• Short- and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time off/leave (PTO, vacation, or sick leave)

Schedule

This is a hybrid position based in Charlotte, NC. The role is a contract position with an anticipated close date of August 18, 2026.