MUFG Union Bank Lead Data Analyst - Vice President in Monterey Park, California

About MUFG Union Bank, N.A.

Join a bank that’s as committed to your future as you are. At Union Bank, a part of Mitsubishi UFJ Financial Group (MUFG), 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 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 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 Technical Business Analyst works with all technical resources to support technical deliverables and efforts. The Technical BA also works with Data Management Office (DMO) Business analysts and SME’s (when required) to understand all aspects of the business data to apply to technical solutions. Produce all technical deliverables to be consumed by modelers, developer, etc. In addition key roles include querying and profiling the data for data quality and ensuring it provides what is required and perform data analysis to support the Data Modelers. The Technical BA will also assist with mapping source data to the BDM including cleansing and Data Quality rules.


Evaluates business requirements.

Work with the Modelers, Developers, and DMO Business Analysts / Data Analysts to clarify the requirements.

Review functional requirements to support design and development.

Interface File Design (Grouping, formatting, data quality rules, error processes).

LOV (List of Values) Exceptions handling.

Build SQL for selection criteria and business rules.

Physicalize logical business rules.

Prepare Source to Target data mapping documentation for developers.

Define and document data quality checks (existence, consistency, defaults, cross field) and cleansing rules.

Query and profile data utilizing strong SQL skills.

Data Validation Profiling to support requirements and utilize for testing.

Working with QA team to help them better understand the requirements and to support them building test cases.

Work with developers on validation of Unit Testing.

Act as the first line of defense to conduct first level analysis in response to UAT issues and identify the root cause.

Update MDR with all data transformation logic.

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/Veterans

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.

Job: *Systems / Technology

Title: Lead Data Analyst - Vice President

Location: CALIFORNIA-Monterey Park

Requisition ID: 10009796-WD