Senior Business Systems Analyst

Computer Enterprises - Pittsburgh, PA

Full-time - Mid Level

Remote - Pittsburgh, PA

Professional, Scientific, and Technical Services

About the position

The Senior Business Systems Analyst will be part of a dedicated team focused on developing data products and business process solutions to support regulatory reporting and compliance within the financial services and banking sector. This role is crucial for ensuring that the bank meets compliance requirements for critical regulatory reports, adapting reporting capabilities as regulations evolve, and enhancing processes to align with new standards. The analyst will analyze complex financial regulations, translate them into actionable technical requirements, and support implementation through data analysis and process optimization.

Responsibilities

• Gather detailed business and data requirements from internal units to support accurate regulatory reporting processes, including FRY 9c, FRY 14M/Q, FR2590, and Basel III submissions.
• Collaborate with business stakeholders and clients to understand the scope of information processing needs, ensuring alignment with regulatory and operational objectives.
• Analyze and interpret Federal Reserve instructions to understand regulatory changes, determining their impact on reporting requirements and business processes.
• Translate regulatory requirements into comprehensive technical specifications for the development or enhancement of reporting solutions.
• Conduct in-depth SQL-based data analysis in Oracle and Teradata environments to validate data integrity, identify discrepancies, and ensure compliance with regulatory standards.
• Create, refine, and manage detailed financial and regulatory reports using Excel and BI tools, including Tableau, Power BI, or Oracle BI.
• Evaluate the implications of on- and off-balance sheet activities across various asset classes, such as commercial and retail loans, leases, derivatives, securitized assets, or equity, and ensure these are accurately reflected in reports.
• Facilitate discussions across multiple teams to resolve conflicting priorities, clarify requirements, and ensure timely project delivery.
• Identify and implement process improvement opportunities to optimize reporting workflows and enhance operational efficiency.
• Provide regular updates to leadership on progress, challenges, and milestones related to regulatory reporting initiatives.
• Act as a subject matter expert on regulatory requirements, offering guidance and support to internal teams to ensure compliance and mitigate risks.

Requirements

• Bachelor's degree in a technical field such as Computer Science or Finance is required.
• 5-8 years of experience as a Business/Data Analyst, with at least 3 years focused on financial analysis or modeling for Asset Liability Management, Treasury Management, Credit Risk Management, or SCCL/Basel III regulations.
• Experience interpreting Federal Reserve instructions for regulatory reports such as FRY 9c, FRY 14M/Q, FR2590, and Basel III and converting them into technical requirements.
• Advanced SQL skills for data analysis in Oracle and Teradata environments.
• Proficiency with Excel, with experience using business intelligence tools like Tableau, Microsoft Power BI, or Oracle BI.
• Deep understanding of U.S. banking capital regulations and their implications for financial institutions.
• Strong communication skills, both written & verbal, with the ability to work across teams with competing priorities.

Nice-to-haves

• Master's degree in Finance or a related field.
• Familiarity with commercial/retail loans, leases, derivatives, securitized assets, or equity.
• Experience with general ledger or credit card system implementations.

Benefits

• Medical
• Dental
• Vision
• 401k