Sr Business Controls Specialist- Business Controls & Central Reporting
About The Position
This job is responsible for driving and executing on internal control discipline and operational excellence within a Line of Business (LOB) or Enterprise Control Function (ECF). Key responsibilities include providing analytical and administrative support for LOB or ECF specific processes and tools to drive adherence to enterprise-wide standards. Job expectations include monitoring and testing controls and implementing quality assurance and quality control processes within the LOB or ECF by evaluating data to help identify, track, and report issues and control improvements for remediation. The role provides critical end to end production support of metric reporting routines. The reports/dashboards are shared with senior executives within and outside of the organization to drive proper risk culture and business strategy. Given the level of the audience, report dashboards and executive summaries must be pristine and error free. Data analytics responsibilities may include, and are not limited to, trending analysis, and success analytics to identify areas of discrepancy and possible at-risk controls. The work includes data mining, data aggregation, business metrics, SPI inventory output analysis, risk program metrics analysis, and performance/milestone analytics.
Requirements
- 5+ years of expert‑level Excel experience, including mastery of complex functions, advanced data modeling, pivot tables, Power Query, and automation used to support high‑visibility business analytics and control routines
- 7+ years of data mining experience, leveraging multiple and disparate data sources to identify patterns, trends, anomalies, and insights that support risk detection and issue validation
- 7+ years of experience independently prioritizing and managing high‑volume workloads, balancing multiple competing deadlines, and delivering in fast‑paced, deadline‑driven environments
- 7+ years of experience providing proactive follow‑up, issue resolution, and stakeholder support on reporting inquiries, data questions, and business partner requests
- Moderate‑to‑advanced SQL experience, with the ability to independently build, optimize, and troubleshoot queries across large and complex datasets
- Analytical experience, demonstrating the ability to dissect, interpret, and simplify complex information into clear, actionable insights for senior stakeholders
- Experience applying exceptional attention to detail to ensure accuracy, data integrity, and consistency in reporting and control documentation
Nice To Haves
- Experience working in a highly regulated industry or financial institution
- Has previously interacted with senior level managers
- Created dashboard reports or analytics
Responsibilities
- Oversees the design and effectiveness of the risk and control environment to support Client Operational Services and ensure adherence to enterprise-wide standards
- Supports the monitoring and testing of controls by evaluating data to identify issues and control improvements for remediation
- Implements optimized controls and enhanced Quality Assurance (QA) practices to support business continuity efforts
- Conducts and coordinates quality inspection reviews to enhance employee performance and control effectiveness
- Performs QA activities including executing on controls, managing cases, and reporting results
- Executes initiatives by identifying areas of potential testing automation, procedural updates, thematic trends, test script updates, and coaching opportunities to enhance QA program success
- Supports the overall management of and research required for regulatory exams, internal audits, and other monitoring and inspection reviews and evaluates data and information relevant to inspection metrics to support governance activities for dashboard reporting
- Timely delivery of reporting requirements using existing macros and code
- Proactive identification of code or macro breaks
- Successful application of macro/code fixes and creation
- Manipulate and clean data from multiple sources and systems of record
- Applied critical eye to catch errors or discrepancies
- Application of advanced Excel and SQL skills to produce reporting in an efficient, timesaving manner
Benefits
- Pay Transparency
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
