Data SME Consultant Microsoft

INNOVATIVE TECH SOLUTIONS INC; Washington (District of Columbia); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Employee discounts

Flexible schedule

Health insurance

Job summary

Innovative Tech Solutions Inc is looking for a Data SME Consultant to join our Washington, IN team. You will apply Microsoft data platform skills to deliver impactful client solutions.

The role involves architecture, governance, ETL/ELT, data modeling, and mentoring project teams in a fast-paced consulting environment.

Qualifications

• Proven experience as a Data Consultant or Data SME in a professional services or consulting environment.
• Deep expertise in Microsoft data technologies including Azure, SQL Server, Power BI, and Synapse Analytics.
• Strong understanding of data warehousing, data modeling, and ETL/ELT processes.
• Microsoft certifications (e.g., Azure Data Engineer, Azure Solutions Architect) preferred.
• Experience gathering and translating business requirements into technical data solutions.
• Excellent communication, presentation, and client-facing skills.
• Ability to work independently and manage multiple priorities in a consulting setting.

Responsibilities

• Serve as SME on data architecture, governance, and Microsoft data platform solutions
• Design and implement data solutions using Microsoft technologies such as Azure Data Factory, Azure Synapse, Power BI, and SQL Server
• Collaborate with clients to assess data needs, define requirements, and deliver strategic recommendations
• Develop and maintain data pipelines, data models, and ETL/ELT workflows
• Provide technical guidance and mentorship to project teams on Microsoft data best practices
• Support data migration, integration, and transformation initiatives across client environments
• Communicate complex data concepts clearly to both technical and non-technical stakeholders

Skills

Azure

SQL Server

Power BI

Synapse Analytics

Data warehousing

ETL/ELT

Client-facing communication

Tools

Azure Data Factory

Job description

Benefits

• Employee discounts
• Flexible schedule
• Health insurance

About the Role

Innovative Tech Solutions Inc is looking for a talented and driven Data SME Consultant with Microsoft expertise to join our growing team in Washington, IN. This is an exciting opportunity to leverage your deep data knowledge and Microsoft platform skills to deliver impactful solutions for our clients. If you thrive in a fast-paced consulting environment and love solving complex data challenges, we want to hear from you!

Responsibilities

• Serve as the Subject Matter Expert (SME) on data architecture, governance, and Microsoft data platform solutions
• Design and implement data solutions using Microsoft technologies such as Azure Data Factory, Azure Synapse, Power BI, and SQL Server
• Collaborate with clients to assess data needs, define requirements, and deliver strategic recommendations
• Develop and maintain data pipelines, data models, and ETL/ELT workflows
• Provide technical guidance and mentorship to project teams on Microsoft data best practices
• Support data migration, integration, and transformation initiatives across client environments
• Communicate complex data concepts clearly to both technical and non‑technical stakeholders

Requirements

• Proven experience as a Data Consultant or Data SME in a professional services or consulting environment
• Deep expertise in Microsoft data technologies including Azure, SQL Server, Power BI, and/or Synapse Analytics
• Strong understanding of data warehousing, data modeling, and ETL/ELT processes
• Microsoft certifications (e.g., Azure Data Engineer, Azure Solutions Architect) preferred
• Experience gathering and translating business requirements into technical data solutions
• Excellent communication, presentation, and client‑facing skills
• Ability to work independently and manage multiple priorities in a consulting setting

About Us

Innovative Tech Solutions Inc is a forward-thinking technology consulting firm dedicated to helping businesses harness the power of data and modern technology platforms. Our clients trust us to deliver cutting‑edge solutions that drive real results, and our team members enjoy a collaborative, innovative culture where expertise is valued and growth is encouraged. Join us in Washington, IN, and be part of a company that is shaping the future of technology consulting.