Madison-Davis, LLC

Data Engineer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Engineer with a contract length of "X months" and a pay rate of "$X/hour". It requires 5+ years in Data Engineering, expertise in SQL, dbt, Databricks, and AWS, along with strong troubleshooting skills.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
640
-
🗓️ - Date
August 11, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York City Metropolitan Area
-
🧠 - Skills detailed
#PySpark #Deployment #Data Processing #"ETL (Extract #Transform #Load)" #Databricks #Snowflake #Documentation #AI (Artificial Intelligence) #AWS (Amazon Web Services) #Datasets #Code Reviews #Spark (Apache Spark) #dbt (data build tool) #Data Modeling #GitHub #SQL (Structured Query Language) #Data Engineering #Cloud #Data Pipeline #Data Quality
Role description
Ownership: • Build, enhance, and maintain production dbt models. • Extend existing dimensional models using established patterns. • Develop transformations across structured and semi-structured datasets. • Work across Silver and Gold layers within a medallion architecture. • Write and optimize complex SQL against large datasets. • Monitor and troubleshoot production data pipelines. • Investigate data quality issues and implement fixes. • Diagnose unfamiliar datasets, code, and upstream dependencies independently. • Participate in code reviews, testing, deployment, and documentation. • Coordinate with analytics engineers, data engineers, product teams, and business stakeholders during production issues. Technical Environment Core: • SQL • dbt • Databricks • AWS • GitHub Additional Environment: • Unity Catalog • PySpark • Distributed data processing • GitHub Actions / CI/CD • Dimensional modeling • Medallion architecture • Structured and semi-structured data • Production data pipelines • AI-assisted development, including GitHub Copilot Must-Haves: • 5+ years in Analytics Engineering, Data Engineering, or engineering-heavy Data Analytics. • Expert SQL with complex query development, optimization, and data modeling. • Extensive hands-on experience building and maintaining production dbt projects. • Experience with cloud-based data platforms, preferably AWS. • Modern data platform experience such as Databricks, Unity Catalog, Snowflake, or similar. • Experience supporting production data pipelines. • Strong troubleshooting and root-cause analysis skills. • Ability to investigate unfamiliar systems independently. • Strong communication across technical teams. • Evidence of writing maintainable, production-quality code. Nice-to-Haves: • Direct Databricks experience. • PySpark. • Unity Catalog. • GitHub Actions or comparable CI/CD. • Dimensional modeling. • Medallion architecture. • Business-critical reporting environments. • Comfortable using AI-assisted developer tooling