Data Engineer 2

Jones Lang LaSalle Incorporated; Toronto; On-site; CAD 100,000 - 130,000; Full time

Benefits offered by this job

Total Rewards program

Discretionary bonuses

Benefits package

Job summary

Jones Lang LaSalle is seeking a Data Engineer 2 to design and deploy production-grade data pipelines and analytics-ready datasets. You will broaden CI/CD capabilities, ingest data from APIs and databases, and implement robust validation and monitoring in collaboration with cross-functional teams.

The role emphasizes AI/automation integration, cloud data services, and scalable architectures to support enterprise real estate analytics. On-site in Toronto, replacement opening.

Qualifications

• Build ETL/data pipelines in production environments.
• base knowledge of Python and SQL.
• familiarity with data orchestration platforms and cloud data services.

Responsibilities

• Advance data pipeline development and ETL/ELT workflows.
• Build and modify CI/CD pipelines for data processing.
• Ingest data from APIs, databases, and file systems.
• Implement validation, error handling, and monitoring in production pipelines.
• Collaborate with product managers and analysts on data needs.
• Translate business requirements into scalable data solutions.

Skills

Python (decorators/generators)

SQL

Airflow

Azure Data Factory

SSIS

Spark / PySpark

Databricks

Delta Lake

CubeJS / semantic layer

CI/CD for data pipelines

Design patterns

AI / Automation integration

Education

Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or related quantitative discipline

Tools

Airflow

Azure Data Factory

SSIS

Spark

PySpark

Databricks

Delta Lake

Azure Functions

CubeJS

Job description

JLL empowers you to shape a brighter way. Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology for our clients. We are committed to hiring the best, most talented people and empowering them to thrive, grow meaningful careers and to find a place where they belong. Whether you’ve got deep experience in commercial real estate, skilled trades or technology, or you’re looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward.

About the role

As a Data Engineer 2, you will utilize AI, automation, and domain expertise to develop enterprise data solutions that drive strategic business value. You’ll translate business needs into technical requirements while demonstrating strategic awareness of how data engineering supports organizational objectives. Working with intermediate to advanced technical skills, you’ll solve medium to high complexity data problems and collaborate with senior engineers on strategy execution. This role focuses on building production-ready data pipelines, expanding CI/CD capabilities, and delivering solutions that impact scrum team deliverables while communicating effectively with cross-functional stakeholders.

Responsibilities

• Advanced Data Pipeline Development
• Design and implement complete ETL/ELT workflows using intermediate to advanced techniques
• Build and modify CI/CD pipelines for data processing workflows
• Develop native data ingestion capabilities from various sources (APIs, databases, file systems)
• Implement data validation, error handling, and monitoring in production pipelines
• AI & Automation Integration
• Incorporate AI and automation patterns into data engineering solutions
• Develop solutions that leverage automation for improved efficiency and scalability
• Apply intermediate Python techniques including decorators, generators, and design patterns
• Build reusable components and frameworks for team use
• Cross-functional Collaboration
• Translate business requirements into technical data engineering solutions
• Collaborate with product managers, analysts, and other stakeholders on data needs
• Participate actively in scrum/agile development processes
• Provide technical expertise to support strategic decision-making
• Data Architecture & Design
• Apply data modeling principles and data warehousing concepts
• Design database schemas and data integration patterns
• Work with cloud services (Azure/AWS/GCP) for scalable data solutions
• Optimize data storage and retrieval for performance and cost

Qualifications

Experience & Education

• Bachelor’s degree in Computer Science, Information Systems, Mathematics, Statistics, or related quantitative discipline
• 2-5 years of experience in data engineering, data development, or related technical field
• Proven experience building ETL/data pipelines in production environments
• Experience with agile development methodologies and cross-functional teams

Technical Skills & Competencies

• Programming: Intermediate Python skills including decorators, generators, object-oriented programming
• SQL: Solid SQL proficiency with query optimization and performance tuning experience
• Data Engineering: Experience with data orchestration platforms (Airflow, Azure Data Factory, SSIS, or similar)
• Big Data: Familiarity with Apache Spark, PySpark, or similar distributed processing frameworks
• Cloud Platforms: Hands-on experience with Azure, AWS, or GCP data services (Databricks, Azure Functions, Delta Lake, etc.)
• Data APIs & Semantic Layer: Familiarity with semantic layer tools (CubeJS or similar) for data access and analytics
• CI/CD: Understanding of continuous integration/deployment for data pipelines
• Design Patterns: Knowledge of software design patterns and their application in data engineering
• AI/Automation: Basic understanding of AI/automation tools and their integration into data workflows

Core Competencies Assessment

• Technical Skills (40%): Built ETL/data pipelines, production experience, CI/CD knowledge, AI/automation awareness
• Problem-Solving (25%): Production pipeline experience, architecture basics, scalability awareness
• Communication (20%): Agile team experience, stakeholder communication, cross-functional work
• Learning & Growth (15%): AI/automation project exposure, learning track record, business understanding

What we can do for you

You’ll join a dynamic team where you’ll work on cutting-edge data engineering projects that incorporate AI and automation technologies. We provide opportunities to expand your technical skills while gaining valuable experience in enterprise-scale data solutions and cross-functional collaboration. Our Total Rewards program reflects our commitment to helping you achieve your ambitions in career, recognition, well-being, benefits and pay. Join us to advance your data engineering career while contributing to innovative solutions that leverage AI and automation to transform real estate data processing and analytics.

Estimated compensation for this position: 100,000.00 – 130,000.00 CAD per year

This range represents the estimated base salary and actual compensation may differ. Final base salary is determined by various considerations including but not limited to candidate qualifications, location, market conditions, and internal considerations. Some roles and employees may be eligible for discretionary bonuses, benefits, or other compensation.

Location: On-site –Toronto, ON

Opening Type: Replacement

Jones Lang LaSalle (“JLL”) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process – including the online application and/or overall selection process, you may email us at [e-mail]. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page.

At JLL, we harness the power of artificial intelligence (AI) to efficiently accelerate meaningful connections between candidates and opportunities. Using AI capabilities, we analyze your application for relevant skills, experiences, and qualifications to generate valuable insights about how your unique profile aligns with the specific requirements of the role you're pursuing.

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services. We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLL’s recruitment process. We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons. We will then delete it safely and securely. For more information about how JLL processes your personal data, please view our Candidate Privacy Statement. For additional details please see our career site pages for each country.

For over 200 years, JLL (NYSE: JLL), a leading global commercial real estate and investment management company, has helped clients buy, build, occupy, manage and invest in a variety of commercial, industrial, hotel, residential and retail properties. A Fortune 500 company with operations in over 80 countries around the world, our employees bring the power of a global platform combined with local expertise. Driven by our purpose to shape the future of real estate for a better world, we help our clients, people and communities SEE A BRIGHTER WAYSM. JLL is the brand name, and a registered trademark, of Jones Lang LaSalle Incorporated. For further information, visit jll.com.