Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)
Posted Updated
Astra-North Infoteck Inc. Data Office Developer (SQL , Python, Data Engineering , Data Warehousing)
Description
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.
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. 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.Skills
Sign in to read and join the discussion.