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 Consultant
Location Virtual, home based office with travel (10%)

DESCRIPTION

The Data & AI 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 Consultant is expected to be involved in all aspects of project implementations, drive innovation, upskill and mentor junior teammates, and partner with leadership to drive continuous improvement.
Within a project framework, the Data & AI 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.

QUALIFICATIONS

• 2+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent.
• Demonstrated experience in designing and implementing data solutions for complex 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 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 ERPand CRM tools desirable.
• Kimball Dimensional Modeling and batch/incremental ETL development approaches.
• 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.
  Additional Annual Bonus target: $13,000 - 17,500

• Participate in requirements gathering sessions and document client requirements.
• Independently perform data mapping analysis and documentation tasks.
• Demonstrate dimensional modeling capabilities and delivery.
• Independently build, maintain, and support basic data integration pipelines.
• Be able to implement complex data transformations using SQL, Python, and DAX.
• Build Power BI Reports, Dashboards, and Apps.
• Conduct working sessions with clients.
• Field 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.
• Perform peer review for source code version control.
• Independent validation of data pipeline performance and accuracy.
• Utilize 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.