USACares Jobs

Job Information

MUFG Union Bank Systems Analyst, Assistant Vice President (ETL, DW) in Charlotte, North Carolina


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.

Job Summary:

Data Analyst with a strong foundation of MUFG products and data in required subject areas within risk, finance, regulatory, and compliance.

Major Responsibilities:

  • Gather, elicit, analyze, document, and translate business requirements (functional and non-functional) into technical specifications and other supporting documentation.

  • Create and maintain technical specifications, flowcharts, mapping specifications, data dictionaries, metadata, and lineage documents.

  • Communicate with business users and evaluate requirements to understand project objectives, scope and conducts formal requirement walkthroughs and obtains user concurrence.

  • Understand data lineage across complex current state system environments and target state.

  • Performing data analysis including data extraction with standard SQL Tools.

  • Writing and executing queries to profile large data sets.

  • Responsible for the most highly complex projects that require in-depth knowledge across multiple technical areas and business segments.

  • Capturing business and data requirements as appropriate within system development lifecycle across business and technology.

  • Responsible for the most highly complex projects that require in-depth knowledge across multiple technical areas and business segments.

  • Works as a project team member on multiple projects to facilitate process improvements involving multiple sites or business areas.

  • Working with data domains within banking including Deposits, Commercial Loans, Residential Loans, Trade Finance, Derivatives, Forex, Fixed Income, Swaps, Risk Management, Finance and Accounting.


  • Requires a Bachelor’s degree (or higher) OR equivalent work experience in a related field

  • 5 years of Data Analysis, prior experience working with industry best practices is preferred.

  • Experienced in complex large-scale data warehouse projects, data integration projects, and/or business intelligence projects.

  • Hands-on expertise in developing ETL (Extract, Transform and Load) mappings and workflows in complex large-scale data warehouse and data integration projects in the banking industry using Informatica is preferred.

  • Expertise in relational and dimensional databases like UDB DB2, Oracle, Green Plum and SQL Server.

  • Proven ability to handle and prioritize multiple projects and meet deadlines

  • Ability to work independently with minimal supervision and as a member of various teams

  • Capacity to identify and understand business needs and incorporate into technical requirement solutions

  • Proven analytical and problem-solving skills for assessment of complex production support issues and recommend/implement effective solutions

  • Strong communication skills, both written and verbal, are required.

  • Strong work ethic, ability to make decisions and work under tight deadlines; achievement oriented and takes initiative"

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: Technology

Primary Location: ARIZONA-Tempe

Other Locations: NORTH CAROLINA-Charlotte

Schedule Full Time

Shift Day

Req ID: 10038913-WD