Data Modeler

18 hours ago

Toronto ON, Toronto Census Division, ON; Ontario, Canada Jarvis Consulting Group Full-time

NOTE that this is a hybrid role but requires FOUR (4) days/week on-site in downtown Toronto.

Jarvis is supporting a financial services client who is seeking a Senior Data Engineer who specifically has Finance Data Modeling experience.

About the role

We are hiring a Senior Data Engineer to build and own the finance data platform on Databricks. You will design the pipelines and data models behind the general ledger, sub-ledgers and financial reporting, turning raw data into trusted, reconciled datasets that Finance, FP&A and leadership rely on for close, reporting and planning.

What you'll do

  • Design and build scalable ELT pipelines on Databricks (PySpark, Spark SQL, Delta Lake) that ingest data from finance systems
  • Model core finance data: general ledger, chart of accounts, journal entries, trial balance, sub-ledgers (AP, AR, fixed assets), cost centres, legal entities and intercompany.
  • Build curated, reporting-ready layers using a medallion architecture (bronze, silver, gold) and dimensional modelling (star schemas, conformed dimensions, slowly changing dimensions).
  • Implement governance with Unity Catalog
  • Orchestrate and productionize workloads with Databricks Workflows or Airflow, CI/CD and infrastructure-as-code.
  • Tune performance and cost across clusters, SQL warehouses and Delta tables.
  • Mentor engineers, review code and set modelling and engineering standards for the team.

What you bring

  • 7+ years in data engineering, including 3+ years building production workloads on Databricks.
  • Strong Python/PySpark and advanced SQL;
    deep working knowledge of Delta Lake.
  • Solid dimensional modelling skills (Kimball) and experience with medallion architectures.
  • Experience building data quality and reconciliation controls in a regulated or audited environment.
  • Hands‑on with a major cloud platform (Azure, AWS or GCP), Git‑based CI/CD & orchestration tools.
  • Clear communicator who can work with finance leaders as comfortably as with engineers.
  • Preference will be given to candidates with Databricks Certifications.

This is an initial 4-6 month contract term with a strong likelihood of extension.

#J-18808-Ljbffr