Senior Consultant - Microsoft Cloud, Data, and AI
Quick Summary
Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights. Our strategic solutions, innovation,
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
~1 min read- →
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.
Requirements
~2 min read-
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.
-
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.
Location & Eligibility
Listing Details
- Posted
- September 10, 2026
- First seen
- September 11, 2026
- Last seen
- September 12, 2026
Posting Health
- Days active
- 0
- Repost count
- 0
- Trust Level
- 80%
- Scored at
- September 11, 2026
Signal breakdown
Please let Mcaconnect know you found this job on Jobera.
3 other jobs at Mcaconnect
View all →Explore open roles at Mcaconnect.
Similar Consultant jobs
View all →Stay ahead of the market
Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.
No spam. Unsubscribe at any time.