Quick overview
Job description
Mactores is the agent-native AWS modernization firm. Most modernization work doesn't ship, it stalls in pilots, slips a year, or lands at three times the budget. We exist to ship it: production systems running, legacy retired, outcomes measured. Our delivery is built on Aedeon, the agent platform built by Mactores' founders' sister company, which absorbs the repetitive 60–70% of engagement work, discovery, dependency mapping, validation, test generation, that traditional consulting bills human hours against. Forward-deployed engineers own the rest: architecture, judgment, and cutover, on dates we commit to in the contract.
This role sits in our Data Platform Modernization pillar: consolidating and migrating customer data infrastructure on AWS in weeks, not quarters. Customers come to us with pipelines nobody trusts, metrics nobody agrees on, and warehouses that stall every new business question. You'll build the data products that fix that — working with business leads, analysts, and data scientists to understand the domain, then shipping pipelines and models that hold up in production.
Because Aedeon handles the repetitive layer source discovery, schema mapping, validation harnesses — you won't spend your early career grinding through spreadsheet audits. You'll spend it writing code that reaches production and learning judgment from engineers who own cutovers. Data quality isn't a checkbox here; it's the product.
What you will do?
- Write efficient PySpark and Amazon Glue code that ships to production.
- Write SQL in Amazon Athena and Amazon Redshift.
- Pick up new technologies and techniques and put them to work on real business problems.
- Work across engineering and business teams to build data products and services people actually use.
- Deliver projects with the team and land customer updates on time.
What are we looking for?
- 1 to 3 years of experience in Apache Spark, PySpark, and Amazon Glue.
- 2+ years of experience writing ETL jobs using PySpark and SparkSQL.
- 2+ years of experience with SQL queries and stored procedures.
- Deep understanding of the Dataframe API and the transformation functions supported by Spark 2.7+.
You will be preferred if you have
- Prior experience in working on AWS EMR, Apache Airflow
- Certifications AWS Certified Big Data – Specialty OR Cloudera Certified Big Data Engineer OR Hortonworks Certified Big Data Engineer
- Understanding of DataOps Engineering
How we work?
Haystack's AI agent can fill in and submit this application for you. How AI auto apply works
Similar jobs
- AG

Staff Data EngineerRecently posted Auto Apply
Agiloft · United States · Remote · Posted 13 Nov 2026 🇺🇸
Talent AcquisitionAWSAirflow+3TechnologySalary not listed - HI

Data Conversion Lead (1657)Recently posted Auto Apply
Highstreetit · United States · Hybrid · Posted 13 Nov 2026 🇺🇸
Stakeholder ManagementOracleSQL+5Salary not listed - CB

IT Data Science Principal (Data Warehouse)Recently posted Auto Apply
Cornerstone Building Brands · Cary, NC · Remote · Posted 12 Nov 2026 🇺🇸
Stakeholder ManagementPL/SQLSQL+8Technology$120k - $140k/yr - SG
Lead Data Engineer (Lakehouse / Databricks)Recently posted Auto Apply
Stafford Gray · Lansing, Michigan · Hybrid · Posted 13 Nov 2026 🇺🇸
DockerGCPSQL+15TechnologySalary not listed - MI
Data Engineering Solution Lead - RemoteRecently posted Auto Apply
Mindex · Rochester, New York · Remote · Posted 13 Nov 2026 🇺🇸
MongoDBSQLETL+5$105k - $155k/yr - MI
Data Engineer - RemoteRecently posted Auto Apply
Mindex · Rochester, New York · Remote · Posted 13 Nov 2026 🇺🇸
MongoDBSQLETL+4Technology$90k - $140k/yr - V4
Databricks Engineer (Remote, US)Recently posted Auto Apply
V4C.ai · United States · Remote · Posted 13 Nov 2026 🇺🇸
GCPSQLApache Spark+12EngineeringSalary not listed - V4
Lead Data Engineer, Databricks (Remote, US)Recently posted Auto Apply
V4C.ai · United States · Remote · Posted 13 Nov 2026 🇺🇸
GCPSQLGit+12TechnologySalary not listed - ZI
Data Engineer (Clinical)Recently posted Auto Apply
Zifo · United States · Remote · Posted 13 Nov 2026 🇺🇸
FastAPIGCPMongoDB+24TechnologySalary not listed - VT

Senior DataOps EngineerRecently posted Auto Apply
Voyager Technologies, Inc. · Remote - United States · Remote · Posted 12 Nov 2026 🇺🇸
DockerSQLT-SQL+27Technology$140k - $180k/yr - PA

Staff Biomedical Data ManagerRecently posted Auto Apply
PathAI · 1325 Boylston Street · Hybrid · Posted 13 Nov 2026 🇺🇸
Medical TerminologyHealthcare$108.8k - $166.8k/yr - GA

Senior Data EngineerRecently posted Auto Apply
Gatik AI · Santa Clara · Hybrid · Posted 13 Nov 2026 🇺🇸
SQLApache SparkAWS+12Technology$180k - $260k/yr
