Develops ETL pipelines, semantic data models, and Power BI reports using Azure and Microsoft Fabric. Transforms raw data through Bronze, Silver, and Gold layers; builds scalable ingestion and orchestration workflows; designs Direct Lake models, operational reports, and dashboards; writes optimized PySpark and SQL; troubleshoots data applications; and supports OLAP, data governance, security, and lineage requirements.
Responsibilities:
- Analyze
data and design semantic models
- Transform
raw data into silver/gold data for reporting consumption.
- Design,
develop, and release deploy Power BI reports and dashboards meeting KPIs
including accuracy, reliability and performance.
- Review
business requirements (and related materials) to use as input for
design/development of reports
- Design
technical systems specifications to translate into working, tested
applications. This includes developing detailed programming
specifications, writing and/or generating code, compiling data-driven
programs, maintaining, and conducting unit tests.
- Resolves
and troubleshoots technical problems which arise during the use and
operation of software packages, including technical assistance in
implementation, conversion and migrations.
- Provide
specialized skills for developing data access queries
- Works
in conjunction with data analysts for developing dashboards and other end
user reporting products
- Supports
Client’s wide-ranging business information requirements, implementing and
supporting OLAP analytical software solutions
- Develops
and supports customized query applications which analyze key business data
Requirements
Experience and Skill Set Requirements:
Must Haves:
- 6+
years experience as Azure technologies including
- Azure
Databricks
- Azure
DataLake Gen 2.
- Power
BI development and semantic modeling
- Azure
DevOps CI/CD
- PySpark
- Microsoft
Fabric
- Star
Schema or Snowflake data modeling experience
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- Business
Intelligence:
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
- Use
of semantic models to design and develop Power BI reports and dashboards.
Develop operational and analytical PowerBI reports/paginated reports.
Skill Set Requirements:
Mandatory Skills and Experience:
- 6+
years experience as Azure technologies including
- Azure
Databricks
- Azure
DataLake Gen 2.
- Power
BI development and semantic modeling
- Azure
DevOps CI/CD
- PySpark
- Microsoft
Fabric
- Star
Schema or Snowflake data modeling experience
- Orchestration
& Ingestion:
- Proficiency
using Data Factory within Fabric to build complex, scalable data
pipelines.
- Business
Intelligence:
- Designing
efficient Direct Lake semantic models in Power BI using Silver/Gold layer
models to ensure high-speed reporting directly from OneLake.
- Use
of semantic models to design and develop Power BI reports and dashboards.
Develop operational and analytical PowerBI reports/paginated reports.
Desirable Skills and Experience:
- Experience
in Azure Data Factory (ADF) v2
- Data
Architecture & Engineering: Competency in building Lakehouses and Warehouses, writing optimized PySpark or SQL pipelines,
and implementing Medallion architecture (Bronze/Silver/Gold layers).
- Data
Governance: Data security (row-level/column-level), and data lineage
tracking.
Similar Jobs
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Own end-to-end analytics engineering for AI and developer experience data. Instrument telemetry, build governed production pipelines, define trusted metrics, and create executive-facing dashboards and analyses. Partner with data engineering, AI, and data science teams to improve data quality and connect raw signals to decision-making. Present clear recommendations on AI investment, developer productivity, and ROI while using AI coding agents to build and maintain pipelines, dashboards, and analyses.
Top Skills:
Ai Coding AgentsCi/CdGitLlm-Based Classification ToolingMetrics StorePythonReactSnowflakeSQLTypescript
2 Hours Ago
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Graduate research interns will own end-to-end projects to build customer world models and proactive intelligence: developing representation learning, foundation model, RL/agentic methods, evaluation frameworks, and shipping research into production to improve customer decision-making.
Top Skills:
Deep LearningFoundation ModelsJaxOptimizationPythonPyTorchRepresentation Learning
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Build and deploy agentic and generative AI systems that automate risk and compliance investigations. Own full-stack ML systems, including data integrations, prompt tuning, orchestration, evaluation, productionization, monitoring, and transformer-based modeling across transaction, graph, text, and profile data. Collaborate with product, engineering, platform, and operations teams while leading strategic roadmaps and delivering scalable production systems.
Top Skills:
Agentic AiAmazon Web Services (Aws)Apache AirflowGenerative AiGoogle Cloud Platform (Gcp)Large Language Models (Llms)Natural Language Processing (Nlp)PythonPyTorchSnowflakeTransformer Models
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
