MS Fabric Consultant

Description
Main skill sets are:
MS Fabric
Power BI
interaction with new AI tools
Challenge is that now infrastructure is built- how do we deploy person to build better technology to visualize stuff moving forward-new AI to interact with data
JOB DETAILS FROM MANAGER:
Team has been Building structure for last little while-was hiring people that were sql heavy and reverse engineers and can build out infrastructure-heavy lifting is done now
Don't need someone to come in and do that type of work but similar exp is still needed
Investment baking/ cap markets Product exp is great to have - banking type products- derivatives, interest rate products (stuff that creates market and counterparty risk)
MS Fabric is must have experience -now they built out infrastructure- need people to help with more visualization tools- tableau and power Bi, people that understand building UI's and other visualization tools
Team will refocus efforts from building infrastructure but going around market / counterparty risk area-look at process improvement across whole stack-look at processes through steps and figure out more efficient way to execute that process-where AI comes into play
Manager knows AI is new so he understand that someone will not be an expert-but if people have been exposing other process improvement processes then they can take on new change management approach (AI)
Can they take process and create agent that will execute
Skills:
Expert in SQL
Expert in all MS products
Expert Data analysis and infrastructure design
MS Fabric
Experience using AI tools for Jira work
Experience using AI tools for Data analysis
JOB DETAILS FROM SYSTEM THAT ARE MORE DETAILED:
Expert everything SQL
MICROSFT FABRIC -
automate regulatory reporting processes
data architecture
process automation

Functionaly- develop detailed requirements and write them all in Jira - personal understands the process so well that they can write the automation themselves and then the developer picks up and executes
Background- really good data analysts or BAs that taught themselves how to code or people that grew up developers and is able to connect with the business, understand the business and able to work with the business
Role Overview
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.
Key Responsibilities
1. 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
• Opportunities for standardization

2. 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
• Reporting layers

Evaluate modernization opportunities such as:

• Migration of legacy SQL-based processes to modern application frameworks (e.g., Java-based ETL)
• Consolidation of fragmented reporting workflows into structured infrastructure

Ensure solutions:

• Meet regulatory accuracy and auditability requirements
• Improve performance, scalability, and control environments

3. Requirements & Delivery Management
o Capture detailed business and technical requirements in Jira, including:

• Epics, features, and user stories
• Acceptance criteria aligned with regulatory and data validation standards

o Partner with technology developers to:

• Refine backlog items
• Ensure correct interpretation of requirements
• Support testing and validation

Drive end-to-end delivery lifecycle: Design Build Test Production deployment
4. Data & Technology Engineering Oversight
Analyze and work within complex reporting data environments involving:

• Large-scale relational datasets
• Risk aggregation frameworks
• Regulatory reporting tables

Ensure robustness across:

• Data integrity and reconciliation
• Transformation logic
• Performance optimization

5. Reporting & Visualization Enablement
Incorporate modern visualization and analytics tools where appropriate:

• Power BI and Tableau for reporting and insights delivery

Leverage these tools to:

• Reduce manual report generation
• Enable self-service analytics for stakeholders
• Improve transparency into risk metrics and reporting outputs

6. Emerging Technology & AI Adoption
Evaluate and recommend use of emerging technologies, including:

• AI/GenAI copilots for documentation, reconciliation, or anomaly detection
• Advanced analytics platforms (e.g., Fabric-like ecosystems, semantic layers)

Ensure new technologies:

• Align with enterprise governance and risk standards
• Provide measurable efficiency or control improvements

Required Qualifications
Technical Expertise
Advanced proficiency in:

• SQL (complex queries, stored procedures, performance optimization)
• Java (enterprise applications, batch processing frameworks such as Spring Boot / Spring Batch preferred)

Strong understanding of:

• Data architecture and infrastructure design
• ETL and data pipeline development
• Distributed / scalable processing frameworks

Regulatory & Domain Experience (Direct Banking Experience is a "Nice to Have" - not completely essential, but if not, the technical expertise needs to be "off the charts")
Experience working in:

• Market Risk or Counterparty Risk environments
• Regulatory reporting (e.g., FR Y 14Q, CCAR, Basel) preferred

Familiarity with:

• Stress testing processes
• Risk aggregation and reporting controls

Delivery & Collaboration
Proven experience:

• Writing detailed requirements in Jira (user stories, acceptance criteria)
• Operating within Agile / hybrid delivery environments

Strong ability to:

• Translate SME discussions into concrete technical solutions
• Partner across risk, data, and technology teams

Skills
MS Fabric, Banking, SQL, artificial intelligence software, Data, Design, Development, capital Markets, investment banking product knowledge, risk, jira
Top Skills Details
MS Fabric,Banking,SQL,artificial intelligence software,Data
Additional Skills & Qualifications
Jira
. 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
• Opportunities for standardization

Experience Level
Expert Level
Job Type & Location
This is a Contract position based out of Charlotte, NC.
Pay and Benefits
The pay range for this position is $53.00 - $55.00/hr.
Individual compensation offered for this position within this range will depend on many factors, including qualifications, skills, relevant experience, job knowledge, geographic location, internal equity, and other pertinent job-related factors.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the 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)
Workplace Type
This is a hybrid position in Charlotte,NC.
Application Deadline
This position is anticipated to close on Aug 18, 2026.

About TEKsystems

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.