BI Developer

Position: BI Developer

Reports to: Director, Enterprise Data Management and Analytics

Bring your creativity and fresh thinking to an iconic brand owned by Onex ($31B assets) that has been trusted for its high quality and innovation since 1952. For over 65 years, Walter Surface Technologies has been a world leader in surface treatment technologies providing high performance abrasives, tools, power tools, chemical solutions and welding process solutions specifically designed for the metalworking industry. Our core philosophy is focused on helping customers work better and provide "only the best" - the best technology, the best products, the best performance, the best safety, and the best durability - all designed to increase their productivity and profitability.

Responsibilities

• Lead and supervise development and testing teams (2-4)
• Analyze business needs and plan the required team effort and timeline accordingly.
• Quality control: Act as the last validation stage before releasing in Prod
• Build data flows, data mapping around Oracle Db and other data sources
• Build ETLs from multiple data sources into the data infrastructure
• support the team to create documentation on key business rules and ETL process applied to data
• Optimize current data models to achieve better performance on reports, cube, dashboards
• Designing, developing, and deploying multidimensional model to support reports, cube, dashboard solutions.
• Maintaining & enhancing existing data models: financial, sales, operational, suggesting improvements or creation of new data models to meet business needs.
• Implementation of dashboard capabilities with near real time capability and performance
• Delivering BI & data training to various internal clients

Required aptitude

• Ability to synthetize complex concept and explain to non-technical users
• Delivering technical training to various internal clients
• Ability to prioritize the team effort and reallocate resources to meet operational needs
• Capacity to bring innovative solutions to solve legacy issues

Required skills

• Expertise in data engineering tools & methodologies such as Data Factory, Alteryx or Informatica
• Expertise in SQL: Oracle PL SQL, MS SQL and with OLAP & OLTP
• Strong knowledge of ERP transactions and modules for distribution and manufacturing business.
• Advanced knowledge of BI, data engineering & data warehousing.
• Expertise in data governance, information quality, business intelligence & data management with several departments covered (Finance, Sales & Marketing, supply chain)

Experience & Education

• Bachelor’s degree in computer science, Data Science or equivalent experience.
• Minimum 3+ years of experience in a similar role
• Bilingual in French & English both verbal & written
• AWS (Amazon) or Azure (Microsoft) or Google Cloud knowledge is a plus
• IBM certification (Cognos Analyst, Dev, Admin) is a plus

Job Type: Full-time

Benefits:

• Casual dress
• Company events
• Dental care
• Disability insurance
• Employee assistance program
• Extended health care
• Life insurance
• On-site gym
• On-site parking
• Paid time off
• RRSP match
• Tuition reimbursement
• Vision care
• Work from home

Work Location: Hybrid remote in Pointe-Claire, QC