Report Engineer

The Report Engineer (BI Developer) is responsible for designing developing and maintaining highquality reporting solutions that transform raw data into meaningful insights. This role requires strong handson Power BI capabilities and intermediate experience with Azure Synapse Analytics to support modern BI and analytics workflows.

Location: Across Canada

Status: Contract Hybrid

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 RowLevel 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 handson 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 nontechnical 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

For more than 25 years Adastra Corporation has been hyper-focused on data and the infrastructures to support it. We are an international consulting company working with businesses and IT Leaders to extract value through data and analytic solutions in the domains of Cloud Data Management Analytics AI and ML Governance Hyper Automation and Enterprise Application Development. Our team of experts combined with our worldclass data management platform helps provide trusted insights establish frameworks enforce best practices and streamline processes for around-the-clock global coverage. Adastra has a proven track record of helping organizations of all sizes from SMEs to Fortune 1000s achieve their data transformation goals whether that be accelerating innovation improving operational excellence or creating unforgettable customer experiences.

What We Offer

• Opportunity for advancement and career progression
• Competitive compensation package
• Successful referral program
• 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 race color religion sex sexual orientation age national origin disability protected veteran status gender identity or any other legally protected addition accommodation will be provided during the hiring process. Adastra Corporations implementation and support of employment initiatives encourage diversified labor force participation and equal access to opportunities based on merit and performance.

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 @ or @ 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 to inquire about jobs at Adastra to report a suspicious request for money or personal information from external websites or suspicious employment offers.