Skip to main content
Search Jobs

Reset

Systems Analyst, Assistant Vice President (ETL, DW)

Charlotte, North Carolina; Tempe, Arizona

Tech at MUFG

MUFG is undertaking a significant transformation initiative that will make us an agile company that is powered by a resilient, flexible technology and data stack. This means investing in talent, technologies, and tools that put our clients' and colleagues' changing needs first.

We are looking for resilient technologists who will help us build the future of banking with a new digitally-led, cloud-first, real-time deposit system. This is a rare opportunity to transition to a modern platform as a member of this high-impact team.

Backed by the strength and stability of the world’s 5th largest financial institution, you'll help build a bank you’ll be excited to call yours.

Success Profile

What makes you successful in your technology career at MUFG?
Check out the top skills we’re looking for and see if you have the right mix.

  • Adaptable
  • Collaborative
  • Client-centric
  • Problem-solver
  • Forward-thinking
  • Agile

Culture

Our Culture Principles:

  • Client Centric
  • People Focused
  • Listen Up/Speak Up
  • Innovate & Simplify
  • Own & Execute

Tech Transformation

Benefits & Total Rewards

  • Health Plans

    Numerous choices for medical coverage (HRA, HSA, and PPO), plus comprehensive prescription coverage, dental and vision. We pay most premium costs and contribute to your HSA or HRA annually.

  • Wellness

    Monthly financial and wellness webinars, on-site healthy living events and one-on-one personal coaching sessions.

  • 401(k)/Retirement Plans

    Competitive 401(k) employer match contributions with immediate vesting. Cash balance pension, defined benefit plan with 3-year vesting, fully employer-paid.

  • Education & Training

    Tuition reimbursement for most undergraduate, graduate, and job-related courses at regionally accredited institutions. Internal training programs/courses are also available.

  • Family-Friendly Care

    Programs and resources to support family wellness, including: maternity/paternity leave, parental bonding, adoption assistance program, dependent care and family medical leave.

  • Paid Time Off

    Vacation, sick leave, time off to volunteer, and federal holidays, as well as salary continuation during periods of qualifying disability.

Job Description

Systems Analyst, Assistant Vice President (ETL, DW)

  • Requisition # 10038912-WD
  • Job Type Day
  • Location Charlotte, NORTH CAROLINA
  • Other Locations Tempe
  • Date posted 10/15/2020

Your potential. Your opportunity.

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.

    Apply Now

    Similar Jobs

    View All of Our Available Opportunities

    Recognition

    Diveristy at work 100% score on human irghts campaign Corporate Equality Index 2014 - 2020 Quote: Our Culture gives me reason to believe in our vision.  Day in and day out, we all come together as one MUFG. Erjin S. Managing director, Transaction Banking Our achievements.  Best Corporate Bank in the World.  Global Finance - 2018