Search for Senior Data Analyst roles in San Francisco, in the financial services industry, requiring 5+ years of experience, with a strong background in PL/SQL, and offering benefits like 401(k).

Okay, I've searched for Senior Data Analyst roles in San Francisco within the financial services industry, requiring 5+ years of experience, with a strong background in PL/SQL, and offering 401(k) benefits. I found 132 positions that match your criteria. Would you like to review these opportunities?

Senior Data Analyst

San Francisco, CA

Financial Services

5 years + Experience

PL/SQL

401(k)

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Senior Business & Data Analyst role is fundamentally about providing strategic insights and operational efficiency to the Finance group through data analysis. This analyst will not only execute complex data analyses and develop database models, but will also play a pivotal role as a subject matter expert, ensuring that the data architecture aligns with business needs. Responsibilities will involve collaborating with business users, translating their requirements into actionable database specifications, and identifying data quality issues, which underscores the importance of interpersonal skills and a deep understanding of data governance. Success in this role means being able to sift through large datasets to derive actionable insights that aid in decision-making, as well as effectively guiding team members based on proven data methodologies, thus ensuring high-quality outputs. Given the emphasis on maintaining relationships and providing insights, candidates will need to balance technical acumen with strong communication skills to succeed in this collaborative environment.

Company Analysis:

City National Bank embodies a legacy of integrity and service, functioning as a substantial player within the financial services industry, particularly as a subsidiary of the Royal Bank of Canada. This positioning suggests that the role of Senior Business & Data Analyst is integral in supporting core banking functions and enhancing client relationships through data-driven strategies. The culture appears to be one that values professional growth and collaboration, reinforced by their commitment to diversity and community engagement. The role will likely require navigating a fast-paced environment, contributing significantly to team objectives while also aligning with the company’s strategic goals of stability and service excellence. The emphasis on compliance and regulatory frameworks in the job description indicates a structured environment where detail-oriented analysis plays a key role in safeguarding the bank's operations, hinting at the critical nature of this position in preserving the bank's reputation and reliability in the industry.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Tell me about a time when you had to analyze a large dataset to derive insights. What challenges did you face?
Describe a situation where you communicated complex technical concepts to non-technical stakeholders. How did you ensure understanding?
Can you provide an example of a time when you identified a data quality issue? What steps did you take to address it?
How would you approach defining business requirements for a new database initiative?
What methods do you use for troubleshooting issues in PL/SQL queries?
Tell me about your experience with database modeling. Can you walk us through a specific project?
Imagine you discover a significant anomaly in the data that could impact business decisions. How would you handle this situation?
How would you prioritize your tasks when working on multiple data analysis projects at the same time?
Why are you interested in working at City National Bank specifically?
How do you think your values align with the mission of City National Bank?
What attracts you to the role of Senior Business & Data Analyst at this stage of your career?
What do you believe is the most important aspect of maintaining positive relationships with business partners?
What training or certifications have you pursued to stay current in data analysis and database management?

Job Details

Overview Company

Senior Business & Data Analyst Lead

$101.2k/y-$172.4k/y

Lensa

4 days ago

Highlight

OnsiteFull-time10+ yearsSenior

Summary

City National Bank is seeking a Senior Business & Data Analyst to join their team in San Francisco, CA. The role involves supporting the Finance group and business users through data analysis and database model design for large projects.

About the Role

As a Business Unit Lead Data Analyst, you will work with business users to define and document business requirements, perform data analysis using complex PL/SQL queries, and develop database models. You will serve as a Subject Matter Expert, identify data quality issues, and support data governance initiatives. The role also involves maintaining data models and fostering good relationships with colleagues and business partners.

About You

Required:

Minimum 5 years of experience working with Information Technologies in a Lead role.
Minimum 10 years of experience as a Data Analyst, preferably in a data-intensive financial company.
Minimum 5 years working as Lead in a client-facing business support role.
Minimum 8 years of experience working with PL/SQL queries and analysis.

Preferred:

Bachelor's degree in Computer Science or related technologies.
Prior hands-on experience in using BRIO or Business Objects report queries.
Prior experience in Financial Services industry.
Excellent analytical skills.
Good knowledge of project management techniques.
Strong interpersonal, written and verbal communication skills.

Benefits

Comprehensive healthcare coverage, including Medical, Dental and Vision plans.
Generous 401(k) company matching contribution.
Career Development through Tuition Reimbursement and other internal upskilling and training resources.
Valued Time Away benefits including vacation, sick and volunteer time.
Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs.
Career Mobility support from a dedicated recruitment team.
Colleague Resource Groups to support networking and community engagement.

Lensa

What if we could take the search out of job search? This is the question Lensa has been answering since launching in San Francisco, California in August 2016. Using machine learning, we instantly provide companies with candidates and match professionals with positions that fit their skills, goals, personalities, and needs. How does it work? Lensa applies complex algorithms that identify the skills needed to succeed on a given job. Candidates can play computer games that assess their work style, thus gaining insight into their strengths while unlocking career opportunities. The result: job search that puts people first while reducing the time and cost of talent acquisition.

Lensa passed 10 million job seeker registrations in 2019, making the com- pany one of the premier career platforms.

With teams in multiple U.S. locations and a 60-strong crew of developers and data scientists at its R & D headquarters in Europe, Lensa is working every day to share its transformative career technology with the world.

San Francisco, CA