Data Analyst (Databricks)

About this role

Job#: 3021503
Job Description:
Data Analyst - Intermediate
Project Scope:
Working on CMDA (Capital Markets Data Architecture) to centralize capital markets data on Databricks; typical work includes data ingestion, building data pipelines, enrichment, and modeling to retrieve/serve data from Databricks


Role reports to:
Director of Application Services - Jira distribution will be done by Team Lead


Reason the role is open:
Work overflow / long backlog of pipelines & requirements; need analysts to pick up queued tasks


Target Start Date:
March 2nd


Duration:
6 months


Potential for extension or conversion to full-time:
Yes


Rate:
$50-60/hr T4


Remote/Hybrid:
Hybrid - Every Thursday and everything third Friday


Office Location:
Downtown Toronto


Job Description:

• Design, build, and maintain data pipelines on Databricks/Spark for ingestion, curation, and retrieval of capital markets data.
• Perform data enrichment and data modeling aligned to business needs and platform standards.
• Write clean, efficient SQL and Python for transformations, validation, and automation.
• Collaborate with the team lead (assigns JIRAs/work items) and senior developers; participate in code reviews and delivery ceremonies.
• Operate within Azure (preferred) and adapt concepts from other clouds as needed; contribute to documentation and knowledge sharing.

Key Qualifications:

• 5 years experience as a Data Analyst/Engineer with big data and data pipelines
• Strong SQL and Python.
• Hands-on with Databricks and solid understanding of the Spark engine.
• Experience with data modeling and enrichment.
• Cloud experience—Azure preferred (conceptual parity with AWS/GCP acceptable for ramp-up).

Nice to Have:

• Capital Markets data/domain exposure (advantageous but not mandatory).
• Experience in Azure-native services around Databricks; familiarity with AWS or GCP concepts.

Apex Systems is a...