Design, build, and optimize ETL pipelines, data schemas, and data tools to support analytics and data science. Tune SQL and databases for performance and collaborate with teams to scale data infrastructure using Snowflake, Python, and related tools.
Company Description
You will join a world-class team of engineers and data scientists from Facebook, Uber, Amazon and Google. We are a fast growing consulting firm based in Toronto with clients ranging from leading startups building impactful technologies to Fortune 500 companies looking to scale their engineering and data capabilities.
Job DescriptionWe are looking for a data engineer who is passionate about analytics and helping companies build and scale data. You enjoy working with data and are motivated to produce high quality data tools and pipelines that help empower other data scientists. You are experienced in architecting data ETL workflows and schemas. Critical thinking and problem-solving skills are essential for this role.
Qualifications- BS (or higher, e.g., MS, or PhD) in Computer Science, Engineering, Math, or Statistics
- Hands on experience working with user engagement, social, marketing, and/or finance data
- Proficient in Python (i.e. Pandas, Numpy, scikit-learn, etc), R, TensorFlow, amongst other data science related tools and libraries
- Extensive experience working on relational databases, designing complex data schemas, and writing SQL queries
- Deep knowledge on performance tuning of ETL Jobs, SQL, and databases
- Working knowledge of Snowflake
- Experience working with Airflow is a strong plus
- Devops experiences is a plus
We have very competitive compensation.
Work on cool projects based on your interests and skills. We believe in accountability and NOT micro-management.
Ample Insight Toronto, Ontario, CAN Office
Toronto, Ontario, Canada
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Designs and maintains reliable data pipelines and computed tables using SparkSQL and PySpark. Integrates IoT, product, customer, external, unstructured, and ML-related data into scalable data models supporting analytics, causal inference, model training, and dashboards. The role requires ETL development, data orchestration, API integration, strong data quality and uptime, and collaboration with Data Science, AI/ML, Analytics, and engineering teams. This is a remote position for candidates residing in Canada.
Top Skills:
AirflowSparkAWSAzureDagsterDatabricksDelta LakeGCPGitGitPrefectPysparkPythonRest ApisSparksqlSQL
Aerospace • Hardware • Robotics • Software
Build a high-performance frontend data platform for exploring and analyzing hardware telemetry. Develop React and TypeScript applications, interactive time-series visualizations, data visualization plugins, complex application state management, and LLM-assisted analysis workflows. Collaborate directly with hardware engineers and customers to define interfaces, prototype workflows, demonstrate features, and incorporate feedback into product development.
Top Skills:
LlmsReactTypescript
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Architect and own marketing data infrastructure, including Databricks pipelines, Gold Layer tables, semantic models, and trusted analytics foundations. Lead cross-functional data initiatives, translate ambiguous business needs into scalable solutions, improve reliability and quality, and mentor engineers. Build and monitor production LLM and agent systems, automate workflows with AI, and deliver high-quality Python and SQL while validating AI-generated code. Partner with Marketing, Sales, BI, Data Science, and R&D teams.
Top Skills:
Ai AgentsBigQueryClaude CodeCursorData WarehousesDatabricksDbtEtl/EltLakehousesLlmsMarketing AutomationMartechPythonSalesforceSemantic LayersSnowflakeSQLStreamlitWeb Analytics
What you need to know about the Toronto Tech Scene
Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.
