The Senior Data Engineer designs and maintains data infrastructure, implements scalable pipelines, and collaborates on technical solutions while mentoring junior engineers.
The Senior Data Engineer designs, builds, and maintains scalable data infrastructure to support analytics, machine learning, and enterprise decision-making. This role leads the development of big data frameworks, translates complex requirements into robust architectures, and delivers high-performing, reliable data systems.
Key responsibilities include implementing data solutions, defining system requirements, and establishing integration standards and processes.
The ideal candidate brings deep SQL expertise, strong engineering discipline, and proven collaboration skills—partnering across teams, mentoring engineers, and influencing the organization’s technical roadmap.
***THIS ROLE REQUIRES 3 DAYS A WEEK IN OUR QUEBEC CITY OFFICE***
Major Responsibilities:
- Design, build, and maintain scalable data pipelines (batch & streaming) for analytics, reporting, and ML.
- Architect applications and automated tools, translating complex requirements into high-performing solutions.
- Define data/software solutions, including hardware needs, to ensure performance and scalability.
- Establish and enforce standards for data integration, modeling, and schema design (dimensional, star, snowflake).
- Optimize SQL queries and schema performance; ensure data quality, consistency, and validation.
- Monitor, troubleshoot, and tune pipelines, databases, and workloads.
- Implement engineering best practices: version control, CI/CD, testing, documentation, and code reviews.
- Collaborate with engineers to integrate data systems into production.
- Mentor junior engineers and provide cross-team technical support.
- Evaluate and recommend new tools, frameworks, and technologies.
- Ensure compliance with data security, governance, access control, and regulations (GDPR, CCPA).
Education and Experience:
- 5+ years in data, software, or data science engineering
- Expert in SQL (optimization, joins, windowing, partitioning, indexing)
- Proven Snowflake expertise in warehousing and analytics
- Strong knowledge of data modeling, engineering best practices, and distributed systems (Spark, Hadoop, Hive, Presto)
- Hands-on experience with ETL/ELT pipelines, API/event/log integration, and orchestration tools (Airflow/Astronomer required)
- Proficient in DBT for data transformation and modeling
- Skilled with AWS data engineering and infrastructure services
- Strong software engineering fundamentals: clean code, modularization, CI/CD, automated testing
- Solid understanding of object-oriented design, data structures, algorithms, and disaster recovery
- Expertise in scaling and optimizing pipelines, databases, and workloads
- Proficient in Python (preferred) and other modern languages
- Analytical, collaborative, and experienced in agile environments
- Creative, detail-oriented, and results-driven with strong problem-solving skills
Lightcast is a global leader in labor market insights with offices in Moscow, ID (US), the United Kingdom, Europe, and India. We work with partners across six continents to help drive economic prosperity and mobility by providing the insights needed to build and develop our people, our institutions and companies, and our communities.
Lightcast is proud to be an equal opportunity workplace. We consider all qualified applicants without regard to race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, or Veteran status. Lightcast has always been, and always will be, committed to our diversity of thought and unique perspectives. We seek dynamic professionals from all backgrounds to join our teams, and we encourage our employees to bring their authentic, original, and best selves to work.
Top Skills
Airflow
AWS
Dbt
Hadoop
Hive
Presto
Snowflake
Spark
SQL
Similar Jobs
Database
The Senior Data Engineer designs and maintains data infrastructure for analytics and machine learning. Responsibilities include building scalable pipelines, optimizing SQL, mentoring junior engineers, and ensuring data quality.
Top Skills:
AirflowAstronomerAWSDbtEltETLHadoopHivePrestoPythonSnowflakeSparkSQL
Big Data • Cloud • Food • Machine Learning • Software • Database • Analytics
The Quality Supervisor ensures compliance with quality systems, oversees audits, trains QA teams, and promotes food safety while managing several quality initiatives.
Top Skills:
FsscGmpHaccpIsoPolitiques Et Programmes De QualitéSystèmes De Qualité
Big Data • Cloud • Food • Machine Learning • Software • Database • Analytics
The Électrotechnicien ensures reliability and optimization of automated production lines through diagnostics, maintenance, and collaboration on continuous improvement projects.
Top Skills:
Abb Industrial RobotsCognex Vision SystemsControllogixDevicenetEthernet/IpKinetixMetaPanelviewPowerflexProfibusRockwell AutomationSAPSiemens S7Texas Instruments
What you need to know about the Montreal Tech Scene
With roots dating back to 1642, Montreal is often recognized for its French-inspired architecture and cobblestone streets lined with traditional shops and cafés. But what truly sets the city apart is how it blends its rich tradition with a modern edge, reflected in its evolving skyline and fast-growing tech industry. According to economic promotion agency Montréal International, the city ranks among the top in North America to invest in artificial intelligence, making it le spot idéal for job seekers who want the best of both worlds.
Key Facts About Montreal Tech
- Number of Tech Workers: 255,000+ (2024, Tourisme Montréal)
- Major Tech Employers: SAP, Google, Microsoft, Cisco
- Key Industries: Artificial intelligence, machine learning, cybersecurity, cloud computing, web development
- Funding Landscape: $1.47 billion in venture capital funding in 2024 (BetaKit)
- Notable Investors: CIBC Innovation Banking, BDC Capital, Investissement Québec, Fonds de solidarité FTQ
- Research Centers and Universities: McGill University, Université de Montréal, Concordia University, Mila Quebec, ÉTS Montréal
