Sr. Data Engineer

Bits In Glass; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

Bits In Glass seeks a Senior Data Engineer to design and implement modern data architectures enabling data-driven decisions. You will lead data ecosystems across cloud platforms, ensuring integration, performance, and compliance.

You’ll collaborate with business stakeholders and analytics teams to translate requirements into scalable data solutions and drive data modernization initiatives.

Qualifications

• 5+ years of experience in data architecture, data engineering, or analytics solution design.
• Hands-on with data lake/warehouse tech (Databricks, Snowflake, Redshift, Synapse).
• Strong data modeling, data integration, and ETL/ELT design skills.
• Proficient in SQL and PySpark/Python (Scala) for complex data transformations.
• Solid data governance, security, and privacy practices.

Responsibilities

• Design end-to-end data architectures (data lakes, warehouses, analytics platforms).
• Define data integration/transformation strategies ensuring scalability and security.
• Translate business requirements into technical data solutions for analytics/AI.
• Develop data models and ETL/ELT pipelines for structured/unstructured data.
• Provide technical leadership and mentoring to data engineers and developers.

Skills

SQL

Python

Pyspark

Scala

Data modeling

Education

Bachelor's degree in Computer Science or related field

Master's degreePreferred

Tools

Databricks

Snowflake

Redshift

Azure Synapse

AWS

Delta Live Tables

Databricks Autoloader

Kafka

Spark Streaming

CI/CD (Azure DevOps, GitHub Actions, GitLab CI)

Job description

Join a company that’s leading the way in AI and automation consulting. Our portfolio spans 10+ top technologies across business applications, data, process, cloud, and AI. At Bits In Glass, you’ll do meaningful work with a supportive, driven team that loves to collaborate and celebrate wins together. Whether you’re coding, consulting or bringing bold ideas to the table, you’ll tackle real business challenges, grow your skills, and make a BIG impact.

Our growing team has earned global recognition as a Great Place to Work and received multiple industry partner awards—while keeping things fun and people-focused. If you’re looking to deepen your expertise and solve real-world problems, Bits In Glass could be the place for you.

We’re seeking a Senior Data Engineer to join our Delivery Team. In this role, you’ll design and implement modern data architectures that enable our clients to make data-driven decisions. You’ll lead the strategy, design, and technical direction of scalable data ecosystems across cloud platforms — ensuring integration, performance, and compliance.

As a Senior Data Engineer, you’ll work closely with business stakeholders, data engineers, and analytics teams to design data solutions that align with client goals.

Responsibilities:

• Design and implement end-to-end data architectures, including data lakes, data warehouses, and analytics platforms.
• Define data integration and transformation strategies, ensuring scalability, security, and performance.
• Collaborate with stakeholders to translate business requirements into technical solutions that support analytics, reporting, and AI initiatives.
• Develop data models, ETL/ELT pipelines, and frameworks for structured and unstructured data.
• Provide technical leadership and mentorship to data engineers and developers, promoting best practices in data management and governance.
• Ensure compliance with data governance, security, and privacy standards across platforms.
• Optimize existing data architectures and processes for improved performance and reliability.
• Stay current with industry trends, cloud data services, and emerging technologies such as Databricks, Snowflake, Azure Synapse, and AWS Redshift.
• Act as a trusted advisor to clients, guiding them on architecture decisions and best practices for data modernization.

Required Skills & Experience

• 5+ years of experience in data architecture, data engineering, or analytics solution design.
• Hands‑on experience with data lake and warehouse technologies (e.g., Databricks, Snowflake, Redshift, Synapse).
• Deep understanding of data modeling, data integration, and ETL/ELT design.
• Proficiency in SQL and one or more programming languages (Pyspark/Python, Scala), particularly for complex data transformations and optimization within Spark
• Solid understanding of data governance, security, and privacy best practices.
• Proven experience in designing, implementing, and optimizing large-scale ingestion pipelines using Databricks Autoloader
• Deep practical knowledge of building and managing reliable, self‑managing ETL/ELT pipelines using Delta Live Tables
• Experience in building high‑throughput, low‑latency streaming data ingestion solutions using Apache Kafka, Spark Structured Streaming, and Databricks Streaming
• Extensive experience in successfully applying and enforcing the Medallion architecture (Bronze, Silver, Gold layers) within a Databricks environment
• Experience in designing and implementing CI/CD pipelines (using tools like Azure DevOps, GitHub Actions, GitLab CI) specifically tailored for Databricks workflows, notebooks, and cluster configurations, enabling automated deployment and testing
• Experience in planning and executing data migration projects from traditional data warehouses into the Databricks Lakehouse
• Strong working knowledge of at least one major cloud provider (AWS, Azure) regarding data storage, networking, and security concepts relevant to Databricks deployment.
• Proven ability to engage with clients, present technical solutions, and communicate complex ideas clearly.
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field.
• Excellent problem-solving, communication, and collaboration skills.

Nice to Have:

• Experience with AI/ML integration and data science workflows.
• Knowledge of data cataloging and metadata management tools.
• Prior consulting or client‑facing experience in a technology services firm.

BIG is a high growth Cloud Consulting firm with offices in Edmonton, Calgary, Toronto, Denver, India and the United Kingdom. Our clients are in Canada, UK, India and the US. We are a team of experienced IT professionals who specialize in providing business value to organizations looking at leveraging modern platforms such as Pega, Appian, MuleSoft and Boomi. Our vast experience in the IT industry and our current track record in enterprise software development, allow us to provide a full range of services to our clients. Bits In Glass helps organizations of all sizes to automate their businesses and leverage the power of the web and mobile technologies.