As a Batch Operations Engineer you will be part of a diverse & collaborative Analytical Data and Platforms team where you will get the opportunity to drive operations excellence initiatives and work crossfunctionally 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.
The responsibilities will include:
- 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.
- Selfmotivated team player with excellent problem solving and communication skills.
- Able to work during shifts.
Qualifications :
- Have bachelors degree in computer science Information Science or relevant Certifications.
- Have 2 years handson experience on onprem & Cloud native data platforms like Snowflake Oracle SQL Server and Postgres.
- Have 2 years handson experience on ETL/ELT tools like Informatica IICS Matillion.
- Have 2 years handson 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.
Additional Information :
- Take advantage of a customizable health & dental benefits program and opportunities for companymatched 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.
- 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 Quebecors family through our various career opportunities. #LiNA1
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. Were 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 dont hesitate to let us know when you first contact us.
Remote Work :
No
Employment Type :
Fulltime