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
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Design, develop, and optimize enterprise data pipelines and ETL/ELT integrations using Informatica IDMC. Build transformation workflows, integrate multiple data sources into cloud and enterprise environments, troubleshoot performance and data quality issues, and implement testing and monitoring. Collaborate with architects, analysts, engineers, and business stakeholders to deliver scalable data solutions, primarily for financial services clients.
Top Skills:
Automated TestingAWSAzureCi/CdData PipelinesEltETLGCPInformatica IdmcPythonRelational DatabasesSQLVersion Control
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop secure integrations enabling AI agents and applications to access exchange market data. Build backend services and APIs using Python, Java, or comparable technologies; implement authentication, authorization, identity management, licensing, entitlements, and usage controls. Apply market-data distribution expertise and AI integration patterns such as LLMs, agentic AI, and MCP while collaborating with financial institutions and technology stakeholders.
Top Skills:
Agentic AiApi GatewaysAPIsAuthenticationAuthorizationCloud-Based Data ServicesIdentity ManagementJavaLlmsModel Context Protocol (Mcp)OauthPython
Fintech • Machine Learning • Payments • Software • Financial Services
Leads hands-on data and software engineering across the full development lifecycle. Owns technical design, architecture, development, engineering standards, developer experience, and fault-tolerant application systems. Provides technical guidance to stakeholders, establishes best practices, contributes to high-level design, and mentors junior and intermediate engineers. The role requires expertise in application development, data modeling, cloud platforms, and modern software engineering practices within an agile financial-services environment.
Top Skills:
AWSCloud ComputingContainersGoGCPJavaMicroservicesAzurePythonRestful Apis
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.
