18 Nov
|
Astra North Infoteck
|
Toronto
18 Nov
Astra North Infoteck
Toronto
Data Office Developer (SQL, Python, Data Engineering, Data Warehousing)Job Title: Data Office Developer (SQL, Python, ETL, Data Warehousing)Role: Data Office DeveloperKey ResponsibilitiesDesign, develop, and maintain database objects, scripts, queries, and data processing logic using SQL and PythonAnalyze business and technical requirements and translate them into scalable data solutionsSupport data extraction, transformation, loading, validation, reconciliation, and reporting activities across multiple data platformsDevelop and optimize SQL queries, stored procedures, and scripts to support data analysis, reporting, and operational needsWork with relational and cloud-based databases such as Oracle, IQ, BigQuery, and HANA, as applicableCollaborate with business analysts, data analysts, architects, quality engineering teams, and business stakeholders to understand data requirements and resolve issuesAssist in data modeling activities, including understanding source-to-target mapping, relationships, business rules, and data lineageSupport dashboard/reporting development or validation using tools such as Tableau and LookerPerform data quality checks, troubleshoot data issues, and support root cause analysis for defects or production incidentsPrepare and maintain technical documentation, data mapping documents, design notes, deployment steps,
and support handover materialsMust Have SkillsStrong hands-on experience with SQL, including writing, debugging, and optimizing complex queriesProficiency in Python for data processing, automation, scripting, and analysisSolid understanding of database concepts, including tables, views, joins, indexes, keys, normalization, stored procedures, and data integrityAbility to analyze data, troubleshoot issues, and validate results across source and target systemsExperience working with large datasets and applying data quality, reconciliation, and validation techniquesStrong communication skills with the ability to work with technical and business stakeholdersGood to Have SkillsExperience with database platforms such as Oracle, IQ, BigQuery, and SAP HANAUnderstanding of ETL concepts, including extraction, transformation, loading, scheduling, monitoring, and error handlingKnowledge of data modeling concepts such as conceptual, logical, and physical models, star schema, snowflake schema, facts, dimensions, and source-to-target mappingExperience with reporting and visualization platforms such as Tableau and LookerExposure to data warehousing, analytics platforms, cloud data services, and enterprise reporting environments
📌 Data Office Developer (Toronto)
🏢 Astra North Infoteck
📍 Toronto