Senior Data & AI Consultant — Remote, Power BI & Azure

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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
Microsoft Data & AI Senior Consultant
Microsoft Data & AI Senior Consultant

MCA Connect • United States

Remote
USD 110,000 - 145,000
Unlimited Paid Time Off
401k Match
Home Office stipend
+4
Senior Data & AI Engineer (Remote) – Azure Data Platform Lead
Senior Data & AI Engineer (Remote) – Azure Data Platform Lead

3Cloud • United States

Remote
USD 120,000 - 200,000
Senior Data & AI Engineer — Remote, Fabric & Power BI
Senior Data & AI Engineer — Remote, Fabric & Power BI

Diverse Consulting Group • United States

Remote
USD 120,000 - 150,000
Private medical care
Co-financing for the sports card
Training & learning opportunities
+1
Remote Senior Data & AI Engineer: Azure & AI
Remote Senior Data & AI Engineer: Azure & AI

3Cloud, LLC • United States

Remote
USD 150,000 - 190,000
Remote Data Engineer - Power BI, SQL & Azure DevOps
Remote Data Engineer - Power BI, SQL & Azure DevOps

Cai • United States

Remote
USD 95,000 - 105,000
Remote Senior Data & AI Solutions Architect
Remote Senior Data & AI Solutions Architect

Cambay Solutions LLC • United States

Hybrid
USD 150,000 - 200,000
Data & AI Solution Architect
Data & AI Solution Architect

Cambay Solutions LLC • United States

Remote
USD 150,000 - 200,000
Senior Data & AI Platform Architect - Azure & Fabric
Senior Data & AI Platform Architect - Azure & Fabric

Interlink Cloud Advisors, Inc. • Mason (OH)

On-site
USD 140,000 - 210,000
Senior Data & AI Architect - Microsoft Expert & Strategy
Senior Data & AI Architect - Microsoft Expert & Strategy

Not Disclosed • United States

Remote
USD 180,000 - 240,000