Build and modernize enterprise reporting solutions using Databricks and Power BI. Responsibilities include developing governed datasets, Delta-table reporting views, semantic models, dashboards, automated report distribution, and data validation processes. The role collaborates with business stakeholders, supports testing and deployments, and optimizes reporting performance. Required expertise includes advanced SQL, data warehousing, ETL/ELT, Databricks, Power BI, DAX, Power Query, and Azure services.
Overview
We are looking for a hands-on Senior Analytics Engineer to help build and modernise enterprise reporting solutions on Data-bricks and Power BI.
The role will support the development of governed reporting datasets, interactive Power BI dashboards, and automated reporting solutions for business users. The ideal candidate should be comfortable working across data engineering, reporting, and analytics layers.
Responsibilities
• Design and build reporting datasets in Databricks using SQL and Delta tables.
• Create reusable reporting views and data models for business consumption.
• Develop Power BI dashboards, semantic models, and self-service reporting solutions.
• Implement automated report generation and distribution solutions.
• Work with business analysts and stakeholders to translate reporting requirements into technical solutions.
• Support data reconciliation, testing, and production deployment activities.
• Optimize reporting performance and data access patterns.
Required Skills
Data-bricks
• Data-bricks SQL*
• Unity Catalogue
• SQL Warehouses
• Delta Tables
• Data modelling
Power BI/Data-bricks Dashboard
• Power BI Desktop*
• Semantic Models
• DAX
• Power Query
• Dashboard development (Power BI & Data-brick)
Data Engineering
• Advanced SQL
• Data Warehousing concepts
• ETL / ELT development
• Data validation and reconciliation
Nice to Have
• Python / PySpark
• Power BI APIs
• Paginated Reports
• Report scheduling and distribution
• Financial services or investment management experience
• Data-bricks reporting architecture experience
Azure
• Azure Data Factory (ADF)
• Azure Storage
• Service Principals and security concepts
Kumaran Systems Toronto, Ontario, CAN Office
703 Evans Avenue, Suite 605 , Toronto, ON , Canada, M9C 5E9
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Designs and maintains reliable data pipelines and computed tables using SparkSQL and PySpark. Integrates IoT, product, customer, external, unstructured, and ML-related data into scalable data models supporting analytics, causal inference, model training, and dashboards. The role requires ETL development, data orchestration, API integration, strong data quality and uptime, and collaboration with Data Science, AI/ML, Analytics, and engineering teams. This is a remote position for candidates residing in Canada.
Top Skills:
AirflowSparkAWSAzureDagsterDatabricksDelta LakeGCPGitGitPrefectPysparkPythonRest ApisSparksqlSQL
Aerospace • Hardware • Robotics • Software
Build a high-performance frontend data platform for exploring and analyzing hardware telemetry. Develop React and TypeScript applications, interactive time-series visualizations, data visualization plugins, complex application state management, and LLM-assisted analysis workflows. Collaborate directly with hardware engineers and customers to define interfaces, prototype workflows, demonstrate features, and incorporate feedback into product development.
Top Skills:
LlmsReactTypescript
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect and own marketing data infrastructure, including Databricks pipelines, Gold Layer tables, semantic models, and trusted analytics foundations. Lead cross-functional data initiatives, translate ambiguous business needs into scalable solutions, improve reliability and quality, and mentor engineers. Build and monitor production LLM and agent systems, automate workflows with AI, and deliver high-quality Python and SQL while validating AI-generated code. Partner with Marketing, Sales, BI, Data Science, and R&D teams.
Top Skills:
Ai AgentsBigQueryClaude CodeCursorData WarehousesDatabricksDbtEtl/EltLakehousesLlmsMarketing AutomationMartechPythonSalesforceSemantic LayersSnowflakeSQLStreamlitWeb Analytics
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.
