BI Advanced Analyst

Bell Canada; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a BI Developer to enhance decision-making through innovative technologies. In this dynamic role, you will work collaboratively with various teams to execute end-to-end campaigns, improve reporting ecosystems, and automate processes. Your analytical skills will be put to the test as you analyze data sources and identify gaps, all while mentoring junior members. This is a fantastic opportunity to grow your leadership abilities in a supportive and inclusive environment where your contributions will have a meaningful impact on business outcomes. Join a team that values diversity and fosters a culture of continuous improvement.

Benefits

Medical benefits

Dental benefits

Vision benefits

Mental health benefits

35% discount on services

Flexible work hours

Qualifications

• 3+ years of experience in ETL development and SQL.
• Experience with SAS programming and data warehousing concepts.

Responsibilities

• Collaborate with teams to develop and execute marketing campaigns.
• Analyze data to identify reporting opportunities and improve processes.

Skills

ETL development

SQL

SAS programming

Data analysis

Project management

Data mining

Problem-solving

Customer-centric approach

Education

Bachelor’s degree in Mathematics

Bachelor’s degree in Statistics

Bachelor’s degree in Engineering

Bachelor’s degree in Business Analytics

Bachelor’s degree in Information Technology

Bachelor’s degree in Computer Science

Tools

SAS Data Integration Studio

Teradata

SQL Server

Excel

MicroStrategy

Jira

Confluence

Job description

At Bell, our purpose is to advance how Canadians connect with each other and the world. We achieve this by providing consumers and businesses with the best network technologies in the world, innovative digital solutions and seamless customer experiences. It’s all developed and delivered by the members of #TeamBell and we’re always on the lookout for people with great skills and experiences.

We value diversity and provide a supportive, inclusive community where all team members can succeed. And through our commitment to environmental, social and governance initiatives, you will feel good about the greater impact you will have – making every day better for people as they connect, work, learn and play.

Join us. You belong at Bell.

Bell is currently looking for a BI Developer, experienced in decision-making and can support the team in reporting execution and management. The successful candidate will have the opportunity to hone their leadership skills and support important business decision-making by working with new, cutting-edge decision-making technologies.

Key Responsibilities

• Work in collaboration with Customer Analytics, Products, Pricing, Marketing Communications and IT channels to develop and execute end-to-end campaigns.
• Actively contribute to the marketing planning cycle especially on loyalty campaigns.
• Define and deliver business requirements by leading working sessions.
• Evolve the reporting ecosystem to enable best-in-class marketing tactics.
• Increase ability of Reporting team to deliver more, faster, better.
• Automate and improve recurring processes.
• Analyze the best data sources and the design and logic of queries.
• Data analysis - analyzing data to provide information on reporting opportunities.
• Data mining - extracting data and identifying errors or gaps in data sources.
• Define overall testing strategies and provide support at all levels of testing and defect resolution.
• Manage multiple concurrent projects and priorities.
• Manage incoming data development or investigation requests and engage stakeholders to understand the underlying problem, base assumptions and desired outcomes.

Additional Requirements

• Proactive Problem-Solving: Identifies critical needs and takes decisive action to address them effectively and efficiently.
• Innovation and Continuous Improvement: Actively seeks and implements new ideas and innovative solutions, proactively exploring new areas and opportunities for growth.
• Customer-Centric Approach: Demonstrates a deep understanding of customer needs, anticipating and exceeding expectations to drive customer satisfaction.
• Analytical and Solution-Oriented: Masterfully applies systematic problem-solving methodologies to complex challenges, consistently delivering effective solutions.
• Learning Agility and Continuous Development: Proactively investigates mistakes, fosters a culture of learning from experience, and actively seeks opportunities to expand skills and responsibilities.
• Mentorship and Collaboration: Mentors and guides junior team members, fostering a collaborative environment of knowledge sharing and mutual support.

Critical Qualifications

• 3+ years hands-on experience with ETL development and design techniques.
• Advanced knowledge of SQL is required (3+ years experience).
• Experience with SAS programming language and SAS Data Integration Studio.
• Experience with Teradata and SQL Server.
• Bachelor’s degree in Mathematics, Statistics, Engineering, Business Analytics, Information Technology, Computer Science and/or related fields or equivalent experience.
• Experience in gathering and analyzing system requirements.
• Knowledge of Data Marts, Data Warehousing and Business Intelligence concepts.
• Emphasis on development of high quality code focused on efficiency and the elimination of data integrity or quality issues.
• Demonstrated ability to effectively manage multiple projects and competing priorities simultaneously and to work independently and as part of an extended team.
• Experience with Excel (tables and pivot tables).
• Working knowledge of SAS Enterprise Guide.
• Experience in direct and targeted marketing, including campaign list creation, and understanding of processes related to excluded numbers, the Canadian Anti-Spam Act (CASA) and contact strategy.
• Experience in technology companies and/or telecom networks is a strong asset.
• Experience developing cubes, complex reports and dashboards using MicroStrategy.
• Experience with Oracle, Teradata, ETL tools.
• Experience with Jira, Confluence.
• Experience with data modeling.
• Knowledge of telecommunication sector.
• Proven project management and change management skills.

Adequate knowledge of French is required for positions in Quebec.

Additional Information:

For work arrangements that are ‘Hybrid’, successful candidates must be based in Canada and report to a set Bell office for a minimum of 3 days a week. Recognizing the importance of work-life balance, Bell offers flexibility in work hours based on the business needs.

Please apply directly online to be considered for this role. Applications through email will not be accepted.

We know that caring for our team members is at the heart of a healthy, positive and thriving workplace. As part of our team, you’ll enjoy a comprehensive compensation package that includes a competitive salary and a wide range of benefits to support the well-being of you and your family. As soon as you join us, you'll be eligible for medical, dental, vision and mental health benefits that you can tailor to your specific needs. Plus, as a Bell team member, you'll enjoy a 35% discount on our services and access exclusive offers from our partners.

We value the experiences that have shaped who you are, and we know the diversity of your talent will bring even greater strength to our team. At Bell, everyone belongs and you’ll feel valued, respected and supported as you grow and reach your full potential.

We also want to make sure that everyone has an equal opportunity to join our team. We encourage individuals who may require accommodations during the hiring process to let us know. For a confidential inquiry, email your recruiter or [e-mail] to make arrangements. If you have questions or feedback regarding accessibility at Bell, we invite you to complete the Accessibility feedback form or visit our Accessibility page for other ways to contact us.

Artificial intelligence may be used to assess parts of your application. Please review our privacy policy to learn more about how we collect, use, and disclose your personal information.