Senior Data Engineer - Zonda - Toronto, ON
CoStar Group2 days ago
Toronto, CanadaSenior
Responsibilities
- Design, build, test, and maintain reliable, scalable data pipelines and data products.
- Develop and optimize data transformations and orchestrations using SQL, Python, dbt, Airflow, Glue, PostgreSQL, and Snowflake.
- Translate business requirements into maintainable technical designs and production-ready solutions.
- Implement automated testing, data-quality checks, monitoring, failure handling, recovery, metadata, and lineage.
- Optimize large-scale data workloads for performance, scalability, and cost.
- Troubleshoot production issues and perform root-cause analysis across pipelines and databases.
- Use Git-based development, code review, and controlled release practices.
- Reduce technical debt, manual processes, and recurring operational issues through automation and improved design.
- Collaborate with Product Management, Application Engineering, and business stakeholders.
Requirements
- 6+ years of professional experience in data engineering or a closely related discipline.
- Strong Python development skills for data pipelines, automation, integrations, and supporting data applications.
- Advanced SQL skills and experience working with large-scale datasets.
- Strong understanding of data modeling, database design, and data transformation patterns.
- Production experience with dbt, including model development, dependency management, testing, incremental processing, and deployment.
- Production experience with Airflow, including DAG development, orchestration, dependencies, retries, failure handling, scheduling, and operations.
- Hands-on PostgreSQL experience with complex SQL, database design, indexing, query optimization, and performance tuning.
- Hands-on Snowflake experience in production data workloads.
- Experience with AWS data services including S3, RDS/Aurora, Glue, MWAA, IAM, and CloudWatch.
- Experience implementing automated data validation and quality controls.
- Experience with Git, pull requests, code review, conflict resolution, and CI/CD workflows.
- Demonstrated ability to troubleshoot complex production pipeline and data issues.
- Preferred qualifications include Amazon Aurora PostgreSQL, very large datasets, AWS Glue, Amazon MWAA, geospatial data, PostGIS, SQL Server, DataHub or comparable governance platforms, Grafana or comparable observability tooling, and schema migration or version-control frameworks.
- Strong engineering ownership, analytical and troubleshooting skills, reliability focus, and ability to collaborate with technical and non-technical stakeholders.
Benefits
- Comprehensive medical, vision, dental, prescription drug, life, legal, and supplementary insurance.
- Virtual and in-person mental health counseling for individuals and families.
- Commuter and parking benefits.
- 401(k) retirement plan with matching contributions.
- Employee stock purchase plan and paid time off.
- Tuition reimbursement and internal professional and academic training.
- On-site fitness center or reimbursed fitness center membership costs, depending on location.
- Employee Resource Groups, complimentary beverages, fresh fruit, and healthy snacks.
- Full-time employment in Toronto, Canada; candidates must already be eligible to work full-time in Canada.
Tech Stack
Categories
Data Engineering
About CoStar Group
CoStar Group builds subscription databases, analytics, and online marketplaces for commercial and residential real estate professionals, investors, and advertisers. Its portfolio includes CoStar (research and data), LoopNet (commercial listings), and Apartments.com (rental listings), generating revenue from subscriptions, listings, and advertising. The company is publicly traded on NASDAQ (CSGP) and is headquartered in Arlington, Virginia, with inclusion in the S&P 500 index.