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 One of the largest US-based solution partners in Microsoft Business Applications and Azure Data & AI / Digital & App Innovation Fifteen-time Microsoft Partner of the Year Three-time Inc. Best Workplaces award winner
Data & AI Associate Consultant
Location
United States
Posted
2 days ago
Salary
$65K - $95K / year
No structured requirement data.
Job Description
Role Description
This position is part of the Data & AI Center of Excellence (DACOE) Training Program. This is a full-time, salaried position beginning June 1, 2026, designed to launch your career as a Data & AI Associate Consultant through our Data & AI Center of Excellence (DACOE). You will start with an immersive paid training program, where you’ll build a strong foundation in Microsoft Data Platforms.
Program Details
- Start Date: June 1, 2026
- Training Length: 10 weeks (paid at your regular salary rate)
- Training Format: Hybrid (fully remote position POST training)
- Approximately 50% onsite at our Denver headquarters
- Onsite weeks are Monday–Thursday; Fridays are remote
- All travel, lodging, and meals are fully covered during onsite training
Interview Timeline
- Interviews beginning mid-March
- Offers expected no later than end of April/early May
Job Title
Data & AI Associate Consultant
Location
Virtual, home based office with travel up to 10%
Description
The Data & AI Associate Consultant is responsible for being a partner to team members and directly enabling growth of the Data & AI Services team at MCA. The Associate Consultant is expected to be involved in all aspects of project implementations, support innovation, be committed to upskilling, and partner with leadership to drive continuous improvement.
Within a project framework, the Associate Consultant is responsible for:
- Building client relationships
- Effectively utilizing Agile project delivery methodologies
- Implementing technical solutions to satisfy client requirements
- Performing hands-on implementations of Microsoft data solutions for MCA Connect’s current and future customers/projects
This role 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 to completion using Azure DevOps
- Contribute to version control of source code for data solutions
- Perform validation of data pipeline performance and accuracy
- Use bench time to improve technical capabilities, obtain certifications, train others, and support pre-sales processes
- Must be open to ~10% travel on an as needed basis
Qualifications
- 0-2 years Data Analytics 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 and desire to interface directly with end-user clients
- Demonstrated 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
- 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
Requirements
- $65,000 - $95,000 a year
- Plus additional annual bonus between $10,000 - $15,000 (paid quarterly)
Benefits
- 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
Company Description
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!
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.
Job Requirements
- 0-2 years Data Analytics 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 and desire to interface directly with end-user clients
- Demonstrated 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
- 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
- $65,000 - $95,000 a year
- Plus additional annual bonus between $10,000 - $15,000 (paid quarterly)
Benefits
- 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
Related Guides
Related Categories
Related Job Pages
More Consultant Jobs
Remote Account Development Consultant
BuzzTech MediaBuzzTechMedia is a digital solutions company assisting businesses and professionals manage their workloads more efficiently.
The consultant will be responsible for generating new business opportunities by conducting outbound outreach via phone, email, and virtual meetings to identify and introduce potential clients to the company's digital services. Key duties include qualifying leads, understanding client needs, scheduling discovery calls, and advancing prospects through the sales pipeline while maintaining detailed CRM records.
The consultant provides direct support for Pharmacy and Medical Drug information needs using analytic tools, collaborating with multidisciplinary teams to recommend actionable items for positive pharmacy financial performance. This role involves performing research, analyzing data for trends and improvements, and preparing/presenting information to management and customers to support their goals.
Joint Action to Stop Wasting Learning Consultant
AGORAUNICEF works in over 190 countries and territories to save children’s lives, defend their rights, and help them fulfill their potential, from early childhood through adolescence. UNICEF is committed, passionate, and proud of what we do for as long as we are needed. Promoting the rights of every child is not just a job – it is a calling. UNICEF promotes and advocates for the protection of the rights of every child, everywhere, in everything it does UNICEF's global workforce must reflect the diversity of those children UNICEF encourages applications from all qualified candidates, regardless of gender, nationality, religious or ethnic backgrounds, and from people with disabilities
The purpose of this consultancy is to support the five frontrunner countries (Haiti, Kenya, Madagascar, Nigeria, and South Sudan) to document the implementation of the Joint Action to Stop Wasting (JASW) and produce learning briefs. The consultant will provide technical and metho...
The Associate Business Consultant supports client projects by analyzing data, providing actionable insights, and assisting in the configuration of customer experience (CX) solutions. This role involves increasing responsibility in managing tasks independently, collaborating with ...
