Data Modeler- Data Warehouse, Assistant Vice President
- Charlotte, NC
Discover this rewarding 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. We achieve this by delivering on our values, putting people first, fostering long-term relationships and inspiring the best in each other. This is all part of our inclusive, high-performing culture supported by Total Rewards that include our cash balance pension plan. Join a team that's working to fulfill its vision to be the world's most trusted financial group.
Overview:
The Data Modeler - Data Warehouse will design, implement and document data architecture and data modeling solutions, including but not limited to, Enterprise Data Warehouses, Enterprise Data Marts, and other product or subject-area marts required to support information management, business intelligence and other business purposes in MUFG. Analyzing business, technical and security requirements to determine approach and communicate intended outcomes. Liaise with business users, CDO, Data Management, Information Management, security and other stakeholders to determine direction and approach. Determine patterns and approach to evolve our Warehouses in line with the banks processes, standards, and procedures.
Main responsibilities:
- Function as an authoritative source for information on Warehouse data models and data architecture within the Corporate Functions Technology (CFT) department.
- Deliverables include Data model, Data architecture, standards, best practices, Data dictionary, Data lineage and Metadata management.
- Handle user inquires and research solutions.
- Participate in trainings and knowledge sharing sessions.
- Ensure best practices, standards, processes and procedures are followed.
- Support other CFT initiatives as required.
- 4+ years of experience in complex large-scale data warehouse projects, data integration projects and/or business intelligence projects
- Detail-oriented with excellent verbal and written communication, coordination, documentation, problem solving and time management skills.
- Expertise in designing, implementing, supporting and documenting data architecture and data models (OLTP, consolidation stores, dimensional stores, Data Vault and canonical) solutions for Enterprise Data Warehouse and Enterprise Data Mart in the banking domain (4+ years)
- Expertise in advanced SQL for databases such as DB2, Oracle, MS SQL Server, GreenPlum
- Expertise in advanced data modeling tools such as ERStudio and Erwin
- Strong experience in Agile, Water Fall and Iterative methodologies
- Data Quality and Metadata
- Exposure to Big Data & Cloud technologies, Graph Databases, NoSQL databases, AWS, etc. is a plus
- Master Data Management experience is a plus
- UML experience and knowledge a plus.
- Bachelors' Degree (or foreign equivalent degree) in Information Technology, Information Systems, Computer Science, Software Engineering or equivalent work experience
The above statements are intended to describe the general nature and level of the 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.
Back to top