Report Engineer
Red Pico
Toronto
Job Description
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.
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 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
Requirements
- 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
How to Apply
Ready to start your career as a Report Engineer at Red Pico?
- Click the "Apply Now" button below.
- Review the safety warning in the modal.
- You will be redirected to the employer's official portal to complete your application.
- Ensure your resume and cover letter are tailored to the job description using our AI tools.
Frequently Asked Questions
Who is hiring?▼
This role is with Red Pico in Toronto.
Is this a remote position?▼
This appears to be an on-site role in Toronto.
What is the hiring process?▼
After you click "Apply Now", you will be redirected to the employer's official site to submit your resume. You can typically expect to hear back within 1-2 weeks if shortlisted.
Sponsored