Senior Consultant - Data & AI
MCA Connect
$90,000–$145,000
Jul 20, 2026
—
Jul 22, 2026
What this job asks for AI summary
A senior-level consulting role focused on designing and delivering Microsoft-based data and analytics solutions for manufacturing clients. Day-to-day work spans building data warehouses, ETL pipelines, dimensional models, and Power BI reports, while leading client engagements using Agile methods. The position also carries responsibility for mentoring junior team members and contributing to pre-sales activities. Suits an experienced data engineer or BI consultant with a strong Azure and Power BI background.
Senior level · 5+ years · Remote · Full-time
“or” means any one of them counts — you don't need all of them.
Posted 2 times — it's one opening, so apply once.
We read this from the posting text with AI. Skim the description below before ruling yourself out.
How this req sits in the market our data
Roughly 1,900 people nationally plausibly meet what this posting asks for (database architects). range 560–3,400
Applicant volume Moderate — A normal amount of company. The rare requirements below are what will separate a shortlisted application from the rest.
What the occupation pays Median $142,568 (middle half $111,775–$173,013).
Estimated from BLS employment for this occupation and area, per-skill prevalence across our listing corpus, and published wage benchmarks — as of Jul 28, 2026. It is a model, not a headcount.
Why we read it this way (10)
The role is fully remote ('Virtual, home-based office') with approximately 10% travel.
The 5+ years experience requirement is stated against a combined list of data warehousing technologies (Azure/SQL/Synapse/Spark/Delta Lake), ETL tools (ADF/SSIS), Analysis Services, DAX, and Power BI — treated as a single role-level gate rather than per-technology years.
Azure Synapse is listed as the primary representative of the data warehousing stack; SQL, Spark, and Delta Lake are captured as alternatives since the JD presents them as interchangeable options within that requirement.
Kimball Dimensional Modeling is listed in the main qualifications block without explicit 'required' language but sits alongside other clearly required items; treated as a hard gate given its placement and the role's core focus on dimensional modeling.
Azure DevOps is mentioned in the responsibilities section (design backlog/sprints) rather than in a qualifications block, so it is marked preferred.
Microsoft ERP and CRM tools are explicitly called 'desirable' in the qualifications section, so they are marked preferred.
The degree requirement states 'Bachelor's degree in computer science or equivalent combination of education and experience preferable,' which is a preference rather than a hard gate — degree requirement is set to None.
No compensation figures are provided in the posting.
SOC classification is Medium confidence: the role spans data pipeline/warehouse building (15-1243) and BI/reporting delivery (15-2031); the emphasis on dimensional modeling, ETL pipeline design, and scalable data architecture tips it toward 15-1243.
Ignored 1 non-technology phrase(s) as skills (responsibilities/concepts, not named tools): Kimball Dimensional Modeling.
Read the full posting
The employer publishes the full description on their own site — read it there ↗. Or sign in to read it here — it's free, and it also lets you track this application.