Data Quality Business Analyst-White Plains, NY

New York, NY 10172

Post Date: 08/02/2018 Job ID: 3291389 Industry: Analyst
Data Quality Business AnalystBusiness 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.Note that the position will start in New York City and transition to Westchester in November 2018.Responsibilities: 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 Analysiso 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 checkso Manage the application of reference data in data quality domain and manage and deploy data quality rules on reference data key termso Create Data Quality Rules involving dimensions i.E. Completeness, Accuracy, Validity, and referential integrityo Eliciting and preparing documentation for data quality rule requirements and packaging for developmento Develops comprehensive test plans and execution of plans Issue Management Data Quality Exceptionso Support all facets of production ready data quality rules, exceptions, issue management and continuous tracking and reportingo Highly proactive in monitoring issues and exceptions with data owners and subject matter expertso Perform data quality root cause analysis on these functional gaps, conduct and organize sessions with SME s to discuss or brainstormo these gaps and present these functional gaps in a summarized manner to Domain SME so Focus and support all aspects of data quality issue management and improvement, exception handling and alerting processo Aids in reporting issues impacting data quality, documenting, tracking, root cause capture for file delivery and data quality impacting issueso 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 Documentationo 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 leverageo 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 issueso 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 reportingQualifications: o 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 marto Documentation for data quality requirements, project plans, test plans and comprehensive SDLC and determines impact assessments, functional specifications, flow charts (Visio)o Root cause analysis and other diagnostic documentation's Identify risk in process and propose / implement controlso Able to work as individual contributor role or manage Data Quality projects consisting of 1-2 employees and data governance team as a data stewardo Team player and able to fill in gaps, learn about data governance program, policies and tenantso 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.O Presentation skills for explaining data, metrics and results in PowerPointo Excel (advanced if possible), MS Office Applications and Visio, (SQL or knowledge of advanced formulas & pivot tables in excel would be very positive)

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: