Senior Data Engineer

Posted 9hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Senior Data Engineer building auditable GCP data pipelines for DysrupIT’s financial billing and invoicing platform. Ensuring accurate reconciliation, lineage, and trusted financial data.

Responsibilities:

  • Design, build, and maintain data ingestion pipelines for financial and billing data on GCP
  • Design and evolve BigQuery data models, including nested ARRAY/STRUCT tables, partitioning, and clustering strategies
  • Implement reconciliation checks across source, staging, and output layers
  • Build file validation and quarantine processes for invalid or incomplete source data
  • Design idempotent pipelines that can be safely rerun without duplicating or corrupting data
  • Implement append-only table patterns and use views as data checks to support auditability
  • Handle monetary values accurately using BigQuery NUMERIC types and appropriate rounding rules
  • Manage effective-dated reference data such as rates, mappings, and customer attributes
  • Establish and maintain data lineage from outputs back to their sources
  • Write clean, typed, and well-tested Python code using pydantic and pytest
  • Write and optimize advanced SQL for transformation, reconciliation, and reporting
  • Collaborate with engineers, analysts, and finance stakeholders to translate business rules into reliable data logic
  • Mentor team members and contribute to data engineering standards and best practices

Requirements:

  • 6+ years of data engineering experience
  • Proven experience building financial or billing pipelines where every amount must reconcile
  • Strong Python skills, including pydantic, typed code, and pytest
  • Advanced SQL skills, including complex joins, window functions, and performance tuning
  • In-depth Google BigQuery experience, including nested ARRAY/STRUCT tables, partitioning, and clustering
  • Experience handling money accurately using NUMERIC data types
  • Experience designing append-only tables and using views as data checks
  • Strong understanding of data quality practices, including reconciliation checks, file validation, and quarantine
  • Experience building idempotent, rerunnable pipelines
  • Experience implementing data lineage and managing effective-dated reference data
  • Invoicing domain experience, including credit notes, rebills, FX conversion, and month-end close (preferred)
  • Experience working with finance or billing teams in a regulated or audited environment (preferred)
  • Experience with other GCP services such as Cloud Storage, Cloud Run, or Firestore (preferred)

Benefits:

  • Training and employee development opportunities
  • Career growth and advancement opportunities
  • Employees valued and respected
  • Positive and supportive company culture