Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)

Astra-North Infoteck Inc.

Toronto

On-site

CAD 90,000 - 130,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Astra-North Infoteck Inc. is seeking a Data Office Developer to design, implement, and optimize data pipelines and warehousing solutions. You will work with SQL and Python to transform data, ensure quality, and support reporting across multiple platforms.

You will collaborate with analysts, architects, and stakeholders to understand data requirements, validate results, and contribute to data modeling and lineage. The role emphasizes reliability, scalability, and documentation.

Qualifications

  • Strong SQL skills with writing, debugging, and optimizing complex queries.
  • Proficiency in Python for data processing, automation, scripting, and analysis.
  • Solid understanding of database concepts, normalization, and data integrity.
  • Ability to analyze data, troubleshoot issues, and validate results across source and target systems.
  • Experience with large datasets, data quality, reconciliation, and validation techniques.

Responsibilities

  • Design, develop, and maintain database objects, scripts, queries, and data processing logic using SQL and Python.
  • Analyze business and technical requirements and translate them into scalable data solutions.
  • Support data extraction, transformation, loading, validation, reconciliation, and reporting across multiple data platforms.
  • Develop and optimize SQL queries, stored procedures, and scripts to support data analysis and reporting.
  • Work with relational and cloud-based databases such as Oracle, IQ, BigQuery, and HANA as applicable.
  • Collaborate with business analysts, data analysts, architects, quality engineering teams, and stakeholders to understand data requirements and resolve issues.
  • Assist in data modeling activities, including source-to-target mapping, relationships, rules, and data lineage.
  • Support dashboard/reporting development or validation using Tableau and Looker.
  • Perform data quality checks, troubleshoot data issues, and support root cause analysis for defects or production incidents.
  • Prepare and maintain technical documentation, data mapping documents, design notes, deployment steps, and handover materials.

Skills

SQL
Python
Data processing
Data modeling
Data quality
Communication

Tools

Tableau
Looker
Oracle
IQ
BigQuery
SAP HANA

Job description

Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)

Job Title: Data Office Developer (SQL, Python, ETL, Data Warehousing)

Role: Data Office Developer

Key Responsibilities
  • Design, develop, and maintain database objects, scripts, queries, and data processing logic using SQL and Python
  • Analyze business and technical requirements and translate them into scalable data solutions
  • Support data extraction, transformation, loading, validation, reconciliation, and reporting activities across multiple data platforms
  • Develop and optimize SQL queries, stored procedures, and scripts to support data analysis, reporting, and operational needs
  • Work with relational and cloud-based databases such as Oracle, IQ, BigQuery, and HANA, as applicable
  • Collaborate with business analysts, data analysts, architects, quality engineering teams, and business stakeholders to understand data requirements and resolve issues
  • Assist in data modeling activities, including understanding source-to-target mapping, relationships, business rules, and data lineage
  • Support dashboard/reporting development or validation using tools such as Tableau and Looker
  • Perform data quality checks, troubleshoot data issues, and support root cause analysis for defects or production incidents
  • Prepare and maintain technical documentation, data mapping documents, design notes, deployment steps, and support handover materials
Must Have Skills
  • Strong hands-on experience with SQL, including writing, debugging, and optimizing complex queries
  • Proficiency in Python for data processing, automation, scripting, and analysis
  • Solid understanding of database concepts, including tables, views, joins, indexes, keys, normalization, stored procedures, and data integrity
  • Ability to analyze data, troubleshoot issues, and validate results across source and target systems
  • Experience working with large datasets and applying data quality, reconciliation, and validation techniques
  • Strong communication skills with the ability to work with technical and business stakeholders
Good to Have Skills
  • Experience with database platforms such as Oracle, IQ, BigQuery, and SAP HANA
  • Understanding of ETL concepts, including extraction, transformation, loading, scheduling, monitoring, and error handling
  • Knowledge of data modeling concepts such as conceptual, logical, and physical models, star schema, snowflake schema, facts, dimensions, and source-to-target mapping
  • Experience with reporting and visualization platforms such as Tableau and Looker
  • Exposure to data warehousing, analytics platforms, cloud data services, and enterprise reporting environments
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Inizio Partners Corp • Toronto

On-site
CAD 90,000 - 130,000
Data Analyst
Data Analyst

Spait Infotech • Canada

On-site
CAD 65,000 - 90,000
Power BI Developer
Power BI Developer

Precision Technologies • Mississauga

On-site
CAD 110,000 - 140,000
Senior Data Warehousing & BI Engineer
Senior Data Warehousing & BI Engineer

Analyst Technical Solutions • Toronto

On-site
CAD 90,000 - 120,000
Sr. Data Engineer
Sr. Data Engineer

HRBrain Inc. • Toronto

On-site
CAD 130,000 - 180,000
Data Engineer
Data Engineer

Compunnel Inc. • Toronto

On-site
CAD 100,000 - 130,000
Data Engineer
Data Engineer

Jliconsulting • Vaughan

On-site
CAD 80,000 - 100,000
Senior Software Development Engineer
Senior Software Development Engineer

GoDaddy Inc. • Ottawa

Remote
CAD 110,000 - 160,000
Technical Lead - Cloud Data Warehouse
Technical Lead - Cloud Data Warehouse

Massive Insights Inc. • Toronto

Hybrid
CAD 140,000 - 200,000
Hybrid work location
Health & dental benefits
Background check
Senior Data Engineer
Senior Data Engineer

Apply Digital • Vancouver

On-site
CAD 120,000 - 180,000