Batch Operations Engineer
ON, CA
Company Description
At Freedom, we’re proud to be leaders in a movement that brings affordable wireless services to Canadians – we’re always on the lookout for go-getters that are committed to disrupt the status quo.
Does that sound like you? We’d love to meet you.
Short Description
Reporting to the Manager, BI Analytics, the Batch Operations Engineer is part of a diverse & collaborative Analytical Data and Platforms team where you will get the opportunity to drive operations excellence initiatives and work cross-functionally with our business and IT partners. You will operate, monitor, trouble shoot daily batch loads of an operational data warehouse based on Snowflake and using ELT tool Matillion.
Job Description
- Execution and Monitoring of Snowflake based Data warehouse batch Loads using ELT tool Matillion
-
Coordinate with all essential IT and source system teams to analyze and resolve daily load issues
-
Analyze source and develop data controls, identify potential issues and develop custom action plan to mitigate them
-
Troubleshoot daily batch load issues with understanding the error log files of platforms and scripts
-
Performs data validation to confirm data is moved into the data warehouse correctly
-
Support Development & Testing team for their data needs and availability
-
Works with reporting teams to assist them in understanding any reported variances between the data warehouse and source system
-
Adhere to Incident & issue management processes and resolve them to comply with SLAs
-
Prepare daily Batch report with all incident and stats
-
Self-motivated team player with excellent problem solving and communication skills
Qualifications
- Have bachelor’s degree in computer science, Information Science, or relevant Certifications
- Have 2+ years hands-on experience on on-prem & Cloud native data platforms like Snowflake, Oracle, SQL Server and Postgres
- Have 2+ years hands-on experience on ETL/ELT tools like Informatica IICS, Matillion
- Have 2+ years hands-on experience of creating data pipelines
- Experience in Python and Unix Shell Scripting
- Experience in development of SQL Scripting
- Experience is JSON Scripting
- Certifications in relevant fields of work
- Proficiency in French (spoken and written) at the advanced level. The person who fills this position will be required to communicate with our French-speaking external partners outside Ontario on an frequent basis.
Additionnal Information
- Salary: Commensurate with qualifications and experience.
- Take advantage of a customizable health & dental benefits program and opportunities for company-matched pension (according to position).
- Promote your health with the wellness program, which focuses on physical, psychological, financial, and social health.
- Benefit from the Employee Assistance Program for you and your family, including Virtual Healthcare.
- At Freedom, we recognize your great work through a monthly & yearly Sales Excellence Awards Program, corporate line with provided service, device subsidy and discounts on Freedom products & services.
- Participate in projects that make an impact and take on challenges that will allow you to surpass yourself.
- Develop your full potential and imagine what you can become within Quebecor’s family through our various career opportunities.
- This posting is for an existing vacancy.
Check out our Activity Report for an overview of the projects to which you could contribute !
We value your uniqueness !
We are committed to creating and maintaining an accessible, equitable and inclusive workplace that reflects the diversity of the community to which we belong. We strive to provide a work environment where each individual is valued and respected for who they are and can realize their full potential. We're eager to discover all the qualities that make you unique!
We are happy to make accommodations to promote accessibility upon request. If you need an accommodation at any stage of the process, please don't hesitate to let us know when you first contact us.