Data Engineer (Aws & Oracle)

About CMiC
Headquartered in Toronto, CMiC is a software company focused on the Construction industry. We have built a comprehensive platform for construction companies to manage their most important workflows. Our customers have their choice of a SaaS or Private Hosted platform that includes industry-focused modules to manage everything from Financials and Payroll to Project Management and Budgeting. Our market share is very strong in North America and rapidly expanding internationally in regions like Europe, South East Asia and the Middle East.
Job Overview
CMiC is seeking a mid-level data engineer to join our team. As a Data Engineer, you’ll have the opportunity to create innovative data-driven features in our software platform that set us apart from our competitors. You’ll create data pipelines for machine learning projects and maintain internal prototypes for research & development. You will also act as a technical leader in various development teams on topics related to data-intensive applications. You’ll work closely with the Analytics Product Manager to bring ideas to life and to customers.
Duties & Responsibilities

• Work closely with developers, product managers, and other stakeholders to understand data requirements and translate them into technical specifications
• Ensure data security and compliance with relevant regulations and industry standards.
• Implement data validation and quality checks to maintain high data accuracy and reliability
• Continuously research and recommend new technologies and best practices for data engineering, cloud computing, and database management
• Collaborate with cross-functional teams to implement and deploy data solutions in a microservices architecture
• Design and implement API endpoints for data ingestion and retrieval
• Document data engineering processes, workflows, and architectural decisions to maintain knowledge sharing within the team
• Monitor, troubleshoot, and resolve issues in the data pipelines and databases to ensure smooth data flow and optimal performance
• Design, develop, and maintain scalable data pipelines using AWS services such as Glue, S3, and SageMaker

Requirements

• Excellent problem-solving skills and the ability to work independently or as part of a team
• Strong programming skills in languages such as Python, Java, or Scala
• Bachelor's degree in Computer Science, Engineering, or a related field
• Proficient in working with microservices architecture and building API endpoints.
• Strong communication skills, both written and verbal, with the ability to effectively collaborate with diverse teams.
• Hands-on experience with AWS services such as Glue, S3, and SageMaker
• 2+ years of experience as a data engineer or in a similar role
• Strong knowledge of Oracle databases (PL/SQL), including performance tuning, query optimization, and database administration
• Experience with data modeling, ETL processes, and data warehousing concepts
• Familiarity with big data tools and frameworks like Spark or similar

Benefits

• Paid vacation and personal days
• Health and Wellness focus including virtual yoga classes and wellness webinars
• 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)
• Located on York University’s campus, easily accessible by transit (TTC, GO, etc.), walking distance to shopping and restaurants
• Experience in a rapidly growing, socially responsible corporation
• RRSP Matching Program after 2 years of employment
• Townhall meetings where all employees are encouraged to participate in open discussions
• Competitive benefits Package (including Health & Dental benefits)

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.