MUFG Union Bank Data Quality & Controls Engineer in Charlotte, North Carolina
Do you want your voice heard and your actions to count?
Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), the 5th largest financial group in the world (as ranked by S&P Global, April 2018). In the Americas, we’re 13,000 colleagues, striving to make a difference for every client, organization, and community we serve. We stand for our values, developing positive relationships built on integrity and respect. It’s part of our culture to put people first, listen to new and diverse ideas and collaborate toward greater innovation, speed and agility. We’re a team that accepts responsibility for the future by asking the tough questions and owning the solutions. Join MUFG and be empowered to make your voice heard and your actions count.
Data Quality & Controls Engineer, AVP
Senior Data Quality & Controls Engineer with a strong working experience in Financial Services Industry to implement re-usable frameworks for Golden Sources Reconciliations and controls and ensure consistency across domains/layers. Assist the management with capturing metrics for Comprehensiveness Controls measurement points and golden sources and present the metrics in a data quality metrics dashboard. Contribute to the organization’s efforts for Enterprise Data Quality Problem Management process and document/build a Controls Playbook as part of establishing target operating model. With a deep understanding of the Data Management Tools and Technologies with strong implementation experience in Controls and Reconciliations. Work in conjunction with Data Management IT, CDO, and Golden Sources Stakeholders to assess the intended outcomes of business, technical, quality, and security requirements to achieve the intended outcomes while following the banks processes, standards, and procedures.
Function as data reconciliation SME and supply technical/functional knowledge on required subject-areas and systems.
Domain experience in General Ledger Reconciliations products and services.
Plan, design, document, develop, test, implement, monitor, maintain, and support data reconciliation in Golden Sources, Data warehouses, Data Marts and associated source systems and downstream systems.
Develop and maintain reconciliation for complex ETL mappings and workflows, based on technical specifications and other supporting documentation, using advanced SQL, and Enterprise Scheduler.
Perform DUT/SIT/UAT/DR/regression testing activities.
Handle user inquires and production support.
Conduct trainings and knowledge sharing sessions.
Ensure standard methodologies, standards, processes, and procedures are followed.
Support Information Management and other IT initiatives as required.
Hands-on expertise in developing data reconciliations solutions in complex large-scale data warehouse and data integration projects in the banking industry. (2 years)
Financial General Ledger Reconciliation experience (3 years)
Hands-on expertise with Scripting languages (UNIX, Python ) and ETL (Informatica)
Hands-on experience in designing relational and dimensional databases in the banking industry. (3 years)
Hands-on experience in advanced SQL and advanced Excel functions. (3 years)
Hands-on experience in Enterprise Schedulers such as Tidal, Autosys. (3 years)
Experienced in waterfall and agile SDLC methodologies. (3 years)
Experience in one or more of the three domains - Risk, Finance, and Compliance- in the banking industry.
UML experience and knowledge a plus.
Bachelors’ Degree (or foreign equivalent degree) in Information Technology, Information Systems, Computer Science, Software Engineering or a related field
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: Systems / Technology
Primary Location: NORTH CAROLINA-Charlotte
Schedule Full Time
Req ID: 10029661-WD