← Back to jobsJob ID col-cmwp7mrqd07fhd8ha3o2zdfoq

MCA ConnectPosted 1 day ago

Microsoft Data & AI Senior ConsultantNew

Full-time
Remote
5+ years
Competitive
Posted 1 day ago

MCA Connect hires a Data & AI Senior Consultant to lead project implementations and deliver Microsoft data solutions for its clients. The role focuses on client relationships, scalable technical architectures, team mentoring, and continuous improvement.

Posted
1 day ago
Source
jobs.lever.co
Sector
Consulting

Opens the employer's application page in a new tab

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
  • Demonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties
  • 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

Preferred

  • Experience working on projects involving large volumes of data, preferably in the Manufacturing industry
  • Bachelor's degree in computer science or equivalent combination of education and experience preferable
  • Knowledge of Microsoft ERP and CRM tools desirable
  • 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
  • Manufacturing Industry Experience

Required skills

Analysis ServicesApache SparkAzure Data FactoryAzure SynapseDAXData WarehousingDelta LakeETLKimball Dimensional ModelingPower BISQLSSIS

Full job description

MCA Connect hires a Data & AI Senior Consultant to lead project implementations and deliver Microsoft data solutions for its clients. The role focuses on client relationships, scalable technical architectures, team mentoring, and continuous improvement.

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

Preferred

  • Experience working on projects involving large volumes of data, preferably in the Manufacturing industry
  • Bachelor's degree in computer science or equivalent combination of education and experience preferable
  • Knowledge of Microsoft ERP and CRM tools desirable
  • 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
  • Large-Volume Data Projects
  • Manufacturing Industry Experience
  • Computer Science
  • Microsoft ERP
  • Microsoft CRM
  • Mentoring
  • Coaching
  • Upskilling
  • Learning Agility
  • Curiosity
  • Creativity
  • Innovative Thinking
  • Quality Commitment
  • Customer Problem-Solving
  • Conflict Resolution

Benefits

  • One of the best bonus structures in the industry
  • 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
  • Virtual, home-based office with travel >25%

Company

  • Microsoft technology consulting and implementation for manufacturers and distributors
  • Denver, Colorado, USA
  • http://mcaconnect.com/
  • Founded in 2002
  • 201-500 employees

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
  • Demonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties
  • 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
  • Experience working on projects involving large volumes of data, preferably in the Manufacturing industry
  • Bachelor's degree in computer science or equivalent combination of education and experience preferable
  • Knowledge of Microsoft ERP and CRM tools desirable
  • 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
  • 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.

Required skills

  • Analysis Services, Apache Spark, Azure Data Factory, Azure Synapse, DAX, Data Warehousing, Delta Lake, ETL, Kimball Dimensional Modeling, Power BI, SQL, SSIS

Preferred skills

  • Committed to mentoring and upskilling teammates, Creativity to initiate new ideas and think out of the norm, Knowledge of Microsoft ERP and CRM tools desirable

Experience

  • 5+ years

Job details

Employment type

Full-time

Seniority level

5+ years

Sector · Sub-sector

Consulting · IT Consulting

Date posted

Nov 20, 2026

Work mode

Remote

Job source

jobs.lever.co

Company

MCA Connect

Consulting

Microsoft technology consulting and implementation for manufacturers and distributors

  • Denver, Colorado, USA
  • Consulting
  • 201-500 employees
  • Founded 2002
  • mcaconnect.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Consultant jobs

Centric Software

1d ago

New

Senior Data Scientist Consultant

Full-timeRemoteUnited States$110K – $140K/yr

Centric Software, Inc. is seeking a Senior Data Scientist Consultant to help retailers and brands make better decisions about inventory, promotions, and pricing.

Why similarSame roleSQL

Kyndryl

1d ago

New

Workday HCM Data Consultant

Full-timeHybridNew York, NY$88K – $168K/yr

Kyndryl is hiring a Workday HCM Data Consultant to manage people data and support data conversion, validation, and troubleshooting for Workday HCM projects.

Why similarSame role

Dice

1d ago

New

Azure Data Engineer – Microsoft Fabric - Phoenix, AZ, St. Louis, MO, Nashville, TN, Kansas City, KS, Denver, CO.

TemporaryRemoteUnited StatesCompetitive

QTech is hiring an Azure Data Engineer to build scalable analytics platforms and AI-ready data pipelines.

Why similarSimilar titleAzure Data FactoryETL

Get new Data Consultant jobs by email

Create job alert

Microsoft Data & AI Senior Consultant

MCA Connect · Competitive

Apply on company site