Job Title: Business Systems Analyst - Databricks
City: Toronto
State/Province: Ontario
Posting Start Date: 6/12/26
Job Description:
Job DescriptionMandatory skills
Databricks, data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions
Good to have skills
STTM (Source to target mapping) doc, Good Communication Skills, SQL,- Python/ PySpark,- ETL,- Databricks,- Tech documentation,- Data lineage
Job Description:Provide functional/technical leadership across a broad range of data analysis functions including data modeling, structured query language (SQL), data quality, data profiling, extract-transform-load (ETL), metadata enrichment and management, data provenance and lineage, report design and other specialized data management functions. Works independently as a senior lead and may manage and direct activities related to analysis, design and support of technical data management solutions on various projects ranging in larger projects.
Must Haves: - 5+ years of BSA experience in Databricks, data analytics/data warehouse/data integration through agile environment.
- Strong experience in data analysis, profiling, clean-up, data wrangling and validation. Hands-on experience building data quality checks and writing complex SQL queries.
- Experience working with Jira, Confluence, Bitbucket.
- Demonstrable experience with conceptual, logical and physical data modeling techniques.
- Strong analytical, organizational, and technical skills to analyze, model and interpret data.
- Good understanding of data Security Classifications, Risk Assessment (TRMIS) guidelines.
- Experience with supporting legacy applications such as Mainframe, other on-prem applications and Migration of legacy solutions using COTS products.
- Experience in current state analysis through reverse engineering, identify source & downstream systems.
- Experience in conducting feasibility analysis, project scoping and providing project work estimates.
- Experience with requirements development involving requirements elicitation, analysis, specification and validation.
- Hand-on experience in capturing Data Lineage and Data Mapping between Source and Target systems.
- Experience in 2 or more skills along with databricks - Azure Data Factory, python/pyspark, Tableau, Power BI, Mainframe, SAS.
- Should have good knowledge on STTM (Source to target mapping) doc.
- Must have good communication skills.
Mandatory Skills: Institutional Compliance.
Experience: 5-8 Years.
The expected compensation for this role ranges from CAD 77000 to CAD 120000 .
