Are you passionate about turning data into meaningful insights and building impactful dashboards? The Report Engineer (BI Developer) is responsible for designing, developing, and maintaining high-quality reporting solutions that transform raw data into meaningful insights. This role requires strong hands-on Power BI capabilities and intermediate experience with Azure Synapse Analytics to support modern BI and analytics workflows.

Primary Location: Across Canada

Work Model: Hybrid 1-Day Onsite

Employment Type: Contractor

Vacancy Status: Backfill

RESPONSIBILITIES

• Collaborate with business stakeholders to gather and document reporting requirements
• Design, build, and optimize Power BI dashboards, datasets, and paginated reports
• Develop data models using best practices aligned with performance and usability standards
• Use Azure Synapse Analytics (SQL pools, pipelines) to support data ingestion, transformation, and analysis
• Write and optimize SQL queries and transformations for reporting purposes
• Ensure data accuracy, consistency, and quality across all BI deliverables
• Implement Row‑Level Security (RLS) and follow governance standards for data access
• Troubleshoot report issues and provide enhancements to existing BI solutions
• Document data flows, logic, models, and dashboards for internal and external stakeholders

QUALIFICATIONS, SKILLS & EXPERIENCE

• Strong hands‑on experience developing Power BI dashboards, datasets, and DAX calculations
• Capital Markets experience is required
• Proficiency in Power Query (M), data modeling, and report performance optimization
• Intermediate-level experience with Azure Synapse Analytics (SQL pools, pipelines, transformations)
• Strong SQL skills and familiarity with data warehousing concepts (ETL/ELT, dimensional modeling)
• Experience pulling data from multiple sources (databases, APIs, cloud storage, files, etc.)
• Strong analytical, problem-solving, and communication skills
• Ability to work independently and collaborate effectively with technical and non‑technical teams

NICE TO HAVE

• Experience with Azure Data Factory or Databricks
• Exposure to CI/CD pipelines for BI assets (Git, DevOps)
• Familiarity with other BI tools (Tableau, Looker, MicroStrategy)
• Azure or Power BI certifications
• Experience with enterprise data governance and security best practices

ABOUT ADASTRA

Adastra is a global leader in AI and data-driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.

Trusted by some of the world’s most prominent brands, Adastra delivers end-to-end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future-ready capabilities and delivering measurable, lasting impact.

Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Competitive compensation
• Successful referral program
• The opportunity to work with one of Canada’s 50 Best Managed Companies
• Satisfaction of working for a reputable company 
• A flexible, dynamic, and diverse workplace

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.  In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.

AI Usage - Our hiring process includes the use of AI-enabled tools to screen applications (e.g., keyword matching, qualification ranking). A human recruiter reviews all AI-generated shortlists to make informed hiring decisions.

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from ‘@adastragrp.com’ or ‘@talent.icims.com’ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign, it is fraudulent.

Contact careers@adastragrp.com to inquire about jobs at Adastra, to report a suspicious request for money or personal information from external websites or suspicious employment offers.