Job Title: Data Office Developer
Job Type: Full Time
Location: Toronto, ON (Hybrid)
We are seeking a skilled Data Office Developer with strong hands-on experience in SQL and Python to design, develop, and maintain scalable data solutions. The ideal candidate will have solid database knowledge, experience working with large datasets, and the ability to analyze, validate, and troubleshoot data across source and target systems.
- Design, develop, and maintain database objects, scripts, queries, and data processing logic using SQL and Python
- Translate business and technical requirements into scalable data solutions
- Support data extraction, transformation, loading, validation, reconciliation, and reporting activities
- Develop and optimize complex SQL queries, stored procedures, and scripts
- Work with relational and cloud databases including Oracle, IQ, BigQuery, and SAP HANA
- Collaborate with business analysts, data analysts, architects, QA teams, and stakeholders
- Support data modeling, source-to-target mapping, business rules, and data lineage activities
- Support dashboard and reporting development or validation using Tableau and Looker
- Perform data quality checks, troubleshoot issues, and conduct root cause analysis
- Maintain technical documentation, data mapping documents, design notes, and deployment procedures
- Strong hands-on experience with SQL, including complex query development, debugging, and optimization
- Proficiency in Python for data processing, automation, scripting, and analysis
- Strong understanding of database concepts including tables, views, joins, indexes, keys, normalization, and stored procedures
- Experience analyzing and validating data across source and target systems
- Experience working with large datasets and performing data quality, reconciliation, and validation
- Strong communication and stakeholder collaboration skills
- Experience with Oracle, IQ, BigQuery, or SAP HANA
- Understanding of ETL concepts and data integration processes
- Knowledge of conceptual, logical, and physical data modeling
- Experience with Tableau or Looker
- Exposure to data warehousing, analytics platforms, and cloud data services
Cloud Developer DevOps Engineer Senior Email Security Engineer
