Solution Architect (Microsoft Data Stack)

Sorry, this job was removed at 08:22 p.m. (CST) on Tuesday, Aug 05, 2025
Chicago, IL
In-Office
Artificial Intelligence • Analytics • Consulting
The Role

About Collectiv

Collectiv is a premier consulting firm specializing in Microsoft Data & Analytics solutions. We help enterprise clients design, implement, and optimize their data strategies using Microsoft Fabric, Azure Data Stack, and Power BI. Our team is made up of proactive, results-driven professionals who thrive in dynamic environments that value independence, innovation, and efficiency.

About the Role

We are looking for a Solution Architect who is assertive, strategic, and forward-thinking. You are someone who takes charge, enjoys solving complex business challenges, and thrives in an environment that values independence and progress.

In this role, you will partner closely with Sales and Account Management to scope and architect enterprise-grade data solutions aligned to client goals and the Microsoft Data Stack. You’ll play a key role in discovery, value articulation, and solution design, helping current and prospective clients visualize a path to successful outcomes. You’ll also collaborate with project teams to ensure a smooth transition from vision to execution, supporting implementation consultants and project managers to uphold quality and solution integrity.

Key Responsibilities

  • Lead Discovery & Solution Design – Translate client requirements into scalable technical solutions using the Microsoft Azure Data Stack, Fabric, and Power BI.
  • Architect End-to-End Solutions – Design data solutions that are high-quality, robust, and scalable.
  • Lead Data & Analytics Visioning Client Engagements – guide clients in defining and documenting tactical steps in their strategic data & analytics roadmap utilizing the Microsoft data stack. 
  • Collaborate & Deliver – Work closely with consultants, project managers, and clients to ensure project success.
  • Maintain High Utilization – Deliver at least ~10 billable hours per week by actively contributing to projects.
  • Ensure Quality & Follow-up – Maintain high standards, track project progress, and ensure solutions meet business expectations.
  • Support Sales Efforts – Assist the Sales team in pre-sales activities, including solution architecture for prospects.
  • Provide Technical Thought Leadership & Mentorship – Serve as a go-to expert on the Microsoft Data Stack, mentoring team members, sharing best practices, and contributing to internal knowledge growth through documentation, training, and solution accelerators.

Who You Are

  • A strategic problem solver who enjoys tackling complex business challenges.
  • Process-oriented and detail-focused, with a strong ability to set up and enforce systems to ensure success.
  • A conservative risk-taker, ensuring decisions are well thought out before execution.
  • A self-starter who prefers to take ownership rather than delegate when efficiency demands it.
  • A high performer who values independence, accountability, and continuous improvement.

Qualifications & Experience

  • Bachelor's degree from an accredited university.
  • Proven experience in architecting and delivering solutions on the Azure platform.
  • Expertise in Microsoft Fabric, including Data Pipelines, OneLake, and Synapse Real-Time Analytics.
  • Strong proficiency in Azure services such as Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Power BI.
  • Strong proficiency in SQL, Python, Spark, and data modeling, including experience with ELT/ETL workflows.
  • Familiarity with data governance and compliance frameworks.
  • Experience working with enterprise clients and delivering scalable solutions.
  • Ability to communicate technical concepts to both technical and non-technical stakeholders.
  • Experience with pre-sales solutioning and client discovery is a plus.
  • Relevant Azure certifications (e.g., Azure Solutions Architect, Azure Data Engineer), Fabric (DP-600, DP-700) certifications, and Databricks certifications are highly desirable.

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.

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.

Similar Jobs

Capital One Logo Capital One

Risk Manager - Commercial and Counterparty Credit

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
2 Locations
133K-167K Annually

Capital One Logo Capital One

Lead Data Engineer

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
3 Locations
205K-257K Annually

Capital One Logo Capital One

Sr. Associate, Product Management - Risk Capabilities

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
4 Locations
99K-136K Annually

Capital One Logo Capital One

Lead Software Engineer

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
3 Locations
176K-221K Annually
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
32 Employees
Year Founded: 2016

What We Do

Voted the #1 consulting provider on G2 for Business Intelligence and Power BI, Collectiv’s experts are highly skilled across the Microsoft data stack and highly specialized in planning and forecasting.

Similar Companies Hiring

Amplify Platform Thumbnail
Fintech • Financial Services • Consulting • Cloud • Business Intelligence • Big Data Analytics
Scottsdale, AZ
62 Employees
Credal.ai Thumbnail
Software • Security • Productivity • Machine Learning • Artificial Intelligence
Brooklyn, NY
Standard Template Labs Thumbnail
Software • Information Technology • Artificial Intelligence
New York, NY
10 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account