> Markdown version of [/jobs/ext/2166015-mid-senior-data-engineer](https://www.wearedevelopers.com/jobs/ext/2166015-mid-senior-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Mid-Senior Data Engineer - **Company:** Motion Recruitment Partners LLC. - **Location:** United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Microsoft Azure, Business Software, Cloud Database, Code Review, Continuous Integration, Data Transformation, Data Systems, Data Warehousing, Database Queries, Software Debugging, Python (Programming Language), Operational Data Store, Operational Databases, DataOps, Azure Data Lake, Reverse Engineering, SQL Databases, Systems Integration, Scripting, Azure Data Factory, Snowflake, Git, Infrastructure Automation Frameworks, Maintaining Code, Terraform, Data Pipelines, Key Vault, Legacy Systems - **Published:** August 21, 2026 - **Apply:** https://www.dice.com/job-detail/854a1106-973e-4a8f-9a8e-336fef374dc0 ## About the Role * Strong SQL skills, including complex joins, window functions, aggregations, NULL handling, and understanding of data grain * Hands-on Python development experience, including maintaining code running in production * Professional experience building or supporting production data pipelines * Experience with a modern data transformation framework; dbt strongly preferred * Strong understanding of dimensional data modeling, including: + Fact and dimension tables + Data grain + Conformed dimensions + Slowly changing dimensions * Experience supporting production environments, including deployments, monitoring, environment management, troubleshooting, and incident response * Strong experience with Git, pull requests, code reviews, and CI/CD * Ability to independently investigate and debug unfamiliar technical problems * Strong communication skills and ability to work across technical and business teams * Comfortable contributing within an established architecture and engineering environment Preferred Qualifications * Experience with Snowflake * Experience with Microsoft Azure * Familiarity with Azure Data Factory (ADF), ADLS Gen2, and/or Key Vault * Terraform or other Infrastructure-as-Code experience * Experience working with multi-tenant or customer-facing data * Experience integrating with or reverse-engineering legacy and third-party systems * Familiarity with BI, analytics, and downstream data consumption patterns * Experience working with supply chain, transportation, warehousing, logistics, or other operational data AI & Modern Engineering The engineering team incorporates AI-assisted tools into its development and problem-solving workflows. Candidates should be comfortable using AI tools thoughtfully to: * Investigate unfamiliar codebases, schemas, documentation, and systems * Research and evaluate potential technical approaches * Automate repetitive engineering tasks and workflows * Improve development and troubleshooting efficiency * Build custom scripts, tools, agents, or other AI-assisted workflows Candidates should also understand the limitations of AI-generated output and be able to explain how they verify results, identify incorrect assumptions, and validate technical solutions before putting them into production. ## Description Our client is a growing organization seeking a Data Engineer to join its expanding technology team. This is a hands-on role focused on building and maintaining production data solutions, supporting critical data operations, and improving the reliability and scalability of the overall data environment. The ideal candidate is a strong hands-on engineer who enjoys working with production systems, troubleshooting unfamiliar problems, and taking ownership of data pipelines and operational processes. What You'll Be Doing * Design, build, and maintain production-grade data pipelines and transformations * Develop and maintain reliable data models supporting reporting, analytics, and business applications * Work extensively with SQL, Python, dbt, and cloud-based data technologies * Own day-to-day production data operations, including orchestration, scheduled refreshes, monitoring, and alerting * Troubleshoot pipeline failures, data quality issues, and other production incidents * Support database administration activities, including user access, roles, permissions, performance, and maintenance * Manage data deployments and contribute to CI/CD and infrastructure automation * Investigate unfamiliar or poorly documented data sources and determine how systems, schemas, and integrations function * Build data solutions supporting reporting, billing, customer, and operational use cases * Integrate and work with data from internal, third-party, and legacy systems * Partner with engineering, product, operations, and business teams to translate requirements into technical solutions * Participate in code reviews and contribute to engineering standards and best practices * Improve documentation, knowledge sharing, and overall platform reliability ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Best Practices for Using GitHub Secrets](https://www.wearedevelopers.com/videos/1214-best-practices-for-using-github-secrets) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Stop Committing Your Secrets - GIt Hooks To The Rescue!](https://www.wearedevelopers.com/videos/573-stop-committing-your-secrets-git-hooks-to-the-rescue) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts) - [Transforming Software Development: The Role of AI and Developer Tools](https://www.wearedevelopers.com/magazine/527-transforming-software-development-the-role-of-ai-and-developer-tools)