Data Engineer & Database Developer Toronto, Canada (Hybrid)

CIX is seeking registration as Canada’s newest innovative Alternative Trading System, built to deliver a modern, transparent, and efficient marketplace for Canadian equities and listed products. We are a lean, entrepreneurial team where every member directly impacts how our markets operate. The Role We are looking for a Data Engineer & Database Developer to design, build, and own the analytical database and automated data pipelines that support CIX’s client billing, fee reporting, and market analytics. This is a greenfield build: you will architect a relational analytical store, develop the scripts and scheduled jobs that keep it populated from multiple data sources, and build the reporting and output layer on top of it. The ideal candidate brings 5–10 years of hands‑on experience in data engineering and database development, and is comfortable owning a system end‑to‑end in a lean, high‑impact environment. Key Responsibilities Database Design & Administration Design, implement, and maintain a relational analytical database — including schema design, indexing, query optimization, access controls, backup, and recovery. Define and enforce data integrity constraints and effective-date conventions for historical reference data; monitor database health and ensure high availability. Document schemas, data dictionaries, and data lineage for internal and operational use. Build and maintain scheduled ETL/ELT jobs to extract, transform, and load data from a production source database and external structured data files on an intraday and end-of-day basis. Implement idempotent, resumable pipelines with robust error handling, retry logic, alerting, job run logging, and support for historical reprocessing. Develop and maintain reference data refresh jobs that preserve historical records using effective-date versioning. Reporting & Data Quality Build automated data quality checks — record count reconciliation between source and target, foreign key validation, and coverage checks — with scheduled reporting to operations. Develop and deliver structured output files and reports to internal teams and clients via SFTP and other delivery channels on a scheduled basis. Contribute to analytics dashboards and self‑serve reporting layers for internal and client use. Collaborate with operations, compliance, and external partners on data requirements, delivery timelines, and system improvements. Other duties as assigned, supporting CIX technology and operational needs. Qualifications Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related discipline. 5+ years of hands‑on experience in data engineering, database development, or a closely related role. Strong scripting and development skills in one or more languages (e.g. Python, Go, Java, or similar) with demonstrated experience building and maintaining production data pipelines and automation scripts. Deep expertise in relational database design, administration, and optimization (PostgreSQL, Clickhouse, Influx, MySQL, or equivalent), including complex SQL, Linux functions, and performance tuning. Experience with columnar or OLAP databases (e.g. ClickHouse, Redshift, BigQuery, or similar) and job scheduling tools (cron, Airflow, or similar). Proficiency with Linux/Unix environments and shell scripting as part of day‑to‑day development work. Ability to work independently and take end‑to‑end ownership — from design through to production operations — in a mission‑critical environment. Comfortable supporting a mission‑critical production system, including monitoring, troubleshooting, and responding to data quality or pipeline issues as needed.[1] Background in financial services, capital markets, or a regulated data environment is a significant asset. Nice to Have The following are not requirements — strong candidates with the core database and scripting skills above are encouraged to apply regardless of experience in these areas. Linux/Unix server administration — user management, service configuration, monitoring, and system troubleshooting in a colocation or hybrid cloud environment. Scripting and automation for system management tasks, and familiarity with backup, monitoring, and logging infrastructure. Working knowledge of TCP/IP, VLANs, firewalls, and VPN configuration in a low‑latency or mission‑critical environment. Familiarity with secure connectivity concepts used in financial market infrastructure. Experience and interest in AI/ML models for anomaly detection, forecasting, or automated data quality checks in a data pipeline context. Familiarity with LLM APIs, AI tooling, or RAG workflows applied to structured operational or financial data. Why Join CIX? Be part of building the infrastructure of Canada’s new

Want to see how well you match this job?