Senior Treasury Analyst- Powerbi

Job Description - Senior Treasury Analyst - Power BI
Wells Fargo's Balance Sheet Interest Rate Risk Management (BSIRRM) Group is looking for a highly motivated individual with Power BI(or similar) experience to help the group transform the way we do reporting and analytics using QRM, CALM and other associated data systems.
The BSIRRM Group performs quantitative analysis of the balance sheet behavior and has primary responsibility to measure interest rate risk (IRR) and design corresponding risk mitigation strategies. Team members oversee the IRR simulation models, provide management with insight concerning changes that they see in the risk profile, and contribute to the generation of risk management strategies.
This is a key role in our transformation strategy to adopt Power BI in the group. We aim to:

• Enable better, data-driven decision-making by providing highly contextualized data and analytic information through cohesive workflows
• Automate the existing, fragmented "human integration layer."
• Foster Collaboration across functional teams
• Provide streamlined Governance and Control of analytical information presented in risk/regulatory deliverables

To achieve this mission, this role will be responsible for

• Responsible for administering, supporting, monitoring, and tuning the Power BI reporting environment; This involves the management and administration of all components of the Power BI domain, including Power BI on-premise data gateway servers.
• Support self-service model governance - PBI transformation SharePoint site, access groups, training plans, playbook updates etc.
• Run meetings and various collaboration forums - manage agenda, meeting proceedings and action items
• Own requirements for standards for the group - standardized hierarchies, calculations, naming conventions etc.
• Support all desktop procedures and control requirements in PBI environment
• Own and manage the report inventory, PBI report inventory and the corresponding progress metrics
• Support L3 (level 3 production support) for all PBI production issues
• Works closely with Power BI report users to tune and optimize Power BI reports and dashboards.
• Serves as Best Practices resource for Power BI initiatives in the organization.
• Provide data management documentation as needed to support projects/initiatives.
• Support oversight requests - data lineage, data research (Ex: Audit, CMOR, IT&V etc.)
• Provide monthly communications to downstream partners for all the changes.
• Monitor production metrics to escalate operational risks to Risk forum (through KPI Deck)

Required Qualifications, US:

• 4+ years of Treasury experience, or equivalent demonstrated through one or a combination of the following: work experience, training, military experience, education

*Minimum Qualifications

• Expertise with Dimensional Modeling or creating SSAS tabular models.
• Experience producing Power BI data models and recommending best practices for the creation of reports and graphics/visualizations.
• Understanding of Power BI Service and governance best practices, including CI/CD and use of deployment pipelines.
• Experience in the infrastructural and technical areas involving data sourcing, ETL (Extract, Transform and Load), data quality, MDM (master data management) and data distribution.
• Knowledge of software development process and methodologies
• Undergraduate degree in technology, MIS, business or related field or equivalent experience
• Strong and effective interpersonal communication (written and oral), organizational, and customer service skills.
• Ability to interact effectively with a variety of contacts/relationships, including executive/senior-level managers.

Preferred Skills

• Power BI certification is added advantage.
• Prior financial services industry experience
• Experience in moving an organization along the data management maturity model curve
• Knowledge of QRM, IRR models, data management policies, and risk data aggregation methodologies for reporting and decision support.
• MBA or other business related graduate degree
• Knowledge of data integrity management efforts in Corporate Finance/Treasury or other lines of businesses.
• Experience with enterprise initiatives supporting regulatory mandates

Posting End Date:
21 Jan 2024
*Job posting may come down early due to volume of applicants.
We Value Diversity
At Wells Fargo, we believe in diversity, equity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national origin, religion, age, sexual orientation, gender identity, gender expression, genetic information, individuals with disabilities, pregnancy, marital status, status as a protected veteran or any other status protected by applicable law.
Employees support our focus on building strong customer relationships balanced with a strong risk mitigating and compliance-driven culture which firmly establishes those disciplines as critical to the success of our customers and company. They are accountable for execution of all applicable risk programs (Credit, Market, Financial Crimes, Operational, Regulatory Compliance), which includes effectively following and adhering to applicable Wells Fargo policies and procedures, appropriately fulfilling risk and compliance obligations, timely and effective escalation and remediation of issues, and making sound risk decisions. There is emphasis on proactive monitoring, governance, risk identification and escalation, as well as making sound risk decisions commensurate with the business unit's risk appetite and all risk and compliance program requirements.
Candidates applying to job openings posted in US: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other legally protected characteristic.
Candidates applying to job openings posted in Canada: Applications for employment are encouraged from all qualified candidates, including women, persons with disabilities, aboriginal peoples and visible minorities. Accommodation for applicants with disabilities is available upon request in connection with the recruitment process.
Applicants with Disabilities
To request a medical accommodation during the application or interview process, visit Disability Inclusion at Wells Fargo.
Drug and Alcohol Policy
Wells Fargo maintains a drug free workplace. Please see our Drug and Alcohol Policy to learn more.