[Hiring] Azure Data & AI Consultant @MCA Connect

Role 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.

• 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.
• 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.

Qualifications

• 3+ 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 ERP and 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.

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

Salary

$75,000 - $120,000 a year PLUS Uncapped Supplemental Compensation (Bonus) Plan paid out quarterly

Company Description

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
• 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

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!