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.
