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. Important Information: • The overall hiring salary range for this position is $75,000 to $85,000 plus up to 25% bonus annually • This position is for an existing vacancy • We do not use AI to screen, assess, or select applicantsDuties & Responsibilities: Analyze 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 platforms.Examine, 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 assigned.Travel to customer sites approximately 50% of the timeRequirementsMinimum 3-5 years professional programming experience using SQL and PL/SQL Minimum 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 Database. MUST have 3-5 years of experience working with Oracle 11g, 12c, 18c, 19c Databases Experience 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.
About CMiC
Headquartered 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.
Important Information:
• The overall hiring salary range for this position is $75,000 to $85,000 plus up to 25% bonus annually
• This position is for an existing vacancy
• We do not use AI to screen, assess, or select applicants
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-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 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, BBQs, 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.
CMiC is the leading provider of an AI-powered, fully integrated construction ERP platform purpose-built for general contractors, specialty contractors, and civil/heavy-highway firms. Built on a Single Database Platform™, CMiC delivers a unified suite of Financials, Project Management, and Project Controls applications designed to manage the full complexity of construction operations. Core financial applications include Accounting, HR and Payroll, Opportunity Management (CRM), Resource Planning, and Inventory and Equipment Management. On the project management side, CMiC covers Bidding and Procurement, Drawing Management, and Project Management. Trusted by 1 in 5 General Contractors on Engineering News Record's Top 400, CMiC is an award-winning platform that enterprise construction firms rely on globally to drive financial control, operational efficiency, and project predictability. With a 25% market share among North America's top 400 contractors and a growing international footprint, some of the largest construction firms in the US have chosen CMiC as their long-term strategic ERP partner.CMiC's turnkey model means implementation, support, development, and customer success are all managed in-house, giving firms a single, accountable partner from initial deployment through long-term growth. With no middleware dependencies and over 50 integration partners, CMiC connects seamlessly with the tools and systems construction firms already rely on.CMiC's industry leadership has been consistently recognized by leading organizations. Deloitte has named CMiC a Best Managed Company for over seven years, a distinction it now holds at Platinum status. CMiC has also earned Construction Executive's Top Tech Award, BuildWorld's Preconstruction Tech Top 50, and Featured Customer's Market Leader Award.
CMiC is the leading provider of an AI-powered, fully integrated construction ERP platform purpose-built for general contractors, specialty contractors, and civil/heavy-highway firms. Built on a Single Database Platform™, CMiC delivers a unified suite of Financials, Project Management, and Project Controls applications designed to manage the full complexity of construction operations. Core financial applications include Accounting, HR and Payroll, Opportunity Management (CRM), Resource Planning, and Inventory and Equipment Management. On the project management side, CMiC covers Bidding and Procurement, Drawing Management, and Project Management.
Trusted by 1 in 5 General Contractors on Engineering News Record's Top 400, CMiC is an award-winning platform that enterprise construction firms rely on globally to drive financial control, operational efficiency, and project predictability. With a 25% market share among North America's top 400 contractors and a growing international footprint, some of the largest construction firms in the US have chosen CMiC as their long-term strategic ERP partner.
CMiC's turnkey model means implementation, support, development, and customer success are all managed in-house, giving firms a single, accountable partner from initial deployment through long-term growth. With no middleware dependencies and over 50 integration partners, CMiC connects seamlessly with the tools and systems construction firms already rely on.
CMiC's industry leadership has been consistently recognized by leading organizations. Deloitte has named CMiC a Best Managed Company for over seven years, a distinction it now holds at Platinum status. CMiC has also earned Construction Executive's Top Tech Award, BuildWorld's Preconstruction Tech Top 50, and Featured Customer's Market Leader Award.
