Data Analyst-Data Quality/Software Engineer/Data Services

Job description

Job Purpose
· Development of definitions, data quality rules, thresholds, and standard metrics of quality for data elements that support critical business processes and elements
· Development of controls to mitigate data quality risks including data quality plan development, monitoring data quality results, reports and dashboards, as appropriate.
· Identify and maintain data quality corrective action plans.
· Support compliance assessment process by reviewing and documenting failures from data quality compliance assessment checks.
· Information Lifecycle Management
· Support metadata repository maintenance, access requests, and proper metadata association
Review, validate, and record metadata and data quality information.
Principal Accountabilities: key activities and decision making areas
· Actively participate in all relevant Data Quality Forums to escalate Data lineage issues impacting the specific country
· Articulate data findings in a manner that is understandable to a business team
· Ability to write complex data rules and rule sets in Information Analyzer using SQL or regular expression.
· Support archiving and purging activities of data
· Responsible to link business definitions in Collibra with data lineage tool
· Support creation of complete and accurate definitions for criticle data elements (CDE’s) as defined by the GB/GF
· Co-ordinate relevant meetings and work with different system owners to build data quality rules
· Analyzing data sets or data results (e.g. profiling results, results reporting) to draw inferences and identify adherence, or lack thereof, to business requirements.
· Ensure sensitive data is accessed and shared in accordance to defined policies and processes.
· Create and maintain reference data in accordance to defined processes and procedures.
Manage quality and maintenance of master data as it is created
Typical Targets and Measures
· No of workflows created and/or streamlined
· % of work requests completed within SLA
· No of CDE’s and underlying attributes approved
· % increase in Collibra usage
· No of users across GB/GF Trained
· Requirements clearly identified and documented
· Clearly defined and executed review/approval process

Customers / Stakeholders
· Build trusting relationships with business stakeholders by accurately documenting decisions, conversations and objections.
· Data Owners and Stewards in all Global businesses and functions including CDO’s
· Data Services Team

Typical Targets and Measures
· Clarity of group standard ownership and governance
· Communication of and adherence to Reference Data Standards Target Operating Model SLA’s

Leadership & Teamwork
· Interact effectively with related team management in GB/GF, Data Services and IT groups
· Demonstrate strong communication skills
· Demonstrate good analysis skills
· Ensure that solutions improve HSBC’s data management.
· Willingness to take on additional tasks and/or duties as needed.
· Cultivate an environment that supports diversity and reflects the HSBC brand.
· Set an example for team members when faced with adversity.
Enthusiasm for improvement and coaching more junior colleagues within the team
Typical Targets and Measures
· Completeness of proposed issue remediation plans
· Level of preparation for standards in approval
Positive example is demonstrated and examples provided by stakeholders and team-members
Operational Effectiveness & Control:

· Manage workload efficiently
· Escalate issues in a timely manner
· Report status according to team standards
Support a culture of common definitions and single dictionary/methodologies to contribute to enhanced operational efficiency by incorporating use of best practices, methodologies into change
Typical Targets and Measures
· Identify and track initiatives involved in creation, change and/or use of customer data processes, models and standards inside and outside the data management office.
· Bring control and standardization to the use and development of customer data models and standards across the organization.
Wherever possible and appropriate, leverage customer data best-practice models and standards being created outside the DMO by bringing them into the DMO and proliferating more widely.
Management of Risk
Maintain awareness of operational risk and minimize the likelihood of it occurring including its identification, assessment, mitigation and control, loss identification
Observation of Internal Controls

Maintain awareness of operational risk and minimize the likelihood of it occurring including its identification, assessment, mitigation and control, loss identification
Local Job Requirements
· Develop data profiling solutions, run analysis jobs and view results, and create and manage data quality controls using Information Analyzer
· Perform column analysis, rule analysis, primary key analysis, natural key analysis, foreign-key analysis, and cross-domain analysis
· Provide best practice guidance and support including; data profiling on designated data sets, conduct analysis on results and provide recommendations on rule development, configure and code data quality validation rules in designated tools (SQL and/or IBM Info Analyzer), reporting -schedule, review and packaging of results for business
· Demonstrate extensive knowledge of IBM's Information Analyzer's architecture, processing and deployment/configuration through the ability to create projects, add data sources, write, configure and execute rules/rule sets within Information Analyzer
Certifications, Qualifications & Experience
· Bachelor Degree or International Equivalent
· Excellent written and verbal communication skills; presentation skills preferred
· Focus on detail and consistency
· Strong prioritization and time management skills
· Banking experience with good business and product knowledge; especially in the area of Data Quality
· Expertise in data management, ideally, with strong awareness of Collibra (or similar), Data Quality practice, Tools and Processes
· Strong ETL development experience
· Good Data Warehousing experience
· Expertise in IBM Information Analyzer, Data Stage, DB2, Oracle
· Advanced experience with SQL Scripting.
· Ability to conduct analysis on the data using database querying, excel, and other methods
· Self-motivated, focused, detailed oriented and able to work efficiently to deadlines are essential
· Ability to work with a degree of autonomy while also being able to work in a collaborative team environment
High degree of personal integrity

Desired profile

Qualifications :

na