BI Developer

Sunwing Vacations Group; Toronto; On-site; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Great travel perks

Free parking

Open-concept workspace

Job summary

Sunwing Vacations Group is seeking a Business Intelligence Developer to join the Tour Operations BI team in Toronto. You will build Power BI dashboards, semantic models and notebooks, leveraging Snowflake and Fabric for data solutions.

You will collaborate with business units to translate requirements into practical BI solutions, develop scalable data models, and optimize ETL/ELT pipelines. The role emphasizes analytics, automation and AI-assisted development in a fast-paced travel environment.

Qualifications

• Minimum of 3 years of BI / analytics experience as described.
• Bachelor’s degree in a related discipline.

Responsibilities

• Develop and maintain Power BI dashboards, reports and semantic models.
• Build DAX calculations, Power Query transformations and data models.
• Optimize SQL queries and ensure reporting performance.
• Deliver BI solutions from design to deployment and support.
• Develop and optimize SQL queries, Snowflake objects and Fabric transformations.
• Design reporting schemas and dimensional models for data warehousing.
• Use Python and notebooks for data prep, analysis, automation and ML.
• Understand ETL/ELT workflows and dependencies across data pipelines.
• Monitor and troubleshoot data pipelines with Data Eng teams.
• Validate data quality with reconciliations and data completeness checks.
• Conduct discovery sessions to understand processes and reporting needs.
• Translate business needs into documented requirements and acceptance criteria.
• Demonstrate prototypes and collect stakeholder feedback.
• Assist teams in adopting BI/AI tools with demos and guides.
• Explain technical concepts to non-technical audiences.
• Track adoption and outcomes after implementation.
• Review AI-generated outputs for accuracy and risk.
• Develop and refine ML/DL models using Python for analytics.
• Participate in Agile ceremonies and backlog grooming.
• Break requirements into tasks with acceptance criteria and estimates.
• Balance priorities across development, discovery and production support.
• Communicate progress and risks to stakeholders.
• Maintain documentation of data lineage and governance.

Skills

Power BI development

SQL

Python

Data modeling

Agile

Stakeholder engagement

Communication

Education

Bachelor's degree in a related field

Tools

Snowflake

Microsoft Fabric

Snowflake CoCo

Microsoft Copilot

Snowpark

Streamlit

PySpark

Power BI Report Builder

Job description

The Opportunity

Under Sunwing Vacations, we are looking for a Business Intelligence Developer to join our Tour Operations Business Intelligence team and help make vacation dreams come true.

Reporting to the Business Intelligence Lead, you will deliver innovative data and analytics solutions that support business decision-making and operational efficiency. You will build Power BI reports and semantic models, develop data solutions using Snowflake and Microsoft Fabric, and leverage Python and notebooks for analysis, automation and predictive modeling.

You will work directly with business units to identify opportunities, translate requirements into practical solutions and help teams adopt new BI and AI tools. You will also leverage Snowflake CoCo and Microsoft Copilot to support development and innovation while ensuring solutions are accurate, maintainable and aligned with business needs.

What You’ll Do

• Develop and maintain Power BI dashboards, interactive reports, semantic models and paginated reports.
• Build DAX calculations, Power Query transformations and reusable data models that support accurate and consistent business metrics.
• Optimize SQL queries, reporting performance and refresh processes, and troubleshoot production issues.
• Deliver BI solutions through requirements gathering, design, development, testing, deployment and ongoing support.
• Develop and optimize SQL queries, tables, views and transformations in Snowflake and Microsoft Fabric.
• Design and maintain reporting-ready schemas and dimensional models using appropriate data warehouse principles.
• Use Python and notebooks for data preparation, analysis, validation, automation and application development.
• Understand existing ETL/ELT workflows, source-to-target mappings, scheduling and dependencies across ingestion, transformation and reporting.
• Monitor and maintain existing data pipelines, troubleshoot failures and collaborate with Data Engineering teams on structural changes and upstream issues.
• Validate data through reconciliation, completeness checks and investigation of missing, duplicated or inconsistent records.
• Conduct discovery sessions with business units to understand processes, challenges, reporting needs and improvement opportunities.
• Translate business needs into documented requirements, business rules, technical approaches and acceptance criteria.
• Present prototypes and findings, facilitate user acceptance testing and incorporate stakeholder feedback.
• Help business teams adopt BI and AI tools through demonstrations, guided pilots, workshops, user guides and hands-on support.
• Explain technical concepts, solution limitations and business benefits clearly to technical and non-technical audiences.
• Gather feedback, address adoption barriers and evaluate usage and business outcomes after implementation.
• Use Snowflake CoCo and Microsoft Copilot to support development, analysis, troubleshooting and documentation.
• Identify practical opportunities to apply AI and automation to business workflows, partnering with the Business Intelligence Lead to prototype and refine solutions.
• Review and validate AI-generated code and outputs for accuracy, maintainability and appropriate data handling.
• Develop, evaluate and refine machine learning and deep learning models using Python to support predictive analytics and business decision-making.
• Participate in Agile planning, stand-ups, backlog refinement, reviews and retrospectives.
• Break requirements into manageable tasks with clear acceptance criteria and effort estimates, keeping work items and delivery status current.
• Manage competing priorities across development, discovery and production support in alignment with the Business Intelligence Lead.
• Communicate progress, blockers, dependencies, scope changes and delivery risks proactively.
• Maintain documentation covering business definitions, transformation logic, data lineage and operational dependencies.
• Follow established access controls, change requests, data governance, version control, code review, testing and release practices.

What You’ll Need

• Minimum of 3 years of relevant professional experience in business intelligence, data analytics, BI development or a closely related field.
• Bachelor’s degree in Computer Science, Information Systems, Data Science, Business Analytics, Statistics, Mathematics, Engineering or a related discipline.
• Strong Power BI development skills, including DAX, Power Query, semantic modeling and data visualization.
• Strong SQL skills and hands-on experience with Snowflake.
• Proficiency in Python, including data manipulation, reusable functions, debugging and error handling, along with experience using libraries such as pandas.
• Practical experience developing and troubleshooting notebooks, with an understanding of execution order, dependencies and reproducibility.
• Working knowledge of Microsoft Fabric, including its data integration, notebook and analytics capabilities.
• Strong understanding of data warehouse architecture, database schemas and dimensional modeling, including star and snowflake schemas, fact and dimension tables, keys, relationships and data granularity.
• Working knowledge of ETL/ELT processes and experience monitoring, troubleshooting and maintaining existing pipelines, including scheduling, dependencies and failure recovery.
• Familiarity with incremental loading, change data capture and slowly changing dimensions.
• Familiarity with Snowflake CoCo and Microsoft Copilot, with the ability to critically evaluate and validate AI-assisted development outputs.
• Knowledge of machine learning and deep learning, including experience independently building and validating models using libraries such as scikit-learn, PyTorch or TensorFlow.
• Strong communication, presentation and stakeholder engagement skills, including the ability to conduct discovery sessions and clarify ambiguous business requirements.
• Experience working in an Agile environment with strong organizational, prioritization and time-management skills.
• A structured approach to problem-solving, data validation and documentation, with strong ownership of deliverables.
• A master’s degree in a relevant field is considered an asset.
• Experience delivering business solutions using Snowflake CoCo or Microsoft Copilot is considered an asset.
• Experience with Snowpark, Streamlit, PySpark or Python-based analytics applications is considered an asset.
• Experience with Microsoft Fabric lakehouses and warehouses is considered an asset.
• Experience with Power BI Report Builder, paginated reports, Power BI Service, gateways and row-level security is considered an asset.
• Experience with Git, Azure DevOps, REST APIs, PowerShell or Power Automate is considered an asset.
• Experience delivering user training or supporting the adoption of new BI and AI technologies is considered an asset.
• Knowledge of airline, travel, reservations, sales, revenue or contact-centre operations is considered an asset.

What We Offer

• Grow your career with challenging and rewarding work that makes a difference.
• Opportunity to give back through our social responsibility initiatives.
• Work with a fun, passionate, travel-loving team!
• Great travel perks!
• Free parking.
• Open-concept, collaborative workspace.
• See for yourself! @sunwinglife