Technical Project Lead - Data and Analytics

Collectiv; Chicago (IL); Remote; USD 120,000 - 160,000; Full time

Benefits offered by this job

Unlimited time off

100% paid health insurance (medical, 2

Job summary

Collectiv invites a results-driven Project Lead Consultant to guide data and AI initiatives from discovery to delivery. You will drive cross-functional teams, translate business needs into analytics solutions, and ensure on-time, high-quality outcomes that empower better decisions.

You will manage scope, timelines, and client engagement, with hands-on oversight of data integration, dashboards, and reporting.

Qualifications

• 3+ years of project management experience with the Microsoft Data stack including Power BI.
• Strong PM skills with a track record of delivering projects to completion.
• Excellent communication and ability to work with clients and team members.
• Experience translating business requirements into actionable project plans.
• Proficiency in SQL and data visualization tools like Power BI or Tableau.
• Familiarity with Agile methodologies.

Responsibilities

• Lead data and analytics projects from initiation through delivery, managing scope, timelines, resources, budget, and risks.
• Provide direction, coaching, and support to cross-functional project teams.
• Build strong client relationships by understanding goals and guiding analytics solutions.
• Elicit, assess, and clarify business needs through stakeholder interviews and analysis.
• Translate business needs into functional requirements, user stories, and technical specs.
• Oversee solution design and delivery to align with objectives and quality standards.
• Coordinate data integration from multiple sources for reporting and analysis.
• Guide dashboard and report development to be intuitive and client-focused.
• Facilitate knowledge transfer and ongoing client support post-delivery.
• Review deliverables for accuracy and quality; stay updated on industry trends.

Skills

Project management

Stakeholder management

Communication

Team leadership

SQL

Power BI

Tableau

Agile

Data analysis

Data visualization

Education

Bachelor's degree

Tools

Power BI

Tableau

Microsoft Fabric

Azure

Job description

Job Title: Project Lead - Data and Analytics

We are seeking a results-driven Project Lead Consultant to lead client-facing Data and AI initiatives from discovery through delivery. This role is ideal for a professional who combines strong project leadership, business analysis, and stakeholder management skills with a solid understanding of modern data platforms and reporting solutions. The Project Lead will partner with clients and cross-functional teams to define requirements, guide solution design, manage scope and timelines, and ensure high-quality outcomes that enable better business decisions. Success in this role requires strong communication, consulting presence, and the ability to translate business needs into practical, scalable analytics solutions.

Responsibilities

• Project Leadership: Lead data and analytics projects from initiation through delivery, managing scope, timelines, resources, budget, and risks to ensure successful outcomes.
• Team Leadership: Provide direction, coaching, and support to cross-functional project teams, fostering collaboration, accountability, and professional growth.
• Client Engagement: Build strong client relationships by understanding business goals, facilitating discussions, and providing strategic guidance on data and analytics solutions.
• Business Analysis: Elicit, assess, and clarify business needs through stakeholder interviews, process review, and analysis to define project objectives and solution requirements.
• Solution Translation: Translate business needs into clear functional requirements, user stories, and technical specifications that guide solution design and development.
• Solution Oversight: Oversee solution design and delivery to ensure technical approaches align with business objectives, quality standards, and user expectations.
• Data Integration: Coordinate the integration of data from multiple sources, ensuring data accuracy, consistency, and readiness for reporting and analysis.
• Dashboard and Report Development: Guide the development of dashboards and reports that are intuitive, visually effective, and aligned with client reporting needs.
• Training and Support: Facilitate knowledge transfer, user enablement, and ongoing support to help clients adopt and effectively use delivered solutions.
• Quality Assurance: Review deliverables for accuracy, completeness, and quality, and address issues to ensure solutions meet project and client standards.
• Industry Awareness: Stay current on data, analytics, and Microsoft ecosystem trends to inform project delivery, innovation, and strategic recommendations.

Requirements

• Bachelor's degree from an accredited university
• At least 3 years of experience in project management, with specific experience managing projects using the Microsoft Data stack, including Power BI.
• Strong project management skills with a track record of successfully leading projects to completion.
• Excellent communication and people skills, with the ability to work effectively with clients and team members.
• Proven leadership abilities and experience managing project teams.
• Experience in understanding and translating business requirements into actionable project plans.
• Proficiency in data analysis, database queries (e.g., SQL), and data visualization tools like Power BI or Tableau.
• Strong understanding of business processes, project management, and IT methodologies, including Agile.
• Ability to communicate effectively with both technical teams and business stakeholders.
• Ability to stay updated on industry trends and apply this knowledge to improve project outcomes.

Preferred qualifications

• Project management certifications such as PMP, CAPM, or CSM are preferred.
• Microsoft or data analytics certifications, particularly in Power BI, Microsoft Fabric, Azure, or related technologies, are highly desired.
• Experience in consulting or client-facing analytics delivery environments is preferred.

Join Collectiv for a rewarding career in a fully remote work environment with quarterly in person team experiences and a competitive compensation. We provide a clear growth trajectory with professional development opportunities and a top-shelf benefits package. Enjoy unlimited time off and 100% covered health insurance, encompassing medical, dental, and vision plans for you and your family. Our comprehensive offerings, from a competitive 401(k) with a 4% match to educational assistance, tech stipend, and discounts on various goods and services, demonstrate our commitment to your well-being and success. At Collectiv, your career thrives with a perfect blend of remote flexibility, growth potential, and unparalleled benefits prioritizing your financial, physical, and emotional well-being.

Collectiv is the leading boutique consulting and strategy firm specializing in Analytics, Planning and AI with Power BI and the Microsoft Data Stack.

Our mission at Collectiv is simple: We help enterprises make better decisions.

Our Core Values

Growth Mindset – Bring solutions, not problems.

Excel with Humility – Be humbly brilliant.

Communicate Actively and Empathetically – Listen, ask, understand, help.

Work Hard, Play Hard – Results are proportional to effort.

Keep Calm and Carry On – Stay cool, calm and Collectiv.