Senior Data Analyst required to assist Modernization project transitioning from legacy systems to COT platforms. (131019)

Our GTA based, Municipal Government Client requires the services of a Senior Data Analyst to assist their Modernization project transition from legacy systems to COT platforms.

ROLE:

Our Municipal Government Client is looking for an experienced Data Analyst to work with their Modernization Project team. The purpose of the Modernization Project is to replace the 25-year-old legacy system with a modernized tool that will address increased operational demands, have enhanced functionality, and be compliant with the legislative and security (CISO) requirements. It will allow Client's staff to provide the services more efficiently which would facilitate revenue generation. The system is used by Client Services, Engineering & Construction Services, Water and 3rd parties utilities companies (Enbridge, Rogers, Bell) staff.

The Business Systems Analyst will be responsible for carrying out the duties described below, when working in a hybrid mode. There might be additional travel required across various office locations within the GTA.

The Data Analyst will work as a part cross-functional project team to provide data related services as required and assigned (during SDLC) as per the following:

Provide support and perform data related activities such data profiling, data mapping, data maintenance/quality and table changes associated with software applications; apply statistical and analytical techniques to derive insights and trends from complex datasets.

Engage in control activities to ensure data quality and adherence to enterprise data policy; perform exploratory data analysis to uncover trends, patterns, and anomalies. Create and/or review Data Profiling and Legacy Landscape Reports

Work with business systems analysts to define and document the scope and functional requirements for data and reporting needs, including the conceptual data model and data flow for the solution.

Analyze, develop specifications, and execute data mapping and transformation processes and requirements within and between applications.

Ensure data integrity by executing necessary processes and controls around the flow of data.

Assist in the design and execution of the overall Extract, Transform, and Load (ETL) processes and architecture.

Utilize technology to analyze data and/or metrics from applicable systems to review data processes, identify issues, determine actions to resolve or escalate problems that require data, systems, or process improvements.

Perform data‐related research and root cause analysis activities, provide correction specifications, and escalate issues as appropriate; Develop and execute scripts and workflows to automate data collection, data cleansing, and data reconciliation.

Validate data accuracy, completeness, and integrity. Identify and address data quality issues and discrepancies. 10. Collaborate with cross-functional teams to design and deliver actionable data insights, participate in Data Quality Assurance and other data related project activities.

Provide input to data architecture discussions and data related decisions on request.

Develop various projects artifacts including entity relationship diagrams by using Business Processes Modeling (BPM)/its Notation (BPMN)/ Unified Modeling Language (UML).

MUST HAVE:

• University degree in Computer Science, Data Science, Information Systems or related discipline.
• 7+ years extensive experience with Systems/Data Migration Projects especially involving legacy systems transitioning to COTS Platforms including data profiling, data mapping, transformation and validation processes.
• 5+ years hands-on experience with SQL, ETL including writing SQL queries and designing/executing ETL (Extract, Transfer and Load) processes to move and reconcile data between old and new system and UML.
• 5+ years working experience in preparing project documentation such as Data Profiling, Data Mapping and Data Quality Documents
• Experience in a government/public sector setting on modernization and replacement legacy system projects.
• Working experience with technical and business teams in supporting Accessibility for Ontarians with Disabilities Act (AODA), Security Threat and Risk Assessment (STRA), Privacy Impact Assessment (PIA);