Senior Analytics Engineer – Data Modeling (Databricks), Capital Markets Duration: 12 Months (Possible extension) Location: Toronto - Hybrid- 1 day onsite Start Date: Oct 5th Interview Process: Codility test- 2 rounds (final in person)
Senior Analytics Engineer – Data Modeling (Databricks), Capital Markets About the Role We're looking for a Senior Analytics Engineer to own data design and modeling for Capital Markets business domains. This role combines senior data engineering and data modeling: You'll partner directly with business teams and deliver trusted, well-modeled data solutions on Databricks. The role is focused on modeling and business solutions rather than platform or pipeline infrastructure, and it works as a peer to the team's data engineers. Key Responsibilities
Business Partnership & Ownership
Act as the data design and modeling SME for an assigned business domain.
Partner with business stakeholders to understand goals, gather requirements, and translate them into scalable data solutions.
Own solution design end to end, from requirements to production, using reusable, cost-efficient patterns.
Data Design & Modeling
Design conceptual, logical, and physical data models (dimensional, slowly changing, historical/as-of) across medallion layers.
Build the transformations that implement these models, with data quality and validation built in.
Define data standards, business definitions, and documentation for the domain's data products.
Data Products & Analytics Enablement
Deliver curated, analysis-ready datasets and semantic layers for reporting, self-service analytics, and ML.
Resolve complex data questions for business users, and turn recurring ad hoc requests into scalable solutions.
Share knowledge and help raise modeling standards across the team.
Required Skills & Experience
Degree in Computer Science, Engineering, Mathematics, Finance, or a related field
6+ years in data engineering, analytics engineering, data modeling, or BI, with a strong focus on data modeling
2+ years hands-on with Databricks (Delta Lake, Unity Catalog, Databricks SQL)
Expert SQL and strong dimensional modeling skills (star schemas, SCDs)
Proficient in Python/PySpark
Proven experience working directly with business stakeholders to gather requirements and deliver solutions
Nice to Have
Capital Markets or financial services experience (trades, positions, risk, P&L, reference data)
Reporting and visualization (Power BI, Plotly, Databricks AI/BI Dashboards)
Semantic layers and AI-powered BI (Unity Catalog Metric Views, Databricks Genie)
Large-scale data migration experience
Databricks Certified Data Engineer (Associate or Professional)
Applicant Notices & Disclaimers
For information on benefits, equal opportunity employment, and location-specific applicant notices, click here
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws.The pay rate for this position is C$80.00/hr.
