At Kinaxis, who we are is grounded in our common belief that people matter. Each one of us plays an important part in accomplishing our work, building our culture and making a global impact.
Every day, we’re empowered to work together to help our customers make fast, confident planning decisions. This is how we create a better planet – for each other, for our customers and for generations to come. Our cloud-based platform RapidResponse ensures that the products we need – everything from medicine and cars, to day-to-day items like toothpaste – make it to market and into our hands when we need them with minimal ecological footprint.
We make the world better, and you can too.
Manager, Data Engineering
Job location: This is a remote/hybrid position. You can work from home and be located anywhere in Canada. If you are located in Ottawa, you will be expected to work in a hybrid model with a minimum of working in the office 3 days a week.
About the role
Reporting to the Senior Director, Data & Analytics, the Manager, Data Engineering, as a fully proficient and seasoned professional, will provide technical leadership to our data engineering practice, ensuring cross team integration and proper hand-offs of code/tasks to meet schedules. The Manager, Data Engineering, will lead work that contributes to the design, implementation and maintenance of data flow channels and data processing systems that support the collection, storage, batch and real-time processing, and analysis of information from structured and unstructured sources in a scalable, repeatable and secure manner.
Additionally, the Manager, Data Engineering will implement data management standards and practices, research and evaluate Data Engineering tools and frameworks.
What you will do
- Lead and develop a team of ETL developers, providing technical guidance and coaching and managing end-to-end delivery and work assignments
- Partner with stakeholders across the business to understand needs for data structure, availability, scalability and accessibility; understand the needs of the business and translate those into technical system requirements
- Perform hands-on ETL solution design, development, test execution and production deployment.
- Proactively identify opportunities for improvements and optimization, and make recommendations to senior leaders
- Build data flow channels and processing systems to extract, transform, load and integrate data from various sources.
- Identify data quality problems and provide recommendations and solutions for how they will be handled
- Develop, manage and maintain data dictionaries, metadata, and process flow documentation.
- Maintain and manage revisions of code in production, testing and development environments.
- Coordinate as required with vendors, contractor resources, and other external parties on development projects from requirements through delivery.
- Work with data analysts, BI analysts and other analytics stakeholders to implement data models to support analytics use cases.
- Make BI and data science code production ready to ensure it is maintainable, scalable and de-buggable. Deploy machine learning models to production and build the framework to monitor the performance of the model.
- Partner with team members across Corporate IT and the business to ensure the accurate integration of data systems into existing infrastructure.
- Test data system configurations to increase efficiency, and consistently monitor performance
- Support the handling and logging of errors, including analysis and classification of issues; anticipate and mitigate risks and opportunities for optimization
- Develop processes to improve data flows between internal/external systems and the data warehouse.
- Contribute to defining data governance and data privacy initiatives and policies
- Administer, design, develop, validate, deploy and maintain ETL tool, Informatica
What we are looking for
- Bachelor’s Degree in Computer Science, related field, or relevant experience
- Minimum 5 years of ETL design and development experience in a high-tech, global organization
- Minimum 5 years of experience leading, coaching, and developing a team of ETL developers, including experience planning, and managing end-to-end delivery and work assignments within an ETL development team
- Experience with Data repository design (e.g. operational data stores, dimensional data stores, data marts)
- Experience in data modelling for analytics (e.g. star schemas, snowflake schemas).
- Highly influential; proven ability to engage and interact with stakeholders across the business, including technical audiences, for requirement analysis and discussions
- Strong experience in PL/SQL in Oracle, MS SQL and Informatica ETL.
- Demonstrated experience executing IT projects with high level of expertise in system application and technology implementation delivery.
- An articulate communicator with the ability to provide clear, concise messaging to multiple audiences. Ability to present information in a way that engages the listener at the appropriate level.
- Advanced analytical, problem solving, and critical thinking skills with the ability to coordinate input from multiple sources to develop impactful recommendations to achieve results for the business.
- Strong at building relationships; detail-oriented and able to manage multiple priorities based on the needs of the business
- Experienced in Informatica and Snowflake is an asset
- An understanding of data governance, data privacy, data acquisition and data management is an asset
What we have to offer
-
Challenging Work - We love solving highly complex problems. And as the global leaders in our industry, we never stop innovating—our work is never “done. That’s because across our teams and in all roles, every employee is empowered to bring their best ideas forward and to jump in and solve the problems they’re passionate about.
-
Great People - We take our work seriously, but we don’t take ourselves too seriously! It’s in our DNA to celebrate, laugh, and have fun. We are stronger, together, when we are open, honest, and above all, real. Every person is valued here and plays an important role in our shared success.
-
Global Impact - As a global team spanning continents, boundaries, and cultures, every day we are inspired by the impact our work has on our colleagues, our customers, our communities, and the world at large.
-
Diversity, Equity and Inclusion - Diversity, equity and inclusion are more than words to us. They are the guiding principles for building a culture where we celebrate each others’ differences, continuously strive for equality and recognize that inclusion makes us stronger as individuals, a company and a global citizen.
For more information, visit the Kinaxis web site at www.kinaxis.com or the company’s blog at http://blog.kinaxis.com/.
Kinaxis strongly encourages diverse candidates to apply to our welcoming community. We strive to make our website and application process accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at recruitmentprograms@kinaxis.com. This contact information is for accessibility requests only and cannot be used to inquire about the status of applications.
