Associate Data and AI Consultant

Associate Data and AI Consultant - DACOE Training Program

MCA Connect is seeking passionate and driven individuals to join our Data & AI Center of Excellence (DACOE) Training Program. This full-time, salaried position is designed to launch your career as an Associate Consultant in Data & AI, providing an immersive and paid training experience to build a strong foundation in Microsoft Data Platforms. Join a team that helps manufacturers succeed by unlocking innovation with actionable business insights.

Program Details

• Start Date: June 1, 2026
• Training Length: 10 weeks (paid at your regular salary rate)
• Training Format: Hybrid (fully remote post-training). Approximately 50% onsite at our Denver headquarters during training. Onsite weeks are Monday–Thursday; Fridays are remote. All travel, lodging, and meals are covered during onsite training.

Interview Timeline

• Interviews beginning mid-March
• Offers expected no later than end of April/early May

Post-Training Role: Data & AI Associate Consultant

This role is responsible for supporting team members and directly enabling the growth of the Data & AI Services team at MCA Connect. You will be involved in all aspects of project implementations, support innovation, commit to upskilling, and partner with leadership for continuous improvement. This position offers a unique opportunity to work on diverse projects and grow your career in data engineering and analytics.

Responsibilities

• Support requirements gathering and documentation.
• Support data mapping analysis and documentation tasks.
• Support dimensional modeling for advanced analytics.
• Build, maintain, and support data integration pipelines.
• Implement basic data transformations using SQL, Python, and DAX.
• Build Power BI reports and visuals.
• Conduct working sessions with clients.
• Support basic ad hoc requests from clients.
• Communicate findings or problems to clients and identify next steps.
• Estimate tasks and track work using Azure DevOps.
• Contribute to version control of source code for data solutions.
• Perform validation of data pipeline performance and accuracy.
• Use bench time for technical skill improvement, certifications, training others, and supporting pre-sales.
• Willingness to travel up to 10% on an as-needed basis.

Qualifications

• 0-2 years of Data Analytics experience utilizing SQL, ETL (ADF Pipelines/SSIS), Power BI, or equivalent.
• Demonstrated experience in implementing data solutions for business problems.
• Knowledge of Relational Databases, Object Oriented Design, and Data Structures.
• Strong analytical and problem-solving skills.
• Professional business demeanor.
• Customer-focused attitude with a desire to interface directly with end-user clients.
• Ability to communicate effectively with technical teams, business stakeholders, and other parties.
• Bachelor’s degree in computer science or equivalent combination of education and experience is preferable.
• Knowledge of Microsoft ERP and CRM tools is desirable.
• Familiarity with Kimball Dimensional Modeling and batch/incremental ETL development approaches.
• Commitment to mentoring and upskilling teammates.
• Dedication to learning, exploring new ideas, and staying at the cutting edge.
• Creativity to initiate new ideas and think innovatively.
• Commitment to quality and ability to solve customer problems effectively.

Why work for MCA Connect?

• Industry-leading compensation plan with one of the best bonus structures.
• Generous benefits package: Unlimited Paid Time Off (UPTO), 401k with company match, monthly home office stipend, subsidized medical/dental/vision, health savings accounts, company-paid life and disability insurance, and support for training, certifications, and continuing education.
• Limitless opportunities for personal and professional growth in a stimulating, challenging, and performance-oriented culture.
• Highly motivated and talented team dedicated to delivering value to manufacturing, distribution, and energy companies.
• Comprehensive training programs to ensure consultants understand the industries served and can deliver best practices.

Key skills/competency

• Data Engineering
• Business Intelligence
• SQL
• Python
• Power BI
• ETL
• Cloud Computing (Azure)
• Data Modeling
• Agile Methodologies
• Problem-Solving