Modus Create
Posted 6mo ago

Mid/Senior Data Engineer — Data Platforms & ERP Integration (Contract Role)

Modus Create
United States or South America
RemoteContract
Responsibilities
  • building pipelines
  • designing platforms
  • ensuring governance
Requirements
  • 4+ years data engineering experience with Python/PySpark
  • Strong SQL
  • Databricks (Delta Lake
  • Unity Catalog)
  • AWS (S3, IAM, VPC)
  • ERP integrations (Oracle/SAP/Microsoft Dynamics)
  • Data modeling
  • Data quality, and experience using AI/LLM tools
Technical tools mentioned
PythonPySparkSQLDatabricksDelta LakeUnity CatalogDatabricks WorkflowsSQL WarehouseS3IAMVPCOracleSAPMicrosoft DynamicsdbtAWS GlueDatazoneApache AtlasDatabricks Asset BundlesApache IcebergDelta Lake UniFormYAMLCI/CDLLM

Job description

About Us

Founded in 2011, Modus is a global, fully remote team of world-class technologists who thrive in a collaborative, innovative environment. We're a digital product engineering partner for forward-thinking businesses. Our global teams work side-by-side with clients to design, build, and scale custom solutions that achieve real results and lasting change, partnering with industry leaders including AWS, GitHub, and Atlassian.

We were fully remote before it was cool! Recognized as one of the Inc. 5000 Fastest Growing Private Companies for nine years and a top remote work company by FlexJobs, we have helped some of the world's largest brands deliver powerful digital experiences.

The Opportunity

We are looking for a Mid/Senior Data Engineer to join our Data Engineering practice and help clients build modern data foundations on Databricks and AWS.

You will design and build data pipelines that extract from enterprise ERP systems, transform through medallion architectures, and deliver governed, AI-ready data products. You will work directly with client subject-matter experts to understand business domains, validate data models, and ensure the platform is production-grade from day one.

Current engagements involve regulated manufacturing environments where data governance, quality management, and traceability are essential.

This is a fully remote role with collaboration across distributed teams and daily overlap with the US Eastern Time Zone.

Requirements

  • 4–7+ years of experience as a Data Engineer or in a closely related role
  • Strong programming skills in Python, including PySpark
  • Solid SQL skills including complex analytical queries against large enterprise databases
  • Hands-on experience with Databricks: Delta Lake, Unity Catalog, Databricks Workflows, and SQL Warehouse
  • Working knowledge of AWS core services: S3, IAM, VPC, and networking fundamentals
  • Experience building ETL/ELT pipelines that extract from enterprise ERP or transactional systems (Oracle, SAP, Microsoft Dynamics, or similar)
  • Strong understanding of data modeling, medallion architectures, and dimensional design
  • Experience with data quality frameworks: validation rules, anomaly detection, and exception handling
  • Experience using AI and LLM tools to accelerate engineering workflows — including deriving data contracts, mapping specifications, and schema documentation from database metadata and limited business context
  • Comfortable collaborating directly with business stakeholders and subject-matter experts, not just engineering teams
  • Ability to participate in technical discussions, code reviews, and architectural decisions with confidence
  • Reliable high-speed internet and ability to work effectively in a remote-first environment
  • Daily overlap with US Eastern Time Zone

Bonus Points

  • Familiarity with Oracle E-Business Suite table structures and data patterns (INV, PO, BOM, WIP modules)
  • Exposure to manufacturing domain concepts: bills of material, work orders, production routing, inventory management
  • Experience with dbt for data transformation and data product development
  • Hands-on experience with data governance and catalog tooling (Unity Catalog, AWS Glue/Datazone, Apache Atlas, or similar)
  • Multi-system data integration or ERP consolidation experience, reconciling different source schemas into a unified canonical model
  • Spec-driven or contract-driven development methodology, YAML specifications, schema validation, data contracts
  • Experience in medical device, pharmaceutical, or other regulated manufacturing environments
  • Databricks Asset Bundles and CI/CD automation for data platform deployments
  • Familiarity with Apache Iceberg or Delta Lake UniForm for open table format interoperability
  • Experience supporting AI/ML workflows in production: feature engineering, model serving integration, or AI-ready data product design

You'll Love

  • Building data foundations that power AI, analytics, and operational decision-making for manufacturing enterprises
  • Working directly with domain experts to understand how real businesses operate, not just pushing data through pipes.
  • Solving multi-system integration challenges where no two ERPs store data the same way
  • Designing platforms with governance, observability, and data quality built in from the outset.
  • Contributing to a reusable platform accelerator that will be deployed across multiple client engagements
  • Raising the bar for how data engineering is done: spec-driven, tested, version-controlled, and production-grade

About the Team

Our Data Engineering practice works with clients across regulated industries to design and deliver modern data platforms. Current engagements include multi-ERP data consolidation on Databricks, AI-ready data foundations for manufacturing, and enterprise data governance implementations. The team operates with a high degree of autonomy, strong engineering discipline, and a bias toward simplicity over complexity.

By joining our team, you'll be part of a group that values precision, honest communication, and delivering work that stands up to scrutiny. Apply now and show us you've got what it takes to build data platforms that matter.

 

About Modus Create

Provides digital transformation and product engineering consulting services.

Year founded
2011
Employees
500
Organization type
Private
Latest investment
Private Equity (2021) — led by JLL Partners
Headquarters
US

Similar jobs

Data Engineer roles
6h
Save
Mark Applied
Hide
Data Engineer -- Regulatory Reporting & Portfolio Intelligence
Bangalore or San Francisco or Singapore
HybridFull Time
Nium
Nium: Provides infrastructure for real-time cross-border payments and card issuance
3+ YOE3–5 years in data engineering, ETL/ELT, or systems integration; strong SQL and Python; REST/SOAP, XML/JSON, cloud data platforms, orchestration, data modeling, quality testing, and regulatory reporting knowledge.
SQL, Python, XML, REST API, SOAP, JSON, AWS Redshift, Snowflake, Google BigQuery, Amazon S3, Google Cloud Storage, Apache Airflow, Prefect, Kafka, AWS
8h
Save
Mark Applied
Hide
GCP Senior Data Engineer (139951)
United States
OnsiteFull Time
HCLTech
HCLTechNational Stock Exchange of India: HCLTECH: Global provider of information technology services and software consulting.
5+ YOEBachelor’s or master’s degree in computer science, IT, or a related field; 5–6+ years of data engineering experience; strong GCP, data pipeline, ETL/ELT, data warehousing, Python, and SQL expertise.
Google Cloud Platform (GCP), Dataflow, BigQuery, Pub/Sub, Cloud Storage, Cloud SQL, Firestore, Python, SQL, Hadoop, Spark, Machine Learning, AI, DevOps, CI/CD
11h
Save
Mark Applied
Hide
Data Engineer
Plano or Teaneck
$65k/yr OnsiteFull Time
Cognizant
CognizantNASDAQ: CTSH: Provides IT consulting and technology services to global enterprises.
Bachelor's or master's degree in a related field; Python and SQL skills; data orchestration, cloud, data architecture, containerization, CI/CD, analytical, problem-solving, and communication skills.
Python, SQL, Apache Spark, AWS, Microsoft Azure, Google Cloud Platform (GCP), Apache Airflow, Prefect, Snowflake, Databricks, BigQuery, Docker, Kubernetes, GitHub
11h
Save
Mark Applied
Hide
Staff Data Engineer
New York City, New York, United States
OnsiteFull Time
Bags.fm
Bags.fm: Building a Solana-native launchpad for projects and creators.
Experienced data engineer skilled in SQL, Python, distributed systems, cloud infrastructure, high-volume batch and real-time pipelines, data modeling, architecture, and technical leadership.
SQL, Python, Apache Spark, Apache Kafka, Apache Airflow, dbt, ClickHouse, Google BigQuery, Snowflake, Omni, Looker, Dagster
11h
Save
Mark Applied
Hide
Data Engineer
Durham, North Carolina, United States
OnsiteFull Time
BioAgilytix
BioAgilytix: Bioanalytical services for pharmaceutical and biotech drug development.
5+ YOEBachelor’s degree in a related technical field, 5+ years of relevant experience, and hands-on expertise with Snowflake, dbt, SQL, Python, enterprise data modeling, ELT pipelines, cloud platforms, and regulated data environments.
Snowflake, dbt Cloud, dbt Core, SQL, Python, Talend, Fivetran, REST APIs, GraphQL APIs, Change Data Capture (CDC), AWS, S3, Lambda, ECS, Glue, Azure, Snowpark, Dynamic Tables, Streams, Tasks, Git, GitHub Actions, CI/CD, Infrastructure-as-Code, DataOps, Power BI, Sigma, Tableau
12h
Save
Mark Applied
Hide
Data Engineer
Plano or Teaneck
$65k/yr OnsiteFull Time
Cognizant
CognizantNasdaq: CTSH: Provides global information technology and business process outsourcing services.
Bachelor's or master's degree in a relevant field; Python and SQL skills; data pipelines, orchestration, cloud, data architecture, containerization, CI/CD, and ETL/ELT knowledge.
Python, SQL, Spark, AWS, Azure, GCP, Airflow, Prefect, Snowflake, Databricks, BigQuery, Docker, Kubernetes, GitHub, JSON, XML, ETL, ELT, CI/CD
15h
Save
Mark Applied
Hide
Senior Data Engineer-SQL/Azure
Missouri, United States
$101k-$162k/yr RemoteFull Time
H&R Block
H&R Block: A tax services combining human expertise with digital innovation.
5+ YOEBachelor’s degree or equivalent, 5+ years building production-grade software, Azure data technologies, SQL, data architecture, CI/CD, DevOps, cloud infrastructure, and strong communication skills.
Microsoft Fabric, Azure Data Services, Data Lakes, SQL, CI/CD, DataDog, Microsoft Purview
15h
Save
Mark Applied
Hide
Senior Data Engineer-SQL/Azure
Missouri, United States
$101k-$162k/yr RemoteFull Time
H&R Block
H&R BlockNYSE: HRB: Provides income tax preparation and small business financial services.
5+ YOEBachelor’s degree or equivalent, 5+ years building production-grade software, Azure data technology experience, SQL proficiency, software engineering fundamentals, CI/CD, DevOps, cloud infrastructure, and strong communication skills.
Microsoft Fabric, Azure Data Services, Data Lakes, SQL, DataDog, Microsoft Purview, CI/CD, DevOps