Role: Data Analyst – Databricks - Brampton, ON
Contract
Job Description
The data analyst is responsible for designing, building, and validating data solutions within Databricks, ensuring balances, metadata, and hierarchies are accurately reconciled and that solutions are fully tested, deployed, and documented.
Responsibilities include:
- Design and document the solution architecture within Databricks, including data models, pipelines, and layered (bronze/silver/gold) structures aligned to Finance reporting requirements
- Define data ingestion, transformation, and security approaches that follow enterprise data standards and best practices
- Perform balance reconciliation between source systems and Databricks, identifying, investigating, and resolving variances to ensure financial accuracy
- Perform metadata reconciliation to confirm that data definitions, attributes, and mappings are complete and consistent between source and target
- Perform hierarchy reconciliation to validate that organizational, account, and reporting hierarchies are accurately reflected and aligned to the source of record
- Following the approved data governance policies, develop and execute test plans and scripts, including unit, integration, and user acceptance testing, and track and resolve defects
- Support the deployment of Databricks solutions to production following change management and release processes
- Create and maintain documentation, including design specifications, reconciliation results, test evidence, and operational runbooks
- Collaborate with Finance, Oracle, and data engineering teams to clarify requirements and resolve data issues
Requirements and skills:
- Hands-on experience with Databricks, including SQL, Python and/or PySpark
- Strong understanding of data reconciliation concepts, particularly for financial balances, metadata, and hierarchies
- Experience with data modelling and solution design in a cloud data platform
- Good communication skills are necessary
- Self-starter, motivated and results oriented collaborator
- Detail oriented, strong analytical and problem-solving skills and have an ability to find creative solutions
- Strong teamwork skills, but ability to work independently
- Familiar with Office 365 (intermediate skills in Excel preferred)
- Preferably working knowledge of Oracle Cloud Financials
- Preferably Databricks certification, but not necessary