Data Extraction Specialist

About CMiCHeadquartered in Toronto, CMiC is a global software company focused on the Construction industry. We have built a comprehensive platform for construction companies to manage their most important workflows. Our customers can choose between a Cloud or Self-Hosted deployment that includes industry focused modules to manage everything from Financials and Payroll to Project Management and Job Costing. We have a strong market share in North America and rapidly expanding internationally in regions like Europe, Southeast Asia and the Middle East.Job Overview:The Data Extraction Specialist is responsible for the creation, maintenance, and execution of CMiC Data Mapping and Extraction scripts, which will be used for extracting data from multiple legacy systems for import into CMiC database. This position requires the ability to effectively communicate with customers, flexibility to work outside of regular working hours, and willingness to learn CMiC software in order to evaluate best ways of matching customer’s data with CMiC data structure. Duties & Responsibilities: Analyze and document scope of work for Data Extraction projects Provide estimates for Data Mapping and Extraction scripts creation Design, develop, and maintain scripts and queries for Data Mapping and Extraction tasks from multiple legacy systems on different platforms. Examine, design, develop, and maintain SQL scripts and queries for Data Conversion tasks Work with external Data Extraction programmers to understand and resolve issues with incoming data Assist customers with Data Mapping and Extraction activities Work with data owners to verify data accuracy and integrity Develop and execute database queries as needed Performs data corrections through analyzing data for errors and formulating corrective procedures Work with other team members to efficiently troubleshoot issues related to Data Conversion Provide ongoing status and feedback of the Data Conversion process to all parties involved Other related duties as assigned. Travel to customer sites approximately 50% of the time Requirements Minimum 3-5 years professional programming experience using SQL and PL/SQL Minimum 3-5 years of experience extracting/converting data from multiple systems, such as Sage, Viewpoint, Coins, JD Edwards, Bill Smart or Jonas, to an Oracle Database. MUST have 3-5 years of experience working with Oracle 11g, 12c, 18c, 19c Databases Experience with SQLServer and MySQL Candidates will also need to travel outside of Canada, as necessary Advanced Knowledge and Experience with MS Excel (formulas, etc.) A self-starter who takes initiatives but seeks the assistance of others when necessary Excellent problem solving and customer service abilities Excellent verbal and written communication skills University Degree, preferably in Computer Science MUST have the flexibility to work "off" hours such as: 5pm-9pm (weekdays) and some weekends, when necessary Benefits Competitive benefits Package (including Health & Dental benefits) Paid vacation and personal days Townhall meetings where all employees are encouraged to participate in open discussions Located on York University’s campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurants Outdoor lunch space, including picnic tables An active Social Events Committee (past events include annual seasonal parties, pool and bowling tournaments, karaoke nights, Game nights, BBQ’s, and more) Health and Wellness focus including virtual yoga classes and wellness webinars RRSP Matching Program after 2 years of employment Experience in a rapidly growing, socially responsible corporation CMiC is an Equal Opportunity Employer. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, CMiC will provide accommodation to applicants with disabilities throughout the recruitment, selection and/or assessment process. If selected to participate in the recruitment, selection and/or assessment process, please inform Human Resources staff of the nature of any accommodation(s) that you may require.