DataExtractionSpecialist

**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 correct