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.