Developer, Business Intelligence

Apply Now

Company: Pet Valu

Location: Markham, ON L3P 8P3

Description:

Location: Markham, Ontario

Job Description:

Job Overview

  • A developer who thrives in a dynamic work environment. This role involves working across the entire BI lifecycle, from source data analysis, Extract Transform Load (ETL) development, through to Analysis and Reporting implementation. This role will involve in the build out of Data Lakes needed to enable data discovery, predictive analytics and other features. This role will design, develop, and implement data structures that support solutions which empower the business with timely, actionable information. The Developer, Business Intelligence, needs to be a self-starter and thorough in their work.


  • Business Analysis capabilities to be able to communicate to end user populations for both requirements gathering for small projects and directing them in User Acceptance Testing


Essential Duties

ETL Development & Data Integration

  • Design, develop, and optimize ETL pipelines using Talend.


  • Ensure efficient data movement and transformation across systems.


  • Implement CI/CD best practices for automated deployment and version control.


  • Utilize GitHub (or other source control tools) for managing code, versioning, and collaboration.


Snowflake Development

  • Develop and optimize stored procedures, tables, views, and tasks within Snowflake.


  • Implement data governance, security policies, and performance tuning for Snowflake workloads.


  • Work with large datasets and optimize queries for efficient performance.


Business Intelligence & Reporting

  • Build interactive dashboards and reports using Power BI and Tableau to support business insights.


  • Collaborate with stakeholders to gather reporting requirements and translate them into technical solutions.


  • Optimize and maintain existing reports to enhance performance and usability.


Data Modeling & Architecture

  • Design and maintain data models to support analytics and self-service reporting.


  • Ensure data integrity, consistency, and scalability across BI solutions.


  • Align data architecture with business needs and best practices.


Agile Development & CI/CD

  • Work within an Agile framework using JIRA to manage tasks, track progress, and collaborate with stakeholders.


  • Implement CI/CD pipelines for automated testing, deployment, and version control of ETL and BI solutions.


  • Participate in sprint planning, retrospectives, and continuous improvement initiatives.


Collaboration & Documentation

  • Maintain technical documentation for ETL processes, data models, and reporting solutions.


  • Work closely with, analysts, and business users to understand data needs.


  • Participate in code reviews and best practice discussions to enhance team efficiency.


Experience, Education, Certifications (List minimum required to enter the role.)

  • 5+ years of experience in Business Intelligence and ETL development using Talend.


  • Minimum 3 years of hands-on experience with Snowflake, including writing stored procedures, managing tasks, and performance optimization.


  • Minimum 3 years of experience with Power BI and Tableau for dashboard and report development.


  • Strong SQL skills, including performance tuning and query optimization.


  • Hands-on experience with JIRA for Agile project management.


  • Experience working with CI/CD pipelines for ETL and BI solutions.


  • Experience with GitHub or other source control tools for version control and collaboration.


  • Ability to work independently and take full ownership of the BI footprint with minimal supervision.


  • Knowledge of data warehousing concepts, data modelling, and best practices.


Competencies

  • Analytical Thinking and Problem-Solving Skills - ability to understand complex situations, develop and implement a logical approach to a problem solution.


  • Communication -ability to understand requirements documentation, functional specifications, high level design documentation and system documentation. Able to successfully listen, understand and verbally communicate with technical and non-technical team members.


  • Attention to Detail - ability to ensure the work and information are complete and accurate, by preparing carefully for meetings and presentations, and following up with others to ensure that agreements and commitments have been fulfilled.


  • Flexibility - able to change priorities quickly and have a capacity to handle multiple tasks simultaneously.


  • Application of software engineering concepts and best practices to design solutions that meet operational requirements, such as scalability, maintainability, extensibility, and flexibility.


  • Ability to self-manage projects and to assist in management of others, due dates and communicate status.


  • Impact Awareness - ability to anticipate the likely effect of actions and events on others and to tailor one's own behavior to achieve a desired effect on others.


  • Influential Skill - ability to gain others' support for ideas and solutions, through logical argument.


  • Interpersonal Awareness - ability to notice, interpret, and anticipate others' concerns and feelings.


  • Productivity - motivated self-starter and quick learner. Ability to work under deadlines with heavy workloads as well as flexibility to work outside of normal business hours to meet testing needs.


  • Results Oriented - ability to keep the desired end-result of one's own work clearly in mind, by setting goals and focusing on them tenaciously until they are achieved.


  • Technical Acumen - strong understanding of software development concepts, procedures, and technologies utilizing Agile Methodology.


Technical Skills

  • Proficiency with multiple ETL tools (including Talend, AIS, SSIS) and BI platforms (Snowflake, MS Fabric, ... etc).


  • Experience with industry development standards and their implementation


  • Proficiency in system analysis and design


  • Analysis and verification technical requirements for completeness, consistency, feasibility, and testability.


  • Identification and Resolution of technical issues through unit testing, debugging & investigation


  • Design and develop appropriate processes and procedures to ensure proactive data quality monitoring


  • Version Control including branching and merging (Visual Studio DevOps preferred)


  • Experience with Reporting tools (Tableau, Power BI etc. preferred)


  • Experience with Retail systems including point-of-sales, warehousing / distribution, and merchandising systems

Similar Jobs