Database Administrator/Analyst

at  Procom

DATABASE ANALYST/ADMINISTRATOR

On behalf of our client, Procom is seeking a Database Analyst/Administrator for a 6 month contract working hybrid in Edmonton.

Database Analyst/Administrator Responsibilities

• Uses SAP BusinessObjects Data Services to create and run ETL jobs
• Elicits and documents data requirements and specifications from functional users, system owners and subject matter experts;
• Identifies and communicates efficient ways to collect, cleanse and maintain data;
• Translates data requirements into a best fit within SAP Cloud ERP solutions;
• Works with legacy systems to extract source data in preparation for migration to SAP Cloud ERP solutions;
• Performs data cleansing of data across different systems; and
• Performs data validation, quality assurance, user interface verification activities in preparation for migration to SAP Cloud Solutions.
• Develops data migration guidance and pre-configured templates to collect data;
• Performs data analysis, mapping and transformation rules to convert and interface data;
• Programs and maintains SQL scripts to meet data transformation loading requirements;
• Supports application configuration and security setup;
• Evaluates and provides feedback on system and functional design documents and other associated artifacts;
• Implements complex ERP configurations and end to end development design;
• Performs data discovery by evaluating conversion data elements;
• Ensures data conversion activities are completed in accordance with SAP Cloud ERP solution releases;
• Performs data conversion and loads legacy data into new SAP Cloud ERP solutions; and
• Manipulates the data to meet import requirements while maintaining data integrity and timely conversions.
• Defines test scenarios based on data requirements;
• Creates test scripts to prove each scenario through system and user acceptance testing supports;
• Assists in System Integration Testing and User Acceptance Testing;
• Performs quality assurance exercise to ensure data is mapped and transformed properly;
• Investigates sources of data inconsistencies or issues in the new SAP Cloud ERP solutions;
• Analyzes data integrity and corrects data flow process; and

Database Analyst/Administrator Mandatory Skills

• 7+ years of experience as a Database Administrator
• Excellent verbal and written communication skills
• SAP ECC experience
• SAP ABAP experience
• Microsoft SQL Server experience
• On call availability may be required
• Deep level knowledge of relevant hardware / software
• Knowledge of database architecture for stability and performance
• Previous experience supporting, maintaining and configuring system databases
• Degree in a related discipline

• Uses SAP BusinessObjects Data Services to create and run ETL jobs
• Elicits and documents data requirements and specifications from functional users, system owners and subject matter experts;
• Identifies and communicates efficient ways to collect, cleanse and maintain data;
• Translates data requirements into a best fit within SAP Cloud ERP solutions;
• Works with legacy systems to extract source data in preparation for migration to SAP Cloud ERP solutions;
• Performs data cleansing of data across different systems; and
• Performs data validation, quality assurance, user interface verification activities in preparation for migration to SAP Cloud Solutions.
• Develops data migration guidance and pre-configured templates to collect data;
• Performs data analysis, mapping and transformation rules to convert and interface data;
• Programs and maintains SQL scripts to meet data transformation loading requirements;
• Supports application configuration and security setup;
• Evaluates and provides feedback on system and functional design documents and other associated artifacts;
• Implements complex ERP configurations and end to end development design;
• Performs data discovery by evaluating conversion data elements;
• Ensures data conversion activities are completed in accordance with SAP Cloud ERP solution releases;
• Performs data conversion and loads legacy data into new SAP Cloud ERP solutions; and
• Manipulates the data to meet import requirements while maintaining data integrity and timely conversions.
• Defines test scenarios based on data requirements;
• Creates test scripts to prove each scenario through system and user acceptance testing supports;
• Assists in System Integration Testing and User Acceptance Testing;
• Performs quality assurance exercise to ensure data is mapped and transformed properly;
• Investigates sources of data inconsistencies or issues in the new SAP Cloud ERP solutions;
• Analyzes data integrity and corrects data flow process; an