Microsoft Data & AI Senior Consultant

MCA Connect

United States

Remote

USD 110,000 - 145,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Unlimited Paid Time Off
401k Match
Home Office stipend
Health/Dental/Vision
Health Savings Account
Life and Disability Insurance
Training and Certification Support

Job summary

MCA Connect is seeking a Data & AI Senior Consultant to lead data and analytics initiatives, mentor junior teammates, and drive solution delivery for manufacturing clients. You will build scalable data architectures, implement Azure-based data solutions, and deliver Power BI reports and dashboards.

You will work across requirements gathering, design, development, and client sessions, while advancing governance and data quality practices.

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.
  • 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.

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.

Skills

Data Warehousing
ETL
DAX
Power BI
Azure Cloud
Communication
Dimensional Modeling
Performance Tuning
Data Governance
Verbal Communication

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Azure Synapse
SQL

Job description

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.

$110,000 - $145,000 a year

PLUS Uncapped Supplemental Compensation (Bonus) Plan

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!

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

D365 CE Senior Functional Consultant (Managed Services)
D365 CE Senior Functional Consultant (Managed Services)

MCAConnect • United States

Remote
USD 90,000 - 160,000
Unlimited PTO
401(k) with company match
Home office stipend
+2
Customer Relationship Executive - Microsoft BizApps (D365 F&SC)
Customer Relationship Executive - Microsoft BizApps (D365 F&SC)

MCAConnect • United States

Remote
USD 150,000 - 170,000
Unlimited PTO
401k Match
Home office stipend
+4
Power Platform Engineer (Managed Services)
Power Platform Engineer (Managed Services)

MCA Connect • United States

Remote
USD 100,000 - 145,000
Unlimited PTO
401k with match
Home office stipend
+2
D365 CE & Power Platform Technical Engineer
D365 CE & Power Platform Technical Engineer

MCA Connect • United States

Remote
USD 100,000 - 145,000
401k Plan with Company Matching
Monthly Home Office Stipend
Health Insurance
+3
Customer Relationship Executive - Microsoft BizApps (D365 F&SC)
Customer Relationship Executive - Microsoft BizApps (D365 F&SC)

mcaconnect • United States

Remote
USD 120,000 - 180,000
Unlimited Paid Time Off (UPTO)
401k Plan with Company Matching
Monthly Home Office Stipend
+4
D365 F&O Functional Solution Architect
D365 F&O Functional Solution Architect

Remote • San Francisco (CA)

On-site
USD 110,000 - 160,000
Unlimited PTO
401k with company match
Home office stipend
+4
D365 CE Functional Consultant
D365 CE Functional Consultant

MCA Connect, LLC • United States

Remote
USD 90,000 - 130,000
Unlimited PTO
401(k) Matching
Home office stipend
+4
Data & AI Senior Consultant (Fully Remote)
Data & AI Senior Consultant (Fully Remote)

MCA Connect • United States

Remote
USD 120,000 - 160,000
Unlimited Paid Time Off
Medical, dental, and vision coverage (
HSA/FSA options
+3
D365 CE & Power Platform Technical Engineer
D365 CE & Power Platform Technical Engineer

mcaconnect • United States

Remote
USD 110,000 - 150,000
Unlimited Paid Time Off (UPTO)
401k Plan with Company Matching
Monthly Home Office stipend
+4
D365 CE Functional Consultant
D365 CE Functional Consultant

mcaconnect • United States

Remote
USD 90,000 - 150,000
Unlimited Paid Time Off