Project Lead (Data Analytics)

Dts, Inc
Detroit, MI, United States
12 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Access Microsoft Excel Data Analysis Big Data Data Discovery Data Mining Relational Databases Database Design Database Queries Excel Formulas PostgreSQL Microsoft SQL Server
+9 more
MySQL Performance Tuning Pivot Tables Powerpivot SQL Databases Powerquery Information Technology Vba Programming Language Dynamic Data

Job 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.

Requirements

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.

Benefits & conditions

DTS offers excellent compensation package.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · World Congress 2026 Europe

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

Videos

See all

Related articles

See all