What are the responsibilities and job description for the Regulatory Data Analyst - SQL & Automation position at 1 point system?
Interview Process: 30-minute MS Teams interview 2nd round in-person panel (1–1.5 hours)
Role Overview Wells Fargo is seeking a highly technical contractor to join the Market & Counterparty Regulatory Reporting team. The role supports accurate, timely, regulator-aligned reporting (e.g., FR Y-14Q, CCAR). It combines risk subject matter expertise with technology delivery, focusing on modernizing reporting infrastructure, improving efficiency, and reducing regulatory risk.
Key Responsibilities
- Process Analysis & SME Partnership
- Partner with Market Risk and Counterparty Risk SMEs to understand end-to-end reporting workflows.
- Document current-state processes, controls, and data dependencies.
- Identify manual touchpoints, reconciliation gaps, data lineage issues, and opportunities for standardization.
- Automation & Solution Design
- Develop automation proposals aligned with enterprise technology strategy.
- Translate business processes into scalable technical designs (data pipelines, aggregation logic, reporting layers).
- Migrate legacy SQL processes to modern frameworks (e.g., Java-based ETL).
- Ensure solutions meet regulatory accuracy, auditability, and performance requirements.
- Requirements & Delivery Management
- Capture detailed requirements in Jira (epics, features, user stories, acceptance criteria).
- Partner with developers to refine backlog items and support testing/validation.
- Drive end-to-end delivery lifecycle (Design → Build → Test → Deploy).
- Data & Technology Engineering Oversight
- Work with large-scale relational datasets, risk aggregation frameworks, and regulatory reporting tables.
- Ensure data integrity, transformation logic accuracy, and performance optimization.
- Reporting & Visualization Enablement
- Use Power BI and Tableau to reduce manual reporting and enable self-service analytics.
- Improve transparency into risk metrics and reporting outputs.
- Emerging Technology & AI Adoption
- Evaluate AI/GenAI copilots for documentation, reconciliation, anomaly detection.
- Explore advanced analytics platforms (Fabric-like ecosystems, semantic layers).
- Ensure alignment with governance and risk standards.
Required Qualifications
- Technical Expertise:
- Advanced SQL (complex queries, stored procedures, performance optimization).
- Java (enterprise applications, batch processing frameworks such as Spring Boot/Spring Batch).
- Strong understanding of data architecture, ETL, and scalable processing frameworks.
- Regulatory & Domain Experience:
- Market Risk or Counterparty Risk environments.
- Regulatory reporting (FR Y-14Q, CCAR, Basel) preferred.
- Familiarity with stress testing, risk aggregation, and reporting controls.
- Delivery & Collaboration:
- Experience writing detailed requirements in Jira.
- Agile/hybrid delivery environments.
- Ability to translate SME discussions into technical solutions and partner across risk, data, and technology teams.