Senior Data Analyst, Internal Audit, Data Analytics and Automation

Key Skills

Java Programming, Python Programming, C++, C Programming, SQL, Cloud computing, Scala Programming, Machine learning techniques, Data science techniques, MATLAB Programming, PyTorch, TensorFlow, R Programming

Job Description

Incredible teams doing exceptional work, every day.

The Audit, Risk, Compliance and Legal groups support First Republic’s business objectives by systematically improving the effectiveness of its risk management, control, and governance processes. We own and administer these processes while educating our colleagues to best support them. Our mission is to promote a culture of compliance and to be the best partner we can to our business stakeholders.

Duties and Responsibilities

As a member of our Internal Audit Team, the Internal Audit Analyst, Data Analytics and Automation will contribute to developing and maturing the data analytics capabilities of the Data Analytics and Automation program of Internal Audit. The role will focus on meeting the data analytics needs for the Internal Audit department including internal audit planning, fieldwork, and reporting, validation of the Bank’s key risk indicators, and monitoring of new and emerging risks. The role will work closely with the audit teams within the Internal Audit department, as well as the Bank’s Information Technology groups, Enterprise Data and Client Insights group, and other lines of business, as necessary, to facilitate the completion of data analytics engagements.

What you’ll do as a Senior Data Analyst, Internal Audit, Data Analytics and Automation:

• Execute on assigned data analytics engagements and components of Internal Audit’s Data Analytics and Automation program, strategy, and roadmap, with minimal supervision.
• Apply a logical and methodical approach for identifying, prioritizing, and implementing data analytics ideas that support risk assessments, internal audit engagements, and continuous monitoring activities.
• Lead the planning, organization, and completion of engagements, communicating progress and risks periodically, while observing escalation procedures throughout the engagements.
• Provide support in developing the infrastructure for data analytics, including building Extract-Load-Transform processes and data pipelines.
• Extract and analyze data from the Bank’s data warehouse and enterprise data marts using Snowflake and/or Python, and visualize analysis results in Tableau.
• Demonstrate and apply technical expertise in developing data analytics solutions and peer reviewing other colleagues’ work products.
• Prepare the necessary presentations, solution documentation, user guides, and demonstration materials for developed solutions, allowing Internal Audit users to better understand, apply, and use developed solutions; gain support for adoption of developed solutions through effective communication, presentation, and persuasion skills.
• Monitor existing data analytics solutions, and support maintenance and issue resolution.
• Ensure the overall quality, consistency, risk management, and adherence to department and professional standards for engagements.
• Be recognized as a data analytics champion, while developing and maintaining strong and collaborative working relationships with various teams within the Bank, learning and understanding the business to better provide value-added services, helping management achieve objectives, and enhancing customer satisfaction.
• Maintain professional certification(s) and continue to develop and expand knowledge of data analytics, risk management, the audit profession, Information Technology, bank regulatory issuances, our industry, and Company products and information through self-study, research, and continuing education efforts.

Qualifications

You could be a great fit if you have:

• 4+ years of demonstrated experience in developing data analytics solutions, business intelligence solutions, or related technical experience
• BA/BS in Information Systems Administration, Computer Science, Statistics, Mathematics, or related field
• Proficiency in Microsoft Excel, and DBMS such as SQL Server or Snowflake
• Demonstrated ability to write, implement, and troubleshoot SQL queries and provide specifications for extracting data from systems of record, data warehouses, and data marts
• Proficiency in programming languages such as Python or R
• Proficiency in visualization tools such as Tableau or Microsoft Power BI
• Exposure to statistics, and machine learning concepts and techniques
• Strong written and verbal communication skills, with the ability to work and communicate with IT and business counterparts
• Strong interpersonal skills to develop collaborative working relationships with the audit teams and business counterparts
• Strong analytical and problem-solving skills
• Self-starter who excels at learning new technologies, processes, and business functions

What skills would be nice to have:

• Advanced degree or professional certification, such as CIA, CISSP, CISA, CPA, or relevant technical or developer certifications
• Strong background in auditing techniques and/or computer control environments
• Big 4 public accounting or consulting experience
• Banking or finance experience
• Internal audit, risk management, or compliance experience

Job Demands:

• Must be able to review and analyze data reports and manuals; must be computer proficient.
• Must be able to communicate effectively via telephone and in person.

Own your work and your career — apply now

Are you willing to go the extra mile because you love what you do and how you can contribute as a team? Do you want the freedom to grow and the opportunity to take charge of your own career? If so, then come join us.