Project Lead (Data Analytics) - Detroit, MI

DTS is looking for Project Lead (Data Analytics) for our client position in Detroit, MI

Description:

Position Overview
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.
Required Technical Skills & Experience
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.
Core Attributes
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.
Qualifications
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.

DTS offers excellent compensation package.

Contact:

Harmandeep

Digital Technology Solutions