← Back to jobs

Avanciers Logo
Power BI Developer

Avanciers

 

Toronto, ON, Canada

Posted On: 30+ days ago
Experience: 8+ years
Availability: Onsite
Openings: 1
Category: Power BI Developer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Job Description

This is a contract role focused on delivering end‑to‑end reporting and analytics solutions. The successful candidate will be highly hands‑on, with strong coding and visualization skills, and will work closely with business stakeholders to translate business questions into clear metrics, dashboards, and reporting solutions.

The role combines technical execution with business analysis responsibilities, owning the full lifecycle from requirements gathering through build, validation, iteration, and handoff. This is a delivery‑oriented role with defined timelines and clear outcomes.

Job Description (Key Responsibilities):

  • Design, build, and maintain end‑to‑end reporting solutions, including data extraction, transformation, modeling, and visualization.

 

  • Own report/dashboard development lifecycle: requirements → build → validation → iteration → handoff/support.

 

  • Translate loosely defined business questions into clear metrics, KPIs, and reporting logic.

 

  • Collaborate with business stakeholders to align definitions, assumptions, and interpretations of externally sourced data.

 

  • Clearly explain data limitations, transformations, and lineage to non‑technical stakeholders to build trust in reporting outputs.

 

  • Act as a bridge between business and technical teams, ensuring solutions are usable, trusted, and actionable.

 

  • Proactively challenge requirements and propose simpler or more scalable reporting approaches.

 

  • Build high‑quality dashboards and reports using tools such as Power BI, Tableau, or similar platforms.

 

  • Apply best practices in data modeling, dashboard design, and performance optimization.

 

  • Enable business users to confidently self‑serve insights through well‑designed and well‑documented reports.

 

  • Understanding source system structures, field definitions, and delivery formats.

 

  • Perform data mapping between external data sources and internal data models, ensuring consistency and correctness of metrics.
  • Define and document data lineage, including source‑to‑target mappings, transformations, and calculation logic used in reporting.

 

  • Validate external data against business expectations and internal reference data, identifying gaps, anomalies, and quality issues.

 

  • Partner with internal data engineering, platform, and business teams to resolve data discrepancies and clarify ownership and definitions.

 

  • Produce clear documentation to support auditability, explainability, and ongoing maintenance of reporting solutions.

 

Job Requirements:

  • 3+ years of hands‑on experience with:
    • SQL (complex queries, joins, window functions, performance optimization)
    • Python (Pandas, NumPy) for data transformation, analysis, and reporting workflows
    • PySpark or distributed data processing frameworks
  • 3+ years of experience building dashboards and reports using Power BI, Tableau, or similar BI tools, including:
    • Data modeling
    • Calculated measures (e.g., DAX or equivalent)
    • Dashboard performance optimization
  • Strong experience working directly with business stakeholders to define requirements and deliver reporting solutions.

Preferred/Nice to Have

  • Experience working with Databricks or similar analytics platforms.
  • Experience with merchant solutions, financial services or financial institution data.
  • Background in analytics engineering or reporting‑focused analytics roles.
  • Undergraduate degree in a quantitative field (e.g., computer science, engineering, math, physics, finance); graduate degree is an asset but not required

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs