Developer, Business Intelligence - #187576
Pet Valu
Date: 3 weeks ago
City: Markham, ON
Contract type: Full time
Location: Markham, Ontario
Job Description
Job Overview
ETL Development & Data Integration
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
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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
How to apply
To apply for this job you need to authorize on our website. If you don't have an account yet, please register.
Post a resumeSimilar jobs
VP Talent Management, Culture and Learning
Aviva Canada,
Markham, ON
2 weeks ago
Individually we are people, but together we are Aviva. Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence. The Vice President, Talent Management and Organizational Effectiveness will be responsible for driving talent development and talent management practices within the organization including Organizational Culture initiatives and DEI programs. They will also have the...
People & Culture Manager, Systems and Support
Kinark Child and Family Services,
Markham, ON
2 weeks ago
Job Description Kinark has introduced a benefit that gives employees in eligible roles the opportunity to work partially or fully remote if they choose to opt-in for this benefit. This role (P&C Manager, Systems & Support) is assessed as a Remote position requiring minimal days in the office (0-1 days per week) unless business demands require. This role is also...
Secondary Long Term Occasional (LTO)100% Grade 10 Special Education -Learning Strategies, Resourcing and Grade 9 Geography
York Region District School Board,
Markham, ON
3 weeks ago
At the York Region District School Board, we can offer you a challenging and rewarding career in public education. We support our teachers in their commitment to ensuring student success. We recognize the key difference that teachers make in the lives of our learners. To be considered for this opportunity, please complete the following on-line application to the attention of:...
