MUFG Union Bank RL Data Solutions Manager, Vice President - San Deigeo, CA in San Diego, California
Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 5th largest financial group in the world (as ranked by S&P Global, April 2018) with total assets of over $2.9 trillion (106.2 (JPY) as of March 30, 2018) and 150,000 colleagues in more than 50 countries. In the U.S., we’re 13,000 strong, working together to positively impact every customer, organization, and community we serve. At Union Bank, we aim to be the premier and most-trusted West Coast bank, serving customers with high-touch, local delivery and global capabilities as we leverage our rich, 150-year history. This is all part of our inclusive, high-performing culture supported by competitive Total Rewards, including our cash balance pension plan. Join a team that’s working to fulfill its vision to be the world’s most trusted financial group.
The main objective is to participate with and lead a team of database developers in building the underlying data platform supporting the reporting and information needs of the business unit via automated data processing design and implementation, specifically focusing on ETL design, data integration and BI modelling. Responsible for the analysis of moderate to complex business reporting and data requirements to be solved with automated data processing and reporting in support business operations and decision-making. Apply and acquire specific knowledge of the business combined with expert level knowledge of database technology to business problem solving. Utilize tools in the Microsoft data and reporting technology stack to implement data integration processes to enable both self-service and pre-built BI and operational reports (SQL Server, SSMS, SSIS, SSRS, SSAS). Strong SQL, data analysis, and database architecture design skills are used daily. Participate in a team engaged in the design, implementation and maintenance of data processing and data reporting. Participate in meetings with users to define and evaluate data and reporting needs. Analyze detailed business requirements, including input and output requirements, reports, etc. Provide recommendation. Serve as technical lead and provide mentorship and direction to other technology staff members.
Consult with business users and vendors for needs assessment.
Develop a good understanding of the business unit's function and effectively communicate technical solutions in non-technical terms.
Manage and participate in the development of data interfaces between internal systems as well as external vendors to retrieve or transmit data for reporting purposes using ETL expertise and tools.
Manage and participate in the implementation of data processes and data design in alignment with industry standard methodologies.
Acquire domain expertise in database-level data details that support the information requirements of the business
Assist business consumers in understanding the semantics of the supporting data.
Manage and Supervise Data Integration Development Staff:
- Assign task requests from the business unit to team members
Monitor work progress and quality
Consult with team members on technical considerations and assist in defining the technical solution
Handle and mitigate issues from users regarding team member’s work. Manage user expectations.
Mentor team members on best practices
Provide knowledge transfer on domain expertise related to technology and business processes within the department
Analyze business partner’s operations to understand their strengths and weaknesses to figure out opportunities to automate processes and functions. Assist in the business process redesign and documentation as needed for new technology. Translate high level business requirements into functional specifications.
Independently conducts studies of new or existing systems and recommends changes based on the results. Provides guidance and training to business unit technical staff and other team members.
Demonstrable ability to collaborate and gain consensus among a varied constituency.
Ability to direct other technical staff to deliver results that meet the business need and conform to standards of quality according to IT standard methodologies.
Able to bridge the gap between business domain expertise and technical skills, translating SME knowledge to staff members via mentorship and knowledge transfer
Provide consultation and direction to other technical staff on implementation approaches and make decisions on selecting the preferred approach among various options
Conduct interviews, hiring, termination and merit evaluation for staff
Demonstrated mastery of SQL
Extensive experience with SQL Server, Oracle, Greenplum, Postgres, TSQL, PL/SQL
Ability to develop stored procedures, ETL processes and report queries
Database design for both OLTP and OLAP implementations
Working understanding of Kimball data warehousing design methodologies, including star/snowflake schema, fact table design, dimensional modelling, type 2 slowly changing dimensions, etc.
Hands on experience in developing reports and data processes using the Microsoft Business Intelligence Stack (SSIS, SSRS, SSAS, SharePoint BI).
Experience in gathering and refining customer requirements
Minimum of 10 years of specific IT knowledge and applicable systems, hardware and software
Preferred 3-5 years in technology management role
- Undergraduate degree in computer science or equivalent experience.
The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.
We are proud to be an Equal Opportunity / Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives, and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate in employment decisions on the basis of any protected category.
A conviction is not an absolute bar to employment. Factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered in all employment decisions. Additionally, it's the bank's policy to only inquire into a candidate's criminal history after an offer has been made. Federal law prohibits banks from employing individuals who have been convicted of, or received a pretrial diversion for, certain offenses.
Job: Systems / Technology
Primary Location: CALIFORNIA-San Diego
Schedule Full Time
Req ID: 10029616-WD