Mainframe Data Analyst

Resource Profile

• Client is looking for a Legacy Data Analyst role with 8+ years of experience of working in Legacy/Mainframe sector, to assist with the planning, implementation and improving the quality of data by optimizing processes for the analysis, evaluation, and validation for data conversion process from Legacy Source Systems/Mainframe/AIX to Cloud Applications.
  


• This Role requires a blend, a mix of technical hand-on skills, business acumen, business and process analysis skills, creativity and strategic, thinking and usage of proactive approaches, data analysis tools and methods to support the profiling, evaluation, and validation of client Data quality.
  

Resource Responsibilities

• Provide subject matter expertise and contribute to the development, enhancement and sustenance of the Data Quality Program and manage processes and practices related to data quality to ensure data accuracy, viability, traceability, integrity, and value. This includes in-depth expertise related to:
  


• Identifying data quality risk, facilitating root-cause analysis, as well as resolving and communicating data quality issues impacting business analytics
  


• Developing data quality monitors, models, processes, and controls
  


• Leading projects that perform data quality assessment, conversion, monitoring, and validation
  


• Aligning activities and deliverables of the Data Quality Program to the Data Governance Framework and roadmap and contributing to the data strategy mandate
  


• Leveraging data quality industry best practices
  


• Coordinate and facilitate in-depth workshops with the Client IT department and business areas to elicit review, confirm and document functional specifications, business process re-engineering, information management architecture, data mapping, business models, and transformation rules and user interface design.
  


• Conduct impact analyses and assessments including AS-IS(Legacy/Mainframe) and TO-BE(Cloud) analysis and provide recommendations of options/solutions based on analysis.
  


• Responsible for the creation of data validation processes to ensure reliability and integrity of data solutions provided to the business.
  


• Provide support in creation of mapping and data lineage documentation from Source to Landing
  


• Responsible for assessing and validating data quality, ensuring data integrity during migrations, and providing technical guidance to modernization teams. 
  


• Establish and maintain effective communications and working relationships with delivery partners, consultants internal and external stakeholders to ensure quality and integrity of client data; Advise projects on the design and execution of data quality initiatives, guidelines, and standards. Provide specialized technical assistance and advice to other staff in data quality and integrity analysis and in the development of data quality measures.
  


• Act as an expert on data quality aspects of the client reporting and analytics data which includes development of complex queries and reports to extract, merge and compile data; in depth knowledge of business rules for data transformation, business definitions, dimensions and measures. Help in identifying data elements critical to business functions, conducting data analysis to validate the data elements, and gathering business rules for data quality analysis and monitoring.
  


• Create and deliver comprehensive and professional data quality metrics/dashboards, reports and/or presentations for client management, internal and external partners on a monthly basis or as needed, tailoring deliverables to appropriate level of detail and with the appropriate client focus.
  


• Lead and/or participate in data quality projects of varying in scope and complexity by creating and implementing project plans, including the gathering of requirements, determining objectives and timeframes, planning and conduct User Acceptance Testing, creating detailed Work Plans and Project Status reports.
  


• Provide client education in support of Data Quality initiatives by identifying training needs, providing support for any formal training required to maintain data quality and integrity, provide mentoring on the understanding of client data and demonstrations or training on how to effectively use data profiling tools available.
  


• Perform other duties as assigned or required.
  

Requirements

Knowledge & Skills

• Extensive experience working as Data analyst on Legacy/Mainframe technologies.
  


• Strong working knowledge on RDBMS (e.g. IBM DB2) and hands on experience on multiple databases including expertise in SQL language.
  


• Strong working knowledge of Mainframe technologies/tools like JCL, INSYC, SPUFI etc
  


• Experience reading and understanding IBM Datastage Jobs and Datasets will be preferred.
  


• Interpret data, analyze results using statistical techniques and provide ongoing reports.
  


• Excellent Communication and Collaboration Skills: Ability to work effectively with various stakeholders and teams. 
  


• Knowledge of SDLC and Agile Methodologies: Understanding of software development life cycle (SDLC) and Agile methodologies.
  


• Good to have SUPRA work experience.
  


• Experience working with the Canadian government or insurance-related systems.
  

Skill set

• 10+ year’s professional experience in Information Technology or Information Management and
  


• 10+ years prior experience in data quality or data management or applications functions.
  


• 8+ year experience working on Mainframe Platform, and extensive experience working with Legacy Data Management systems like IBM DB2, VSAM and IMS DB.
  


• 8+ years proven experience data analysis and mapping data from multiple sources to multiple target databases and identifying the transformation rules.
  


• 8+ years’ experience in data integration, testing, monitoring, troubleshooting and data extraction from diverse data sources (e.g. IBM DB2, VSAM, Flat Files, Excel, etc.) into target systems