Cloud BI Architect: Power BI

1 day ago
toronto, on, Canada Compunnel Inc. Full-time

The Systems Architect III will be responsible for modernizing legacy BI and data platforms by leading migrations from on-premise SQL Server ecosystems to cloud-native Microsoft analytics solutions. This role focuses on Power BI development, SSRS/SSAS modernization, and building scalable data engineering pipelines using Azure and Microsoft Fabric technologies. The ideal candidate will have strong hands-on experience in BI reporting, data engineering, and large-scale migration initiatives.

Key Responsibilities:

  • Lead migration of legacy SSRS (Paginated Reports) to modern Power BI dashboards
  • Design, develop, and optimize Power BI reports using DAX and Power Query
  • Optimize report performance and enable efficient export of large datasets
  • Build and maintain ETL pipelines using Azure Data Factory and Azure Databricks
  • Query, transform, and validate data throughout the migration lifecycle
  • Implement DirectQuery, composite models, and aggregations to manage large data volumes
  • Modernize SSAS Tabular or Multidimensional models to Microsoft Fabric semantic models
  • Work with MS Fabric components including OneLake, Data Engineering, and Data Factory
  • Establish CI/CD deployment pipelines for Power BI and Fabric artifacts
  • Implement data governance practices including RLS, security, and data lineage
  • Collaborate with stakeholders to ensure successful platform modernization
  • Ensure reliability, scalability, and performance of BI and analytics solutions
Required Skills:
  • Strong experience migrating SSRS to Power BI
  • 5+ years of Business Intelligence and Data Engineering experience required
  • Hands-on experience with Azure Data Factory and Azure Databricks
  • Strong SQL skills for querying and transforming data
  • Experience managing large datasets and performance tuning
  • Knowledge of DirectQuery, composite models, and aggregations
  • Strong problem-solving and analytical skills
Preferred Skills:
  • Experience migrating SSAS models to Microsoft Fabric
  • Hands-on knowledge of Microsoft Fabric (OneLake, Direct Lake, Data Engineering)
  • Experience with CI/CD pipelines for Power BI and Fabric
  • Understanding of data governance, RLS, and data lineage
  • Familiarity with DevOps practices in BI environments
Education:

Bachelor’s Degree in Computer Science, Information Technology, Data Analytics, or related field

  • BI Architect

    1 day ago

    toronto, on, Canada GFT Technologies SE Full-time

    BI Architect Toronto, ON, CA, M5J 2M4 A major Canadian financial services organization offering a wide range of insurance, investment, and financial planning solutions is currently seeking an experienced BI Architect to support its technology initiatives. This initiative focuses on modernizing Guidewire operational reporting. The existing reports were...

  • Senior Power BI Solutions Architect

    1 day ago

    toronto, on, Canada Datavail Infotech Full-time

    Datavail Infotech is seeking a senior Power BI specialist to lead enterprise reporting modernization in Toronto. You will design, develop, and optimize Power BI reports and dashboards using PBIP, while consuming shared semantic models via Live Connections. You will collaborate with data architects, engineers, and analysts, delivering high‑quality BI...

  • Power BI Developer

    2 days ago

    Toronto, ON, Canada Agilus Consulting Group Full-time €103,000 - €117,000 Contract

    Agilus by Synergie is recruiting for a Power BI Developer in the financial services in a hybrid work environment in Toronto, Ontario. Our client is seeking an experienced Power BI Developer / BI Analytics Consultant to support enterprise reporting, data analytics, and business intelligence initiatives. The successful candidate will possess strong technical...

  • Power BI Developer

    3 days ago

    Toronto, ON, Canada Recutify Inc. Remote Full-time $70,000 - $100,000 Contract

    This Power BI Developer role at Recutify Inc. emphasizes Large-Scale Data Transformation and Statistical Processing and Business Intelligence Dashboarding and Visualization, with 0.0% of requirements covered by standard readiness verification. What Does This Power BI Developer Role Involve? Remote (open for Canada only); Long-term Contract Below are the...

  • Power BI Developer

    4 days ago

    Toronto, ON, Canada Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! Full-time $70,000 - $90,000 Contract

    Job Title: Power BI DeveloperLocation: Toronto, ONWork Model: Hybrid (2 days per week in-office preferred) Role Overview We are seeking a skilled Power BI Developer to design, develop, and maintain interactive reports and dashboards that support business decision‑making. The ideal candidate will work closely with business stakeholders, data engineers, and...

  • Enterprise Power BI Architect

    5 days ago

    Toronto, ON, Canada Virtusa Full-time

    Virtusa is seeking a seasoned Power BI Lead to design and deliver enterprise BI solutions. You will own Power BI architecture, data modeling, dashboard development, governance, and stakeholder engagement while leading a team of BI professionals. The ideal candidate has 10+ years experience with Power BI, DAX, SQL data warehousing, and data integration across...

  • Senior BI

    3 days ago

    Toronto, ON, Canada ryansg Full-time

    Ryan Specialty Canada is seeking a Senior Business Intelligence Specialist in Toronto. You will lead the design and delivery of BI reporting, dashboards, and analytics to drive strategic decisions across underwriting, operations, finance, and executive leadership. The role emphasizes data quality, governance, and automation, partnering with IT and business...

  • Power BI Senior Developer

    3 days ago

    Toronto, ON, Canada Tata Consultancy Services Full-time

    Direct message the job poster from Tata Consultancy Services Talent Acquisition Specialist @ TATA CONSULTANCY SERVICES | Bachelor of Engineering Inclusion without Exception: Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual...

  • Power BI Developer at UHN

    3 days ago

    Toronto, ON, Canada University Health Network Full-time $82,000 - $102,000 Contract

    Transform workforce data into actionable insights as a Power BI Developer with UHN. Utilize your expertise in DAX and Microsoft Fabric to create impactful dashboards for the People & Culture department. Join the University Health Network's People & Culture team as a Business Intelligence Developer focusing on Power BI. In this permanent full-time role at...

  • Power BI Developer

    5 days ago

    Toronto, ON, Toronto Census Division, ON; Ontario, Canada Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision! Full-time

    Job Title: Power BI Developer Location: Toronto, ON Work Model: Hybrid (2 days per week in-office preferred) Role Overview We are seeking a skilled Power BI Developer to design, develop, and maintain interactive reports and dashboards that support business decision‑making. The ideal candidate will work closely with

Similar jobs in toronto

Top cities