Data Quality & Controls Engineer Assistant Vice President

Mitsubishi UFJ Financial Group, Inc   •  

Jersey City, NJ

Industry: Finance & Insurance


5 - 7 years

Posted 78 days ago

This job is no longer available.

Major Responsibilities

  • Understand Data Governance Framework consisting of Business Information Model, Metadata Management Framework, Golden Sources Management, Integrated Controls Framework, and Data Quality Problem Management Processes.
  • Analyze the KDEs for reports or consumption processes submitted by LOBs or Consumers.
  • Work with the Domain Working Groups to understand KDE mapping to BIM (Business Information Model) Domains and Sub Domains.
  • Identify Data Quality Control Points for source data extraction and ingest data into DQ staging through ETL
  • Query and profile data. Prepare Source to Target data mapping documentation for developers
  • Understand DQ dimensions applicable for each KDE (Key Data Element).
  • Define data quality checks (existence, consistency, defaults, cross field) and cleansing rules
  • Develop DQ rules in Informatica Data Quality.
  • Analyze DQ results, anomalies, create dashboard.
  • Document data quality issues.
  • Prepare Source to Target data mapping documentation for developers
  • Perform DUT/SIT/UAT/DR/regression testing activities.
  • Handle user inquires and production support.
  • Create and maintain project, design, and other required documentation.
  • Conduct trainings and knowledge sharing sessions.
  • Support ISA/BIT initiatives as required.

Additional Responsibilities may include:

  • Support the department with data quality architecture, best practices, and patterns.
  • Come up with reusable data quality framework that's parameter driven
  • Work with offshore developers
  • Act as Agile Scrum Master as assigned
  • Assist management with data quality estimation model (to be used for future projects)
  • Consolidate data quality technical specs and maintain in a central location
  • Assist with Controls implementation for Golden Sources/Aggregation Layer

Additional Requirements

  • College degree, preferably a B.S. in Computer Science, Engineering, Management Information Systems or a related field or the equivalent
  • Hands-on expertise in developing object oriented programs in a multi-tier data integration/data management platform in the banking industry. (5+ years)
  • Hands-on experience in designing or using relational and dimensional databases in the banking industry. (3+ years)
  • Hands-on experience in developing web based applications using .NET (3+ years)
  • Hands-on experience in advanced SQL and advanced Excel functions. (3+ years)
  • Hands-on experience in using Enterprise Scheduler (Autosys). (2+ years)
  • Experienced in waterfall and agile SDLC methodologies. (3+ years)
  • Subject-matter expertise in Data Quality/Data Accuracy (2+ years)
  • Knowledge of Informatica Power Center and Informatica Data Quality a plus.
  • Detail-oriented with excellent interpersonal, verbal and written communication, coordination, documentation, analytical, problem solving, leadership, and time management skills.
  • 10026465