Solution Architect (Microsoft Data Stack)

Collectiv; Chicago (IL); Remote; USD 100,000 - 150,000; Full time

Job summary

Join a leading consulting firm as a Solution Architect, where you will design and implement enterprise data solutions using Microsoft technologies. Thrive in a remote work environment while enjoying unlimited time off and comprehensive benefits, including 100% health insurance coverage and a 401(k) plan.

Benefits

Unlimited time off

100% covered health insurance

401(k) with 4% match

Educational assistance

Tech stipend

Qualifications

• Proven experience in architecting solutions on the Azure platform.
• Strong proficiency in Microsoft data stack services.
• Relevant Azure certifications preferred.

Responsibilities

• Lead Discovery & Solution Design for client requirements.
• Architect high-quality, scalable data solutions.
• Collaborate with project teams to ensure success.

Skills

SQL

Python

Spark

Data Modeling

Data Governance

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Synapse Analytics

Azure Databricks

Power BI

Microsoft Fabric

Job description

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.

Create a job alert for this search