Solution Architect (Microsoft Data Stack)

Posted 20 Days Ago
Chicago, IL
Senior level
Artificial Intelligence • Analytics • Consulting
The Role
Lead the design and implementation of scalable data solutions using Microsoft technologies, collaborating with clients and project teams to ensure project success and delivery.
Summary Generated by Built In

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 prefers to work in an environment that allows for independence and continuous progress. You thrive on designing scalable and robust data analytics solutions and ensuring their successful implementation.

As a Solution Architect, you will play a pivotal role in our project teams, collaborating closely with clients, project managers, and implementation consultants. You will be responsible for designing and communicating the value of enterprise-grade data solutions based on the Microsoft Data Stack, ensuring they align with business goals and best practices.

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 75% billable utilization 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.

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 Empathically – Listen, ask, understand, help.

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

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

Top Skills

Azure Data Factory
Azure Data Stack
Azure Databricks
Azure Synapse Analytics
Azure
Microsoft Fabric
Power BI
Python
Spark
SQL
Am I A Good Fit?
beta
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
On-site Workplace
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 Jobs

Discover Logo Discover

Application Engineer

Cloud • Fintech • Machine Learning • Analytics • Financial Services
Hybrid
Chicago, IL, USA
18000 Employees
89K-150K Annually

Motorola Solutions Logo Motorola Solutions

Sales Engineer (Central United States)

Artificial Intelligence • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
Hybrid
Chicago, IL, USA
21000 Employees
67K-148K Annually

Capital One Logo Capital One

Senior Software Engineer, Back End (Java, Python, Go, AWS)

Fintech • Machine Learning • Payments • Software • Financial Services
Hybrid
Chicago, IL, USA
55000 Employees
144K-165K Annually

JPMorganChase Logo JPMorganChase

Lead Architect

Financial Services
Hybrid
Chicago, IL, USA
289097 Employees

Similar Companies Hiring

Stepful Thumbnail
Software • Healthtech • Edtech • Artificial Intelligence
New York, New York
60 Employees
HERE Technologies Thumbnail
Software • Logistics • Internet of Things • Information Technology • Computer Vision • Automotive • Artificial Intelligence
Amsterdam, NL
6000 Employees
True Anomaly Thumbnail
Software • Machine Learning • Hardware • Defense • Artificial Intelligence • Aerospace
Colorado Springs, CO
131 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account