[Close] 

Senior Data Modeler, Assistant Vice President

Join a financial group that?s as committed to your future as you are. At MUFG (Mitsubishi UFJ (United Financial of Japan) Financial Group), we share a vision for our future, we share our successes, and we strive to bring out the best in each other in everything we do. Our 14,000 diverse colleagues are connected by a common ambition to create change for the better?from forging more dynamic career paths, to driving progress in our communities, to continuously reshaping the standards of global financial services. Positive impact starts here; see the change you can make as we strive to become the world?s most trusted financial group/./
Job Summary:
The Data Modeler/architect will be responsible for the design and development of the logical and physical data model based on source systems.
They will work closely with the Enterprise Data Architecture team to design, model and implement Standard Input and Output files which represent the business needs and can be used across the data platforms.
They will facilitate consistent business analysis, data acquisition and access analysis and design, database management, Systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the group level.
/Major Responsibilities:/
/ /
Analyze Business Requirements, design logical data models and systems functions and present to stakeholders
Coordinate and interact with technical and business groups within the department
Define Standard Integration points for data being captured into the Data Platforms
Define Standard Output constructs which allow business users to extract their own data consistently across business units where needed
Integrate Master Data and Reference data processes into the path
Work with the enterprise architecture team to define and implement the future state architecture and an interim strategy to move us towards the path.
Define data/information architecture standards, policies and procedures for the organization
Structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.
Ensure existing data/information assets are identified, stewarded and leveraged across the enterprise.
Review, verify and approve the Conceptual and Logical data models done by the owner teams for modeling standards, naming convention and properly defining all objects and relationships.
Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the database.
Create complex views and materialized views and tune for performance.
Administer and manage the users and privileges on Erwin or ER/Studio Data Architect tool & Portal Repository server.
Manage the repository server and all projects to follow the best standards and to keep them in sync with Prod.
Create/modify macros in the ER/DA tool to generate more user friendly reports in aiding the creation of the business glossary document in the format requested by business.
Enable enterprise wide metadata management using the MDR and Colibra tools
Publish data models, conduct training on DW model to developers, BA's, DA's, and QA resources
Mentor staff, direct and document application design strategies.
Bachelor?s degree with 5 years of banking & financial services industry experience.
At least 3 years designing 3NF models and dimensional models for financial data warehouse products using industry standard tools such as Embarcadero (preferred) and Erwin.
Experience in modeling other data warehouse concepts such as Standard Input Files, Standard Output Files, Data Lake, Big Data, and Master Data Management is required.
Data Quality and Data Governance concepts and experience is required.
Exposure to Hadoop, Informatica and Wherescape ETL or Business Intelligence tools is preferred.
Experience in modeling Commercial Lending products such as loans and guarantees, market products such as Derivatives and Fixed Income Securities is highly desirable.
Excellent inter-personal and communication skills.
Excellent mentoring skills
Must work well in a team environment.
Must be able to work effectively with a distributed team
Model maintenance via portal/website a plus.
/ /
/ /
/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./
/ /
To learn more about MUFG, review all current career opportunities, and apply please visit us online: www.mufg-americas.com/careers
/ /
/We are committed to leveraging the diverse backgrounds, perspectives and experiences of our workforce to create opportunities for our people and our business. Equal Opportunity Employer: Minority/Female/Disability/Veteran./
Job: Systems / Technology
Title: Senior Data Modeler, Assistant Vice President
Location: CALIFORNIA-Monterey Park
Requisition ID: 10018963-WD
Other Locations: CALIFORNIA-Sacramento


Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.