Data Engineer

Job Posting Title: Data Engineer - Contractor

NS Job Title: Data Engineer

Experience: 7+ years

Position Summary

Seeking an experienced Databricks Engineer to support the modernization of our enterprise data platform as part of our cloud transformation journey. The ideal candidate will design, develop, and optimize scalable data solutions on the Databricks Lakehouse Platform while enabling advanced analytics, AI/ML initiatives, and enterprise-wide data products.

This role will work closely with Data Architects, Data Scientists, Business Intelligence teams, and business stakeholders to deliver high-quality, governed, and reusable data assets supporting Operations, Transportation, Finance, Asset Management, Safety, and Corporate Services.

Key Responsibilities

Data Engineering & Development

• Design, build, and maintain scalable data pipelines using Databricks, PySpark, and Spark SQL.

• Develop ETL/ELT processes that ingest, transform, and curate large-scale structured and unstructured datasets.

• Implement and support Medallion Architecture (Bronze, Silver, Gold layers).

• Develop Delta Lake-based solutions with optimized performance and data quality controls.

• Build batch and near real-time data processing solutions leveraging Spark Streaming and Kafka.

• Create reusable frameworks and automation for data ingestion, monitoring, and orchestration.

Databricks Platform Management

• Develop and maintain Databricks notebooks, workflows, jobs, and clusters.

• Implement and manage Unity Catalog, access controls, and data governance standards.

• Configure Delta Live Tables (DLT) and streaming pipelines.

• Support environment promotion across Dev, QA, UAT, and Production.

• Collaborate with platform teams on performance tuning and cost optimization initiatives.

Cloud & Integration

• Integrate data from multiple enterprise sources including:

• SAP

• Teradata

• Mainframe

• DB2

• SQL Server

• Oracle

• Tibco

• Kafka

• REST APIs

• Design and implement cloud-native integrations supporting client data modernization strategy.

• Work with Azure and AWS cloud services supporting Databricks workloads.

Data Quality & Governance

• Implement data validation, reconciliation, and monitoring controls.

• Develop automated data quality frameworks and exception handling.

• Support data lineage, metadata management, and governance initiatives.

• Ensure compliance with enterprise security and regulatory requirements.

Collaboration & Leadership

• Engage with business teams to understand analytics requirements and translate them into scalable technical solutions.

• Work closely with Data Scientists and BI developers to enable advanced analytics and reporting.

• Mentor junior data engineers and establish engineering best practices.

• Participate in Agile ceremonies and contribute to solution design discussions.

Required Qualifications{

Experience: 7+ years.

Technical Skills

• Databricks

• Databricks Workspaces

• Databricks Notebooks

• Databricks Jobs & Workflows

• Delta Lake

• Delta Live Tables (DLT)

• Unity Catalog

• Databricks SQL

• Databricks Asset Bundles (preferred)

Data Engineering

• PySpark

• Spark SQL

• Python

• SQL

• ETL/ELT Development

• Data Modeling

• Data Warehousing Concepts

Streaming & Messaging

• Apache Kafka

• Spark Streaming

• Event-driven Architectures

Cloud Platforms

• Azure Databricks

• Azure Data Factory

• ADLS Gen2

• Azure Key Vault

• AWS S3

• IAM

• Cloud Data Services

Databases

• Teradata

• SQL Server

• Oracle

• DB2

• BigQuery (preferred)

• Snowflake (preferred)

DevOps

• Git

• CI/CD Pipelines

• Azure DevOps

• GitHub Actions

• Infrastructure as Code (preferred)

Preferred Qualifications

• Databricks Certified Data Engineer Associate or Professional.

• Azure Data Engineer Associate certification.

• Experience supporting Large Enterprise Data Modernization programs.

• Experience migrating workloads from Teradata or legacy platforms to Databricks.

• Familiarity with SAP Datasphere, SAP BW, or SAP BDC integrations.

• Exposure to AI/ML workloads and feature engineering on Databricks.

Soft Skills

• Strong analytical and problem-solving skills.

• Ability to communicate technical concepts to business stakeholders.

• Strong collaboration and teamwork skills.

• Self-motivated with the ability to work independently.

• Continuous learning mindset and passion for modern data technologies.