Senior Consultant – Data & AI

MCA Connect

Data & AI Senior Consultant responsible for implementing Microsoft data solutions. Mentoring junior teammates and driving continuous improvement in project delivery.

Posted 7/21/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $90,000 - $145,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing Microsoft data solutions, including Data Warehousing, ETL processes, and Power BI reporting. Proven ability to lead project teams, mentor junior resources, and effectively communicate with stakeholders to drive continuous improvement and innovation.

Highest-signal resume keywords

Data WarehousingETL DevelopmentPower BI ReportingAzure Cloud PlatformsDimensional Modeling

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

AzureSQLSynapseSparkDelta LakeADF PipelinesSSISDAXData IntegrationDatabase Performance Tuning

Soft Skills

CommunicationMentoringClient Relationship ManagementProblem SolvingTeam Leadership

Tools & Technologies

Power BI ProPower BI PremiumMicrosoft ERPMicrosoft CRMAzure DevOps

Certifications & Qualifications

Professional Certifications

Industry Keywords

ManufacturingData GovernanceData Quality MonitoringKimball Dimensional ModelingAgile Methodologies

Tech Stack

Tools & technologies

AzureCloudERPETLSparkSQLSSIS

About the role

Key responsibilities & impact

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, responsible for building client relationships, effectively utilizing Agile project delivery methodologies, implementing scalable and efficient technical architectures to satisfy client requirements.
Performing hands on implementations of Microsoft data solutions for MCA Connect’s current and future customers/projects.
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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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