Data Engineer - Southfield, MI

DTS is looking for Data Engineer for our client Position in Southfield, MI

Looking for someone with hands-on experience working in Databricks, including Unity Catalog, along with strong PySpark and SQL skills. This contractor will be supporting a recent Databricks migration, so prior experience building and operating in that environment is a key requirement.

Musts

• Strong with Databricks
• Experienced with Unity Catalog

 
In talking to candidates, I'm finding some have data pipeline building experience but lack fundamentals and knowing basic join functions in SQL. They should be able to explain the difference between an inner-join and a left outer join on the table. In screening questions like that should be easy for them to answer. 
 

Job Description
we solve the most complex and critical challenges by moving quickly from analysis to action when it really matters; creating value that has a lasting impact on companies, their people, and the communities they serve. By understanding, respecting, and honoring the needs of our employees, clients, and communities, client actively promotes an inclusive environment. We strongly believe in the value that diversity brings to our experiences and are committed to the perpetual enhancements of initiatives, policies, and practices. We hold ourselves accountable by providing the space for authenticity, growth, and equity for everyone.
client has embraced a hybrid work model to provide flexibility and support our employees’ work-life integration. 

What you’ll do
In this hands-on senior engineering role on the IT Data Insights & Analytics (DIA) team, you will provide significant technical influence across the data platform and work closely with the Data Engineering and Solutions Design leads. While the role does not have direct people management, it requires strong ownership, judgment, and collaboration skills.

You care about doing things well and finding the best solutions - not just checking off boxes. You’re a strong teammate and collaborator with engineers, analysts, QA, IT partners, and business stakeholders. You bring a modern, pragmatic perspective - and a good attitude - to your work. You enjoy improving systems and processes, not just writing code, and are comfortable presenting your ideas and recommendations. You’re curious, open to feedback, and willing to challenge - and be challenged on - technical decisions in pursuit of better outcomes. The Data Insights & Analytics Senior Data Engineer reports to the Data Insights and Analytics Development Manager. This contract role is in Southfield, MI; remote work may be considered for highly qualified candidates. 

• Design, implement, and continuously improve scalable data architectures in Azure, Databricks, Fabric, and the enterprise data lake.
• Contribute to and evolve our Unity Catalog—based governance model, ensuring data is discoverable, secure, and usable.
• Expand and harden our Data Quality and Validation Framework (including Databricks DQX-style approaches).
• Develop and maintain resilient ingestion, transformation, and semantic pipelines that support both reporting and AI-driven use cases.
• Split time between project work, production support, quality framework enhancements, and “BAU” work (Business as Usual).
• Modernize and maintain source control, CI/CD, release management, and environment promotion strategies.
• Partner with internal teams building “ask your data” experiences, analytics copilots, and AI-enabled applications, helping them move from proof-of-concept to enterprise? Ready solutions.
• Help define patterns for safely exposing approved corporate data to business and technical partners for experimentation and production use.
• Actively explore and apply AI-assisted development tools to improve productivity, code quality, documentation, and design decisions.
• Champion automation-first, validation-first, and “shift-left” engineering and testing practices.
• Proactively identify opportunities for platform modernization and process improvement, and clearly articulate recommendations for implementation.
• Collaborate with other engineers, analysts, QA, architects, and business partners and share knowledge
• Challenge assumptions thoughtfully and respectfully when there’s a better way forward.
• Operate with ownership, accountability, and a positive, solution-oriented attitude.
• Additional responsibilities as identified. This description is not designed to encompass a comprehensive listing of required activities, duties, or responsibilities.

DTS offers excellent compensation package.