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 OverviewThe 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.Important InformationThe overall hiring salary range for this position is $75,000 to $85,000 plus up to 25% bonus annuallyThis position is for an existing vacancyWe do not use AI to screen, assess, or select applicantsDuties & ResponsibilitiesAnalyze and document scope of work for Data Extraction projectsProvide estimates for Data Mapping and Extraction scripts creationDesign, develop, and maintain scripts and queries for Data Mapping and Extraction tasks from multiple legacy systems on different platformsExamine, design, develop,



and maintain SQL scripts and queries for Data Conversion tasksWork with external Data Extraction programmers to understand and resolve issues with incoming dataAssist customers with Data Mapping and Extraction activitiesWork with data owners to verify data accuracy and integrityDevelop and execute database queries as neededPerforms data corrections through analyzing data for errors and formulating corrective proceduresWork with other team members to efficiently troubleshoot issues related to Data ConversionProvide ongoing status and feedback of the Data Conversion process to all parties involvedOther related duties as assignedTravel to customer sites approximately 50% of the timeRequirementsMinimum 3-5 years skilled programming experience using SQL and PL/SQLMinimum 3-5yrs experience with Sage DB and SQL Server Management Studio (SSMS) (Must Have)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 DatabaseMUST have 3-5 years of experience working with Oracle 11g, 12c, 18c, 19c DatabasesExperience with SQLServer and MySQLCandidates will also need to travel outside of Canada, as necessaryAdvanced Knowledge and Experience with MS Excel (formulas,



etc.)A self-starter who takes initiatives but seeks the assistance of others when necessaryExcellent problem solving and customer service abilitiesExcellent verbal and written communication skillsUniversity Degree, preferably in Computer ScienceMUST have the flexibility to work "off" hours such as: 5pm-9pm (weekdays) and some weekends, when necessaryBenefitsCompetitive benefits Package (including Health & Dental benefits)Paid vacation and personal daysTownhall meetings where all employees are encouraged to participate in open discussionsLocated on York University's campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurantsOutdoor lunch space, including picnic tablesAn active Social Events Committee (past events include annual seasonal parties, pool and bowling tournaments, karaoke nights, Game nights, BBQs, and more)Health and Wellness focus including virtual yoga classes and wellness webinarsRRSP Matching Program after 2 years of employmentExperience in a rapidly growing, socially responsible corporationCMiC 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.#J-18808-Ljbffr

📌 Data Extraction Specialist - $75,000 - $85,000 A Year (Winnipeg)
🏢 CMiC
📍 Winnipeg