BI Developer

About Us: Sunwing Vacations Group is home to North America’s largest vacation brands, comprised of the leading Canadian leisure tour operators Sunwing Vacations and WestJet Vacations, along with the growing United States based tour operator Vacation Express, together with the Group’s own travel retail businesses SellOffVacations.com and Luxe Destination Weddings. Our culture is driven by our EPIC Values (entrepreneurial, passionate, innovative, and customer-centric) and our teams work together to deliver our purpose “passionate people making vacation dreams come true”. 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.
Apply now and have your career soar to new heights - under our wing! 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 We thank all who apply however only those who meet the qualifications will be contacted. Diversity, equity, and inclusion - Diversity makes us EPIC; we strive to foster a culture where employees feel uniquely themselves and part of a team. Violence and harassment prevention and response - We partnered with White Ribbon to help us create a survivor-centric, trauma informed policy and educational programs used by all our divisions. Total wellbeing - Our approach is for holistic opportunities to help employees Be EPIC and Be Well. Learning and development - Our offerings are focused on the development of competencies, personal leadership, and leadership in groups and teams. We are also committed to employment equity and to fostering an inclusive, accessible environment. We welcome applications from everyone. We will accommodate all applicants throughout the hiring process. If you are an individual who requires accommodation to apply to this position, please email [email protected]