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 for PWM Data Warehouse systems, develop these requirements into functional specifications and 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 of PWM Data Warehouse capability. 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. Any experience in Domain models and Canonical models is preferred.
Responsibilities
1. Collaborate with Project Manager, business and technology/vendor partners to jointly identify data needs required to deliver the next generation of wealth management technology Data Warehouse solutions.
2. Reconcile source data with data at vendor to support transition to PWM Data Warehouse.
3. Develop and verify data mapping as needed to support the PWM Data Warehouse project. Provide Technical specs to Development Team such that ETLs can be built to spec.
4. Create detailed documentation (Design specification, Data mapping, Data flow and sequence diagrams) and verify data mapping as needed to support the PWM Data Warehouse project.
5. Design and support Data Quality Checks
6. Capture and understand both business and technical data definitions.
7. Ensure and follow the best practices and data quality rules defined by the Architects and senior DA's.
8. Work closely with vendors to debug data issues.
9. Communicate results and insights with project teams and stakeholders (e.g., through live presentations and ongoing analysis/reports).
Qualifications
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
Technical Skills:
* Expert in writing SQL
* Excellent attention to detail and experience debugging code
* Experience with Canonical Data Models
* Knowledge of Private Wealth Management/Investment Management - with ability to interpret definitions and calculations from business language to developer logic
Professional Skills/Competency:
* 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
* 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
* Understanding of traditional and alternative asset class investment data, including but not limited to equity, fixed income, private equity, real estate, derivatives, mutual funds, ETFs, global assets, foreign exchange, etc.
Send resume to adelina@jobs-n-jobs.com
For more jobs in United States, please visit http://jobs-n-jobs.com/search/label/USA
The Data Analyst works with subject matter experts from the project team to determine data requirements for PWM Data Warehouse systems, develop these requirements into functional specifications and 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 of PWM Data Warehouse capability. 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. Any experience in Domain models and Canonical models is preferred.
Responsibilities
1. Collaborate with Project Manager, business and technology/vendor partners to jointly identify data needs required to deliver the next generation of wealth management technology Data Warehouse solutions.
2. Reconcile source data with data at vendor to support transition to PWM Data Warehouse.
3. Develop and verify data mapping as needed to support the PWM Data Warehouse project. Provide Technical specs to Development Team such that ETLs can be built to spec.
4. Create detailed documentation (Design specification, Data mapping, Data flow and sequence diagrams) and verify data mapping as needed to support the PWM Data Warehouse project.
5. Design and support Data Quality Checks
6. Capture and understand both business and technical data definitions.
7. Ensure and follow the best practices and data quality rules defined by the Architects and senior DA's.
8. Work closely with vendors to debug data issues.
9. Communicate results and insights with project teams and stakeholders (e.g., through live presentations and ongoing analysis/reports).
Qualifications
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
Technical Skills:
* Expert in writing SQL
* Excellent attention to detail and experience debugging code
* Experience with Canonical Data Models
* Knowledge of Private Wealth Management/Investment Management - with ability to interpret definitions and calculations from business language to developer logic
Professional Skills/Competency:
* 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
* 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
* Understanding of traditional and alternative asset class investment data, including but not limited to equity, fixed income, private equity, real estate, derivatives, mutual funds, ETFs, global assets, foreign exchange, etc.
Send resume to adelina@jobs-n-jobs.com
For more jobs in United States, please visit http://jobs-n-jobs.com/search/label/USA