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
Build Python-based frameworks to validate, reconcile, cleanse, and transform large datasets. Use Pandas and NumPy to identify data quality issues, discrepancies, duplicates, and anomalies. Automate validation workflows, investigate root causes, produce data quality reports, optimize processing, and collaborate with business, analytics, and engineering teams on data migration, onboarding, and integration initiatives.
Top Skills:
AWSAzureAzure Data FactoryCi/CdDatabricksGCPGitNumpyPandasPower BIPysparkPythonSQL
AdTech • Digital Media • eCommerce • Marketing Tech
Build and operate Databricks-based data products and pipelines that create, model, and deliver syndicated and custom consumer audience segments. Develop tables, views, jobs, workflows, and real-time processing solutions using Python, SQL, Spark, and Delta Lake. Support marketplace delivery, reporting, observability, metadata, testing, CI/CD, privacy compliance, and AI-assisted development. Partner with data science and commercial teams to translate business requirements into scalable engineering solutions, while promoting architecture and engineering best practices.
Top Skills:
SparkCi/CdClaude CodeDatabricksDatabricks Jobs & WorkflowsDatabricks NotebooksDelta LakeGithub CopilotLakeflow Declarative PipelinesLiverampLotamePythonSpark Structured StreamingSQLTruaudienceUnity Catalog
.jpg)
AdTech • Cloud • Marketing Tech • Productivity • Software • Analytics • Automation
Build and ship production AI systems across retrieval, knowledge graphs, inference, agentic workflows, and data platforms. Develop customer-context retrieval, scored signals, workflow automation, evaluation, and observability capabilities. Work hands-on with Python, SQL, dbt, lakehouse data, cloud infrastructure, model selection, and inference-cost optimization. Establish reusable engineering patterns and mentor teams through high-quality code and system design.
Top Skills:
Amazon S3Apache IcebergAWSClaudeCursorDbtDistributed Query EnginesDockerEmbeddingsGithub CopilotHybrid RetrievalKnowledge GraphsLanggraphMcpOpentelemetryPythonSQLTemporalVector Search
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.
