Back to jobs

Microsoft Data & AI Senior Consultant

Pay
USD 110,000–145,000/year — pay source
Salary 110,000 – 145,000 USD per year Why work for MCA Connect?
Read the full posting
Work setting
Remote — work setting source
Listed location: Remote
Read the full posting
Employment
Not stated

What you’ll work on

Full posting
  • Lead requirements gathering sessions and document client requirements.

  • Design and implement dimensional models.

  • Design, build, maintain, and support complex data integration pipelines.

  • Design and build Power BI reports, dashboards, and apps.

  • Mentor junior team members.

From the employer’s posting
Lead requirements gathering sessions and documentation of client requirements.
Design and implement dimensional models.
Design, build, maintain, and support complex data integration pipelines.
Design and build Power BI Reports, Dashboards, and Apps.
Mentor junior resources.

Before you apply

Employer’s visa record
1 H-1B petition approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.

What you’ll bring

All qualifications

Core experience

  • Hands-on experience implementing Microsoft data solutions.
  • Experience with Agile project delivery methodologies.
  • Ability to present proposed solutions and why they should be adopted.

Preferred experience

  • Knowledge of Microsoft ERP and CRM tools desirable.
Qualification wording
performing hands on implementations of Microsoft data solutions
effectively utilizing Agile project delivery methodologies
Able to present how your suggested solution will work and why it should be implemented.
Knowledge of Microsoft ERP and CRM tools desirable.
Education & alternatives
- Demonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties. - Bachelor’s degree in computer science or equivalent combination of education and experience preferable. - Knowledge of Microsoft ERP and CRM tools desirable.
Apply at MCA Connect

Posting record

Report an error

Actively hiringFirst seen by us 2 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 19, 20262 days ago
Recorded sightings
4
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

In line with similar jobs

$110K–$145K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 2

Early. Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

MCA Connect is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Delta Lake
  • Power BI
  • Spark
  • SSIS
Where the posting names them
Qualifications - 5+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent. - High level understanding of various Azure cloud data platforms and services.
Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights. Our strategic solutions, innovation, and industry intelligence help manufacturers gain visibility, improve profitability, and achieve a competitive edge. Established in 2002, MCA Connect has grown into one of the largest US-based solution partners in Microsoft Business Applications and Azure Data & AI / Digital & App Innovation. Our Microsoft Specialties include Finance and Supply Chain, Analytics on Azure, Data Warehouse Migration, and Power Platform. We’re also a fifteen-time Microsoft Partner of the Year and three-time Inc. Best Workplaces award winner. Title: Data & AI Senior Consultant
- Troubleshoot BI solutions, identify problems, and improve performance and security. - Design Azure DevOps backlog, sprints, and lead delivery. - Oversee project team and source code.
- 5+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent. - High level understanding of various Azure cloud data platforms and services. - Demonstrated experience in designing and implementing data solutions for complex business problems.
- Design, build, maintain, and support complex data integration pipelines. - Design and build Power BI Reports, Dashboards, and Apps. - Able to present how your suggested solution will work and why it should be implemented.

Your next step

Complete your application on jobs.lever.co. The employer’s form will show what is required.

Applying through Lever

  • No account needed: one form, and Lever reads your resume into the profile recruiters search.

Already applied? Track this application

Job description

View original posting ↗

Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights. Our strategic solutions, innovation, and industry intelligence help manufacturers gain visibility, improve profitability, and achieve a competitive edge.
 
Established in 2002, MCA Connect has grown into one of the largest US-based solution partners in Microsoft Business Applications and Azure Data & AI / Digital & App Innovation. Our Microsoft Specialties include Finance and Supply Chain, Analytics on Azure, Data Warehouse Migration, and Power Platform. We’re also a fifteen-time Microsoft Partner of the Year and three-time Inc. Best Workplaces award winner.


Title: Data & AI Senior Consultant 

 

Location: Virtual, home based office with travel >25% 

 

Description 

The Data & AI Senior Consultant is responsible for being a partner to team members, a mentor, and directly enabling growth of the Data & AI Services team at MCA. The Sr. Consultant is expected to lead project implementations, drive innovation, upskill and mentor junior teammates, and partner with leadership to drive continuous improvement. 

Within a project framework, the Data & AI Senior Consultant is responsible for building client relationships, effectively utilizing Agile project delivery methodologies, implementing scalable and efficient technical architectures to satisfy client requirements, and performing hands on implementations of Microsoft data solutions for MCA Connect’s current and future customers/projects. 

Responsibilities

  • Lead requirements gathering sessions and documentation of client requirements.  

  • Design and implement dimensional models.  

  • Design, build, maintain, and support complex data integration pipelines. 

  • Design and build Power BI Reports, Dashboards, and Apps.  

  • Able to present how your suggested solution will work and why it should be implemented. 

  • Able to identify optimization opportunities and plan implementation. 

  • Mentor junior resources. 

  • Lead working sessions with clients. ​ 

  • Lead and delegate ad hoc requests from clients.  

  • Troubleshoot BI solutions, identify problems, and improve performance and security. 

  • Design Azure DevOps backlog, sprints, and lead delivery. 

  • Oversee project team and source code.  

  • Obtain professional certifications to support our partner designations. 

  • Drives new revenue through successful delivery, client relationships, and some pre-sales support.  

  • Learning Master Data Management techniques and technologies.   

  • Learns Data Governance processes and technologies.  

  • Expertise with database and pipeline performance tuning activities. 

  • Must be open to ~10% travel on an as needed basis.

Qualifications

  • 5+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent. 

  • High level understanding of various Azure cloud data platforms and services. 

  • Demonstrated experience in designing and implementing data solutions for complex business problems.  

  • Experience working on projects involving large volumes of data, preferably in the Manufacturing industry. 

  • Demonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties.  

  • Bachelor’s degree in computer science or equivalent combination of education and experience preferable. 

  • Knowledge of Microsoft ERP and CRM tools desirable. 

  • Kimball Dimensional Modeling and batch/incremental ETL development approaches.  

  • Experience with database performance tuning activities. 

  • Experience developing and managing data quality monitoring and an understanding of data governance methodologies. 

  • Excellent communication skills both written and verbal. 

Desired Qualifications

  • Committed to mentoring and upskilling teammates. 

  • Committed to learning, exploring new ideas, and staying at the leading edge. 

  • Creativity to initiate new ideas and think out of the norm.  

  • Committed to quality and ability to solve customer problems without conflict.  

PLUS Uncapped Supplemental Compensation (Bonus) Plan

Salary

110,000 – 145,000 USD per year

Why work for MCA Connect?
Our compensation plan offers one of the best bonus structures in the industry.  Along with this we also offer a generous benefit package:

·        Work/Life Balance with Unlimited Paid Time Off (UPTO)
·        401k Plan with Company Matching Contribution
·        Monthly Stipend for Home Office Expenses
·        Subsidized Medical, Dental and Vision Coverage
·        Health Savings and Flexible Spending Accounts
·        Company Paid Life and Disability Insurance
·        Training, Certification and Continuing Education Support

MCA Connect offers limitless opportunities for personal and professional growth in a stimulating, challenging, and performance-oriented work culture where you can share your ideas and make impactful daily contributions. Our employees are highly motivated and talented individuals dedicated to developing, marketing, and selling products designed to deliver value for mid-market and enterprise-size manufacturing, distribution, and energy companies. We take the time to train our consultants so that they understand the industries we serve and can deliver best practices, proven methodologies, and ongoing industry expertise to our clients.

MCA Connect is an Equal Opportunity Employer. MCA Connect promotes equal employment opportunity to all employees and applicants and does not discriminate on the basis of race, religion, color, creed, national origin, sex, age, sexual/gender orientation, status as a protected disabled or Vietnam Era Veteran, disability, or any other legally protected status. We firmly believe our differences make us stronger!

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary 110,000 – 145,000 USD per year Why work for MCA Connect?
Location & working pattern

Remote

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.