Data Engineer

At Irving Consumer Products, we recognize that the key to our success is our people. Irving Consumer Products is a leading manufacturer of premium tissue products – including national brands and private label. We pride ourselves in our commitment to providing the best quality products and exceptional service to our consumers and customers. We are also part of a larger organization that acts responsibly when it comes to sustainable practices that begins with a history rooted since 1957. We have planted 1.1 billion trees since then, and have been recognized as a Carbon Neutral Forest Supply Chain. We also manufacture private label diapers and training pants for North American retailers.

The Data Engineer will be based out of any of our sites in the US and CA. The Data Engineer will organize, analyze, understand, and enhance ICP’s manufacturing data to enable self-service business intelligence (BI). As the Data Engineer, you are responsible for developing centralized, reusable data assets shared with report authors and analysts within ICP’s operations. Using your knowledge of ICP’s infrastructure and operating environment, you will ensure data is ingested, transformed, scheduled, tested, documented, and ready to be used for business intelligence. You are a data evangelist, educating the business on the importance and benefits of data for business decisions while promoting easily accessible, standard data assets and documentation. You will lead ICP’s manufacturing metadata strategy, including developing data lineages, data value chains, data models, relationship mapping, contextual information, and other details that allow for easier discovery, understanding, and use of ICP’s manufacturing data. As the Data Engineer, you will ensure data transformation workflows are optimized, monitored, and updated to ensure data assets are well-maintained and performant for data customers. You will collaborate with report authors and analysts within ICP’s operations to define data asset requirements and enable the successful use of data assets currently available. You have a growth mindset and are knowledgeable, entrepreneurial, self-directed, confident, and passionate about your mission to create positive change through analytics engineering. You will work closely with the Business Data Manager to influence our Corporate Data Strategy by engineering a self-service business intelligence environment that supports our data-driven culture. This is a permanent, full-time position. The primary language of work is English.

Are you an energetic individual with a Can-Do Attitude who is passionate about achieving results and driving improvement? At Irving Tissue, our culture inspires creativity, nurtures talent, and creates an inclusive workplace. Our employees can thrive and grow their careers across our diverse operating divisions.

Job Requirements
- Postsecondary education in Data Science and Analytics, Computer Science, Engineering, Software Engineering, or similar field of study
- 3-5 years of related experience
- A strong learning agility and the ability to adapt and grow
- Hands on experience with relational and non-relational databases
- Understanding of data warehouse concepts
- Ability to write complex SQL queries
- Experience in data processing with Python
- Strong oral and communication skills
- Solid stakeholder management skills
The main duties/responsibilities of this role include:
- Designing and implementing reporting solutions in various BI tools as required (Excel, Cognos, PowerBI, Jupyter Notebook, etc.)
- Querying SQL/NoSQL databases and RESTful APIs
- Engineering reusable, self-service data assets
- Develop ETL pipelines in Power BI and Microsoft Azure to support self-service business intelligence (BI)
- Optimize, monitor, and troubleshoot existing ETL pipelines and data assets to ensure they are available and accessible to business users
- Identify and communicate opportunities to improve data quality and data integrity during data ETL process
- Lead, prioritize, and execute on the development of self-service data assets solutions in support of the Reporting and Analytics strategy
- Communicating and disseminating engineered data assets to business users once developed
- Designing, developing, and communicating KPIs to business stakeholders
- Documenting and diagramming data lineages, data value chains, data models, and ETL pipelines in UML
Metadata management
- Lead ICP Manufacturing’s metadata management strategy as part of the Reporting and Analytics Strategy
- Create and update UML diagrams for data lineages, data value chains, and data models
- Create and update UML diagrams for self-serve data prep processing steps
- Create accessible metadata documentation to help business users discover and understand available self-service data assets
- Apply version control practices to track and data asset changes
- Communicate metadata changes to business users
Leadership
- Support ICP Manufacturing’s overarching self-service business intelligence (BI) initiative as part of the Reporting and Analytics strategy
- Coach and mentor data customers to improve their use of standard data assets and the self-service BI ecosystem.
- Develop processes and standards for working with ICP’s manufacturing data that others can adopt and follow
- Disrupt established reporting and analytics solutions that are not aligned with the self-service business intelligence initiative
- Facilitate hands-on training sessions to teach others

Research and Development
- Research and self-educate on emerging technologies and themes relating to Data Engineering
- Assess new technologies/approaches, and promote their use across the organization
- Research other areas of design, technology, and innovation that support ICP Manufacturing’s Reporting and Analytics strategy


What We Offer
Irving Tissue is proud to offer a competitive salary and benefits package, including but not limited to:
- A flexible medical, dental, and vision plan
- Employee & family assistance programs
- RRSP matching program
- Health & wellness reimbursements
- Product purchase program
- Opportunities to take part in job related training and development
- Growth and progression opportunities within Irving Tissue and the larger network of the J.D. Irving group of companies
- Relocation costs (if applicable)


To Apply for this Career Opportunity
Concerned you don’t meet every requirement? Research has shown that many people only apply to jobs when they feel they meet 100% of the hiring criteria. At Irving Tissue, we are focused on creating an inclusive environment where everyone feels welcome, appreciated and encouraged to contribute fully. If you are interested in this position but are concerned you may not fit the requirements perfectly, we would encourage you to still apply. You might be exactly who we’re looking for with this role or others we have available!

Please apply online at https://careers.jdirving.com/.

For further details, please contact Recruitment at icprecruitment@irvingconsumerproducts.com

We appreciate your interest in our company! Only those candidates selected for an interview will be contacted.

To learn more about our products and services, click here.

Irving Tissue is committed to the principle of equal opportunity in its employment practices and to providing an environment free from discrimination and harassment for all employees.