Azure Databricks Data Engineer – Reporting & Analytics

Company: Excellent Consultancy Services Inc.

Location: Brampton, ON

Work Arrangement: Hybrid / Remote

Employment Type: Full-time / Contract (as applicable)

Job Category: Information Technology – Data Engineering & Analytics

Job Overview

Excellent Consultancy Services Inc. is seeking an experienced Azure Databricks Data Engineer with strong hands-on experience in Azure Databricks, advanced SQL querying, data engineering, and reporting solutions.

The successful candidate will be responsible for developing and optimizing data pipelines, extracting and transforming complex datasets, building reports, and supporting enterprise reporting and analytics initiatives.

Candidates with exposure to Oracle ERP Cloud or Oracle Financials will have an added advantage.

Key Responsibilities

- Design, develop, and maintain data engineering solutions using Azure Databricks.
- Write, optimize, and troubleshoot complex SQL queries.
- Develop SQL queries involving complex joins, CTEs, subqueries, and window functions.
- Build and maintain ETL/ELT data pipelines.
- Perform data extraction, transformation, cleansing, and integration.
- Develop reporting solutions and support business analytics requirements.
- Perform data validation, reconciliation, and quality checks.
- Optimize SQL queries and data processing performance.




- Work with business stakeholders to understand reporting requirements.
- Troubleshoot data discrepancies and provide analytical solutions.

Required Skills & Qualifications
- Strong hands-on experience with Azure Databricks.
- Advanced SQL querying and optimization skills (mandatory).
- Strong understanding of data engineering and ETL/ELT processes.
- Experience developing complex SQL queries, joins, CTEs, and window functions.
- Experience in data extraction, transformation, and reporting.
- Knowledge of data modeling and performance optimization.
- Experience with data validation and reconciliation.
- Robust analytical, problem-solving, and troubleshooting skills.

Preferred / Nice-to-Have Skills
- Exposure to Oracle ERP Cloud or Oracle Financials.
- Experience with Python and PySpark.
- Knowledge of Power BI or other reporting platforms.
- Experience with Azure Data Factory.
- Familiarity with Delta Lake.
- Experience supporting financial data and enterprise reporting.

Ideal Candidate Profile We are looking for candidates who have strong practical experience in Azure Databricks and advanced SQL development, particularly in data engineering, reporting, and analytics environments.

Candidates must be able to demonstrate hands-on SQL expertise and should not rely solely on theoretical knowledge.

Pay: $50.00-$65.00 per hour

Work Location: Hybrid remote in Brampton, ON

📌 Azure Databricks Data Engineer – Reporting & Analytics (Brampton)
🏢 Talent Grid
📍 Brampton