Job Title: Data Office Developer Location: Toronto, Ontario, Canada Work Mode: Hybrid Job Description We are seeking a Data Office Developer with solid expertise in SQL, Python, and database technologies to design, develop, and support enterprise data solutions.

The ideal candidate will be responsible for developing database objects, optimizing queries, supporting ETL processes, ensuring data quality, and collaborating with cross-functional teams to deliver scalable and reliable data solutions.

Key Responsibilities Design, develop, and maintain database objects, SQL scripts, queries, and Python-based data processing solutions.

Analyze business and technical requirements and translate them into scalable data solutions.

Support data extraction, transformation, loading (ETL), validation, reconciliation, and reporting across multiple data platforms.

Develop and optimize complex SQL queries, stored procedures, and scripts for reporting, analytics, and operational requirements.

Work with enterprise databases including Oracle, SAP IQ, Google Big

Query, and SAP HANA .

Collaborate with business analysts, data analysts, architects, QA teams, and business stakeholders to gather requirements and resolve data-related issues.

Support data modeling activities including source-to-target mapping, data lineage, relationships, and business rules.

Develop, validate, and support dashboards and reports using Tableau and Looker .

Perform data quality validation, troubleshoot production issues,



conduct root cause analysis, and implement corrective actions.

Create and maintain technical documentation, data mapping documents, deployment guides, and operational support documentation.

Required Skills Strong hands-on experience with SQL , including writing, debugging, and optimizing complex queries.

Proficiency in Python for data processing, automation, scripting, and analysis.

Strong understanding of relational database concepts including tables, views, joins, indexes, keys, normalization, stored procedures, and data integrity.

Experience working with large datasets and implementing data validation, reconciliation, and quality checks.

Strong analytical, troubleshooting, and problem-solving skills.

Excellent communication and stakeholder management skills.

Preferred Skills Experience with Oracle, SAP IQ, Google Big

Query, and SAP HANA .

Knowledge of ETL concepts including extraction, transformation, loading, scheduling, monitoring, and error handling.

Understanding of data modeling concepts including conceptual, logical, and physical data models, star schema, snowflake schema, facts, dimensions, and source-to-target mapping.

Experience with reporting and visualization tools such as Tableau and Looker .

Exposure to data warehousing, cloud data platforms, analytics solutions, and enterprise reporting environments.

Primary Skills (PS) SQL, Python, Oracle, Big

Query, SAP HANA, ETL, Tableau.

📌 Data Office Developer (Toronto)
🏢 AceStack
📍 Toronto