This job has expired, please see additional jobs below
Data Quality Analyst
Sumitomo Mitsui Financial Group
White Plains, NY, United States
Job Details - this job has expired, please see similar jobs below
Overview
Data Quality Business Analyst
Business Analyst will assist the data quality manager and governance team in the deployment and execution of a comprehensive data quality framework. The Data Quality Business Analyst assists in the implementation of an enterprise data quality program with a specific focus on developing comprehensive Data Quality rules, exception handling and Data Quality Issue Management. Much of the focus and responsibilities includes the Data Quality Issue Management program and supporting all efforts and endeavors related to providing transparency about data issues and tracking the remediation efforts. The issue management program includes creating, supporting and evolving reports that has KPIs and measurements about the overall status and health of the data.
The business analyst will conduct end to end data and requirements analysis in order to understand the transformational and data processing lifecycles as the data migrates throughout the enterprise architecture. Candidate should be able to analyze data and identify any functional gaps (based on data quality exceptions generated through Data quality tool) relating to Banking domains i.e. Capital Markets, Corporate Banking, Finance, Risk etc.
Position is currently located at 277 Park Ave until November 2018 , the role will relocate to White Plains, NY .
Responsibilities
Position Responsibilities/Duties
Role requires a results-driven data associate to work and partner with subject matter experts to elicit data detailed quality rule requirements and support all phases of development and validation, testing and documentation. Candidate should be able to analyze (profiling) data, work with subject matter experts and identify any functional gaps in order to continuously improve upon data quality and fit for use standards established by the Enterprise Data Governance program which supports the Americas division.
Analyzing data - researching and documenting data elements (terms) used in current or new reports and any transformational activities as the data migrates and is further processed through SQL, ETL, stored procedures and ultimately reported (end to end) in order to implement data quality integrity checks and validations.
Leverage collected data to create visual analysis and reports that are shared within the organization and presented to executive levels as well as subsidiaries about any and all data quality issues. Create new KPIs and measures as well as designing interactive dashboards for technology implementations that helps the business understand state of quality and impact to their business.
Work with the data owners to support data quality initiatives and become a subject matter expert in assigned domains in order to understand key data elements and improve data quality. Eliciting and preparing documentation for data quality rule requirements and packaging for development through the normal software development life cycle (SDLC) and any testing activities.
Data Quality Requirements & Business Analysis
• Analyzing data, work flows or technical specification requirements for reports and any data migration plans and consolidation efforts to data marts within the centralized data warehouse - detecting anomalies in order to recommend data quality validation checks
• Manage the application of reference data in data quality domain and manage and deploy data quality rules on reference data key terms
• Create Data Quality Rules involving dimensions i.e. Completeness, Accuracy, Validity, and referential integrity
• Eliciting and preparing documentation for data quality rule requirements and packaging for development
• Develops comprehensive test plans and execution of plans
Issue Management – Data Quality Exceptions
• Support all facets of production ready data quality rules, exceptions, issue management and continuous tracking and reporting
• Highly proactive in monitoring issues and exceptions with data owners and subject matter experts
• Perform data quality root cause analysis on these functional gaps, conduct and organize sessions with SME’s to discuss or brainstorm
these gaps and present these functional gaps in a summarized manner to Domain SME’s
• Focus and support all aspects of data quality issue management and improvement, exception handling and alerting process
• Aids in reporting issues impacting data quality, documenting, tracking, root cause capture for file delivery and data quality impacting issues
• Coordinate solutions and fixes with data quality application technology support through change management, service requests, testing
and liaise with technology support from business and subsidiaries to track and resolve issues
Training and Documentation
• Work with data quality manager to promoting data quality best practices, creating data quality training program, root cause analysis training and creating templates and validations for data owners to leverage
• Create documentation, perform knowledge transfer and cross training for stakeholders to develop new data quality rules as well as help data stewards tasked with remediating data quality issues
• Produce and distribute daily/weekly team status reports or scorecards as well as contribute to project status reporting depending on the undertaking at and assist with any management reporting
Qualifications
• Data Detective - willing to roll up sleeves and dive into data as it is used, has dependencies upon reference data lists and ultimately transforms to front end reports for business consumption or ages in data mart
• Documentation for data quality requirements, project plans, test plans and comprehensive SDLC and determines impact assessments, functional specifications, flow charts (Visio)
• Root cause analysis and other diagnostic documentation's Identify risk in process and propose / implement controls
• Able to work as individual contributor role or manage Data Quality projects consisting of 1-2 employees and data governance team as a data steward
• Team player and able to fill in gaps, learn about data governance program, policies and tenants
• Able to work with large data in excel and suggest process enhancement ideas for some of the stakeholders working in Excel at the business unit level.
• Presentation skills for explaining data, metrics and results in PowerPoint
• Excel (advanced if possible), MS Office Applications and Visio, (SQL or knowledge of advanced formulas & pivot tables in excel would be very positive)