Data Engineer

About the Role

We're looking for a Data Engineer to build and maintain the cloud data platforms that power analytics, BI, and AI/ML for our clients. You'll move raw, fragmented data into clean, reliable, query-ready form on Snowflake and Databricks - supporting everything from customer-360 dashboards to real-time decision-making.

Key Responsibilities

Build, test, and maintain ELT/ETL pipelines using Matillion, Fivetran, and Azure Data Factory (ADF) to ingest data from databases, APIs, files, and SaaS sources.

Develop data transformations and workloads on Snowflake and Databricks.

Develop and maintain SSIS ETL packages and jobs for data integration and scheduled workloads.

Configure and manage Fivetran connectors, including Salesforce integration into the data warehouse.

Develop and optimize SQL transformations and data models for analytics and reporting.

Work with AWS, including managing data in S3 (staging, ingestion, and storage).

Write clean, reusable Python for data processing, automation, and pipeline logic.

Support data quality, validation, and monitoring for downstream BI (Power BI/Tableau) and ML teams.

Track and manage work through Jira workflows; partner with analysts and client stakeholders on requirements.

Document pipelines, data definitions, and processes.

Must-Have Skills

1–3 years of hands-on data engineering experience.

Azure Data Factory (ADF) - building and orchestrating pipelines.

Databricks - hands-on development of transformations/workloads.

Matillion - building ELT pipelines.

Fivetran - configuring and managing connectors.

Snowflake - hands-on data modeling and transformation.

Strong SQL and solid working knowledge of Python.

Understanding of data warehousing concepts, ETL/ELT, and dimensional modeling.

Good to Have

Experience with SSIS packages and jobs.

Salesforce data integration via Fivetran.

AWS S3 experience.

Exposure to Redshift or Synapse.

BI tools (Power BI, Tableau).

Familiarity with Jira workflows.

Exposure to data for AI/ML workflows.

What We Look For

Curiosity, ownership, and a problem-solving mindset; comfort in a consulting/client-delivery environment; clear communication and a willingness to learn fast.