This job has expired, please see additional jobs below
Contingent Data Analyst
First Republic Bank
San Francisco, CA, United States
Job Details - this job has expired, please see similar jobs below
Overview
Data Analyst
As part of the Information Services team, the Wealth Management Technology Team drives the vision to create an industry leading, client-centric wealth technology experience. The team is looking for forward thinking, action oriented individuals to help drive the implementation of innovative, cutting-edge solutions.
Summary:
This position reports to the Director of Data Management for Wealth Management Technology and supports the development and implementation of Wealth Management’s technology roadmap. This role has a key responsibility within First Republic to ensure that our client experience within Wealth Management maintains the highest standards of the Bank.
The Data Analyst works with subject matter experts from the project team to: determine data requirements, create functional specifications, craft detailed data flow design documents, and participates in the full development process life-cycle from concept, through testing, to implementation. This includes identifying necessary data, reconciling with the new application and the legacy data sources and ensuring a successful implementation. This will include communicating business term definition, establishing data quality rules, writing and execute data quality checks, researching and analyzing data in support of business functions, process and workflow knowledge and user acceptance testing.
Responsibilities
Duties and Responsibilities:
• Collaborate with Project Manager, business partners and teammates to jointly identify data needs required to meet project objectives
• Establish best practices, process and procedures to ensure quality results benefiting all aspects of the business.
• Manage and maintain process for ad hoc data requests: Intake, Prioritization and Delivery.
• Research data issues reported to the System Support team and provide clear updates and resolution.
• Partner with leaders and peers in cross bank divisions to coordinate data governance
• Communicate standard calculation logic and business term definition
• Reconcile source data with data at vendor to support transition to PWM Data Warehouse
• Provide Technical specs to Development Team such that ETLs can be built to spec
• Work closely with vendors to debug data issues
• Communicate results and insights with project teams and stakeholders (e.g., through live presentations and ongoing analysis/reports)
Qualifications
Skills, Knowledge and Abilities:
Experience & Education:
• BA or BS in Management Information Systems, Mathematics, Computer Science, or Engineering required
• 3+ years of relevant experience in data analysis and/or data management
• 3+ years of relevant work experience with background in wealth management and/or client reporting/portal
• Experience working with Agile and/or Scrum methodologies preferred
• Experience working with Financial data systems preferred
• Experience working with software developers to implement robust interfaces between proprietary and non-proprietary systems
Technical Skills:
• Expert in writing SQL
• Excellent attention to detail and experience debugging code
• Experienced in data modeling techniques
Professional Skills/Competency:
• Strong quantitative and analytical skills - ability to quickly analyze data to identify key insights and apply them to the business
• Knowledge of Private Wealth Management/Investment Management – with ability to interpret definitions and calculations from business language to developer logic
• Knowledgeable of complex data models and software integration/delivery
• Focus on development/ improvement of data to support continuous evolution of a more competitive and profitable Bank
• Excellent communication skills, including ability to present effectively to both business and technical audiences at all levels of the organization
• Strong orientation to clients, including demonstrated ability to understand needs and apply this knowledge to drive data enhancements
Personal Skills/Competency
• Consistently demonstrates and follows high standards of integrity in business decision-making
• Looks toward the broadest possible view of an issue/ challenge; can easily pose future scenarios; can think globally about all aspects of the Bank; can discuss multiple considerations of an issue and forecast them into the future; understands how the
• Bank works, competes, serves clients, and generates shareholder value
• Demonstrates excellent communication and interpersonal skills; able to communicate clearly and concisely in a variety of settings and styles; is effective in a variety of formal presentation and meeting settings
• Gains support for change by providing context and responding with sensitivity to concerns; takes initiative to recommend/ develop innovative approaches to getting things done
• Can quickly find common ground and solve problems for the good of all; is a team player and encourages collaboration
Technical Knowledge
• Wealth Management/Investment Management data experience - Required
• SQL – Required
• Excel - Required
• Data Modeling Principles - Required
• TFS/JIRA or other issue tracking application preferred