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
As a Data Engineer, you will be an integral part of our team, working on data pipelines, data warehousing, and data integration for various analytics and AI use cases. You will collaborate closely with Delivery Managers, ML Engineers and other stakeholders to ensure seamless data flow and accessibility. Your expertise will be crucial in enabling data-driven decision-making for our clients. To thrive in this role, you need to be a quick learner, get excited about innovation and be on the constant lookout to master new technologies as they come up in the Data, AI & Cloud realms.
Key Responsibilities
- Build and maintain scalable batch and streaming pipelines (ETL/ELT) for analytics and AI.
- Ingest data from OLTP databases, files, SaaS apps, and APIs into the lakehouse.
- Prepare data for ML and GenAI use cases with ML Engineers.
- Translate client data requirements into tailored solutions.
- Ensure data quality, security, and governance.
- Optimize cloud storage and compute for performance and cost.
- Use Databricks as the primary platform for processing and orchestration.
- Monitor, troubleshoot, and improve pipeline reliability.
- Apply best practices: version control, code review, testing, CI/CD, and documentation.
- Contribute to technical design and mentor junior team members.
Qualifications
- Education: Degree in Computer Science, Engineering, or related field, or equivalent experience.
- Experience: 3–5 years building production data pipelines.
- Programming: Strong SQL and Python (including PySpark).
- Distributed processing: Partitioning, joins, and performance tuning (e.g., Apache Spark on Databricks).
- Lakehouse architecture: Medallion architecture and open table formats (e.g., Delta Lake, Apache Iceberg).
- Declarative pipelines and orchestration: e.g., Lakeflow Spark Declarative Pipelines, Lakeflow Jobs, Airflow, dbt.
- Data ingestion: Batch, incremental, CDC, and API ingestion (e.g., Lakeflow Connect, Auto Loader, Fivetran, Azure Data Factory, AWS Glue).
- Batch and streaming: Streaming concepts such as watermarking and late data (e.g., Spark Structured Streaming).
- OLTP and OLAP: How transactional and analytical systems differ and integrate (e.g., PostgreSQL, SQL Server, Databricks Lakebase).
- Data modeling: Relational and dimensional modeling, including star schemas and SCDs.
- Data warehousing: e.g., Databricks SQL, Snowflake, BigQuery, Redshift.
- Data quality: Validation, monitoring, and alerting (e.g., pipeline expectations, Lakehouse Monitoring).
- Governance and security: Access control (RBAC/ABAC), PII masking, and lineage (e.g., Unity Catalog).
- Cloud platforms: At least one of AWS, Azure, or GCP.
- DevOps and CI/CD: Git, automated testing, CI/CD, and infrastructure as code (e.g., Databricks Asset Bundles, Terraform).
- Soft skills: Strong problem-solving, communication, and collaboration.
Highly Desirable Skills
- Vector databases: e.g., Databricks Vector Search, pgvector, Pinecone.
- GenAI data pipelines: Preparing unstructured data for RAG and AI agents (e.g., Databricks AI Functions, Agent Bricks).
- Real-time streaming: e.g., Apache Kafka, Azure Event Hubs, Amazon Kinesis.
- Operational data serving: Serving data to applications (e.g., Lakebase, FastAPI, Databricks Apps).
- ML lifecycle: Feature engineering and model tracking (e.g., MLflow, Feature Store).
- NoSQL and graph databases: e.g., MongoDB, Cosmos DB, Neo4j.
- BI and semantic layer: e.g., Unity Catalog metric views, AI/BI and Genie, Power BI, Tableau.
- Certifications: Databricks Data Engineer Associate/Professional or a cloud data certification.
- Consulting: Client-facing and Agile delivery experience.
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.
Compensation: The expected base salary range for this position is $90,000 – $110,000 CAD annually. The final offer will depend on factors such as skills, experience, certifications, and qualifications relevant to the role.
AI Disclosure: Bits In Glass uses artificial intelligence (AI) tools to help screen, assess, or select applicants for this position. All hiring decisions are reviewed and made by our recruitment team.
Skills Required
- Degree in Computer Science, Engineering, or a related field, or equivalent experience
- 3-5 years of experience building production data pipelines
- Strong SQL and Python, including PySpark
- Experience with distributed processing, partitioning, joins, and performance tuning using Apache Spark on Databricks
- Knowledge of lakehouse architecture, Medallion architecture, Delta Lake, or Apache Iceberg
- Experience with declarative pipelines and orchestration tools such as Lakeflow, Airflow, or dbt
- Experience with batch, incremental, CDC, and API data ingestion
- Knowledge of batch and streaming concepts, including watermarking, late data, and Spark Structured Streaming
- Knowledge of OLTP and OLAP systems and their integration
- Experience with relational and dimensional data modeling, star schemas, and slowly changing dimensions
- Experience with data warehousing platforms such as Databricks SQL, Snowflake, BigQuery, or Redshift
- Experience with data validation, monitoring, alerting, and data quality practices
- Knowledge of access control, PII masking, data lineage, and governance tools such as Unity Catalog
- Experience with at least one cloud platform: AWS, Azure, or GCP
- Experience with Git, automated testing, CI/CD, and infrastructure as code
- Strong problem-solving, communication, and collaboration skills
- Experience with vector databases such as Databricks Vector Search, pgvector, or Pinecone
- Experience preparing unstructured data for RAG and AI agents
- Experience with real-time streaming platforms such as Kafka, Azure Event Hubs, or Amazon Kinesis
- Experience serving operational data using Lakebase, FastAPI, or Databricks Apps
- Experience with MLflow, feature engineering, or Feature Store
- Experience with NoSQL or graph databases such as MongoDB, Cosmos DB, or Neo4j
- Experience with Power BI, Tableau, or semantic-layer technologies
- Databricks Data Engineer or cloud data certification
- Client-facing and Agile delivery experience
What We Do
Bits In Glass is an award-winning software consulting firm combining deep industry expertise and experience with the best names in technology to provide innovative solutions to your unique business challenges. Our expert consultants find the innovative solutions to solve the most complex business challenges across multiple industries and verticals. With hundreds of years of in-house experience, we are the partner of choice for many business transformation projects, working with market leaders who are disrupting and driving transformation across every aspect of modern business. Find out why leading technology companies partner with Bits In Glass including Appian (Business Process Management), Pega, MuleSoft (API-Led Systems Integration), and Blue Prism (Robotic Process Automation). We're hiring see a full list of open positions here: https://bit.ly/2U2YTUc








