> Markdown version of [/jobs/ext/2144509-project-lead-data-analytics](https://www.wearedevelopers.com/jobs/ext/2144509-project-lead-data-analytics). 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).

---

# Project Lead (Data Analytics)

- **Company:** Dts, Inc
- **Location:** Detroit, MI, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Access, Microsoft Excel, Data Analysis, Big Data, Data Discovery, Data Mining, Relational Databases, Database Design, Database Queries, Excel Formulas, PostgreSQL, Microsoft SQL Server, MySQL, Performance Tuning, Pivot Tables, Powerpivot, SQL Databases, Powerquery, Information Technology, Vba Programming Language, Dynamic Data
- **Published:** August 20, 2026
- **Apply:** https://www.dice.com/job-detail/2099c71a-0185-4866-a15c-e1cf03dcec2a

## About the Role

Advanced Excel (pivot tables, Power Query, Power Pivot, complex formulas) - 3+ years of handson analytical work.
Microsoft Access (database design, queries, VBA automation) - proven ability to build and maintain relational databases.
SQL (efficient query writing, data extraction, performance tuning) - experience with major RDBMS such as SQL Server, PostgreSQL, MySQL, etc.
VBA (macro development, automation of repetitive tasks) - demonstrated automation projects that saved time/effort., Strong initiative: history of launching independent analytical or processimprovement projects.
Thirst for knowledge: continuous learning through courses, certifications, or selfstudy.
Passion for problem solving: examples of tackling ambiguous business challenges and delivering solutions.
Love of data exploration: portfolio of exploratory analyses, visualizations, or sandbox projects.
Ability to gather knowledge quickly: experience leading discussions in unfamiliar domains and gaining expertise rapidly.
Comfort in lowknowledge meetings: skill at steering meetings, asking insightful questions, and synthesizing outcomes despite limited prior knowledge., Minimum of 5 years of related experience preferred.
Bachelor's degree in Business, Computer Science, Data Science, Economics, Engineering, or a related field preferred.
Key Success Factors

High proficiency in project management and data analysis tools.
Ability to manage both project delivery and exploratory analytics simultaneously.
Creative thinking and strong communication skills to bridge technical and business worlds.
Commitment to mentorship, knowledge sharing, and continuous improvement.

## Description

We are looking for a highly motivated, curiositydriven professional who can both lead application/system implementation projects and conduct deepdive data analysis. The ideal candidate blends strong project management expertise with advanced technical skills in Excel, Access, SQL, and VBA, and thrives on turning ambiguous business questions into actionable insights. This role requires overseeing the full project lifecycle, managing client relationships, and delivering datacentric solutions while continuously learning new domains.
Core Responsibilities
Project Management
Initiate, plan, execute, control, and close application and system implementation projects using a formal methodology.
Manage one moderatesize project or multiple small projects concurrently, developing detailed plans, schedules, risk registers, and resource allocations.
Monitor project metrics for deviations in quality, cost, or schedule and ensure adherence to PMO policies and PMI standards.
Coach and mentor project team members, providing performance feedback to their leaders.
Oversee client/customer relations to define and meet service expectations.
Data Discovery & Exploration
Conduct deepdive analyses on large, complex datasets using Advanced Excel (pivot tables, Power Query, Power Pivot, complex formulas), Microsoft Access (database design, queries, VBA automation), and SQL.
Build and maintain dynamic data models, dashboards, and automated reporting tools that evolve with new questions.
InitiativeDriven Projects
Identify gaps, inefficiencies, or untapped potential within business processes and propose datacentric solutions.
Own endtoend project lifecycles-from hypothesis formation to delivery-without waiting for direction.
Domain Expert Engagement
Lead interviews, workshops, and brainstorming sessions with subjectmatter experts across finance, operations, marketing, product, and other areas, even when the topic is unfamiliar.
Synthesize expert knowledge into clear, datadriven recommendations and actionable roadmaps.
Problem Solving & Innovation
Tackle ambiguous, "wicked" problems by breaking them into manageable analytical tasks.
Experiment with new analytical techniques, tools, or data sources and share findings with the broader team.
Knowledge Acquisition & Sharing
Rapidly learn new business domains, industry terminology, and technical concepts; document insights for future reference.
Mentor junior analysts on effective data exploration methods and the art of asking the right questions.
Meeting Leadership
Facilitate and drive discussions in meetings where you may have limited prior subjectmatter expertise, ensuring productive outcomes and clear next steps.
Translate technical findings into businessfriendly language for stakeholders at all levels.


## Related Videos

- [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology)
- [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)
- [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data)
- [Coding for Good: Achieving social change with an app](https://www.wearedevelopers.com/videos/1645-coding-for-good-achieving-social-change-with-an-app)

## Related Articles

- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)