Associate Consultant - Data & AI at MCA Connect in Remote

Summary: MCA Connect is a leading US-based solution partner specializing in Microsoft Business Applications and Azure Data & AI. They are seeking a Data & AI Associate Consultant who will support project implementations, build client relationships, and drive continuous improvement within the Data & AI Services team. 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 Required 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 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 - 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 Preferred Qualifications: - Knowledge of Microsoft ERP and CRM tools desirable - Kimball Dimensional Modeling and batch/incremental ETL development approaches Required Skills: SQL, Power BI, ETL Important Skills: Data Analytics, Relational Databases, Object Oriented Design, Data Structures Nice-to-Have Skills: Analytical Skills, Commitment to Quality, Customer-Focused Attitude 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