FiveTran Engineer

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2

Skills

Fivetran
ETL
Cloud
MDM

Job Details

Job Title: Fivetran Engineer Master Data Management (MDM) Location: California (Remote/Hybrid options available) Contract
Job Summary:
We are seeking a skilled and proactive Fivetran Engineer to join our Master Data Management (MDM) team. This role is pivotal in designing and maintaining scalable data pipelines that support enterprise-wide master data initiatives. The ideal candidate will have deep expertise in Fivetran, cloud data platforms, and MDM principles, and will collaborate across teams to ensure high-quality, governed data is available for analytics and operational use.
Key Responsibilities:

  • Develop and maintain automated ELT pipelines using Fivetran to ingest master data from systems such as SAP, Salesforce, and Oracle.

  • Integrate Fivetran pipelines with cloud data platforms like Snowflake, BigQuery, and Azure Synapse.

  • Collaborate with data stewards and business teams to enforce data quality rules and support golden record creation.

  • Implement monitoring and observability solutions to ensure pipeline health and data accuracy.

  • Optimize transformation logic using DBT and SQL for performance and scalability.

  • Document data flows, mappings, and transformation logic for compliance and audit purposes.

  • Support reporting and analytics needs through integration with BI tools like Power BI and Tableau.

  • Work closely with product managers, architects, and analysts to align technical solutions with business goals.

Required Skills:

  • Fivetran Expertise: Experience configuring and managing Fivetran connectors and transformations.

  • SQL Mastery: Advanced SQL skills for data extraction, transformation, and validation.

  • Cloud Data Platforms: Hands-on experience with Snowflake, BigQuery, Redshift, or Azure Synapse.

  • MDM Concepts: Understanding of master data domains and governance workflows.

  • Python & DBT: Proficiency in Python scripting and DBT for modular pipeline design.

  • Data Quality & Governance: Familiarity with tools like Informatica MDM, Monte Carlo, or Collibra.

  • Metadata & Cataloging: Experience with metadata repositories and lineage tracking.

  • BI Tools: Ability to support dashboards and reports using Power BI, Tableau, or Google Data Studio.

  • DevOps & Automation: Knowledge of CI/CD pipelines, Git, and infrastructure-as-code tools.

  • Collaboration: Strong communication and documentation skills; ability to work cross-functionally.

Preferred Qualifications:

  • Bachelors or Masters degree in Computer Science, Information Systems, or related field.

  • 5+ years of experience in data engineering or analytics roles.

  • Prior experience implementing MDM solutions and working with enterprise data architectures.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.