Senior Data Analyst

At First Republic, we care about our people. Founded in 1985, we offer extraordinary client service in private banking, private business banking and private wealth management. We believe that personal connections are everything and our success is driven by the relationships we form with our colleagues and clients. You’ll always feel empowered and valued here.

Incredible teams doing exceptional work, every day

In Technology, we support First Republic’s employees and clients through the acquisition, integration and management of the Bank’s information technology systems and services. We drive innovation and explore emerging technologies so our people can be productive and focus on what matters most – providing extraordinary service.

The Data Analyst is responsible for providing data reporting and analytics support to the Business Banking department.  The ideal candidate must possess a strong understanding of data structures, analytics and governance.  This individual will be motivated by the desire to run reports and analytics to support growth and change.  In addition, the ideal candidate will be adept at working with partners across departments to accomplish shared objectives.   

What you’ll do as a Senior Data Analyst:

• Run ad-hoc analysis for Product and Business Managers using standard query languages and operationalize for repeatable use via Tableau reporting suite.
• Code and modify SQL/ETL based on dashboard requirements.
• Maintain validation of business rules, documentation and distributions to proper stakeholders.
• Train and educate co-workers on data analysis and best practices.
• Participate in design and delivery of curriculum related to rollout of new reports and dashboards to drive adoption and to enhance business decision-making capability.
• Work closely with Product and Business teams to understand business requirements and perform data analysis

You could be a great fit if you have:

• BA or BS in Management Information Systems, Mathematics, Computer Science, or Engineering required.
• 8+ years of experience writing advanced SQL, performance tuning of BI queries, data modeling, and data mining from multiple sources (SQL, ETL, data warehousing).
• Knowledge of Private Wealth Management/Investment Management – with ability to interpret definitions and calculations from business language to developer logic.
• Experience with portfolio management and related reporting.
• Have experience using business intelligence reporting tools like Tableau, PowerBI
• Expertise with Data Analytics best practices.
• Possess a strong foundation in data analytics, an understanding and foundation in data science.
• Have exposure to statistical modeling experience (R, SAS, SPSS). (Preferred).
• Strong visualization design and development experience with Tableau (and other Business Intelligence tools).
• Expert in writing SQL.
• Excellent attention to detail and experience debugging code.
• Proven track record of delivery for business critical BI/Analytics projects.
• Ability to operate with cross-functional teams.
• Strong quantitative and analytical skills - ability to quickly analyze data to identify key insights and apply them to the business.
• Clear, high-level understanding of complex data models and software integration/delivery.
• Excellent communication skills, including ability to present effectively to both business and technical audiences at all levels of the organization.
• Proven leadership capabilities

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.

We want hard working team players. You’ll have the independence to learn, lead and drive change. A culture of extraordinary service, empowerment and stability — that’s the First Republic way.

We believe that a diverse range of backgrounds and ideas has and will continue to be fundamental to the future success of First Republic.

If you are curious to learn more about this opportunity, we'd love to hear from you.

This job description is not intended to be all-inclusive. Employee may perform other related duties as assigned to meet the ongoing needs of the organization. The Company is an equal opportunity employer. In this regard, the Company makes reasonable accommodations for qualified applicants and employees with disabilities in order to enable them to perform all essential job functions, unless doing so creates an undue hardship.

First Republic is subject to federal laws that restrict the employment of individuals with certain types of criminal histories, including FDIA Section 19 and FINRA. To the extent not inconsistent with our obligations under those federal laws and regulations, First Republic will consider qualified candidates with criminal histories in a manner consistent with the Los Angeles and San Francisco ban-the-box laws.

For New York City-based roles: Mayor Bill de Blasio announced that, effective December 27, 2021, all private sector employers?in New York City will be required to ensure that their employees are vaccinated against COVID-19 to attend work in the office. Reasonable Medical or Religious Accommodations may be requested if applicable to you. Please view New York’s Guidance on Accommodations for Workers for more information.