MCA Connect · 5 days ago
Data & AI Services Consultant
United States
Full-time
Hybrid
Entry, Mid Level
$85K/yr - $120K/yr
2+ years expMCA Connect is a leading solution partner in Microsoft Business Applications and Azure Data & AI, dedicated to helping manufacturers succeed through innovation and actionable insights. The Data & AI Consultant will be responsible for project implementations, driving innovation, mentoring team members, and building client relationships while delivering scalable technical architectures and Microsoft data solutions.
Consumer ElectronicsInformation TechnologyRoboticsVirtual Reality
Responsibilities
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
Qualification
Required
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
Excellent communication skills both written and verbal
Preferred
Knowledge of Microsoft ERP and CRM tools desirable
Kimball Dimensional Modeling and batch/incremental ETL development approaches
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
MCA Connect
MCA Connect is a system integrator focused on the sale and support of Microsoft Dynamics software solutions.
201-500 employees
H1B Sponsorship
MCA Connect has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (4)
2024 (4)
2023 (14)
2022 (4)
2021 (3)
2020 (6)
Funding
Current Stage
Growth StageTotal Funding
unknownKey Investors
RLH Equity Partners
2020-07-14Private Equity
Leadership Team
Doug Bulla
Senior Vice President Solution Development
Recent News
Company data provided by crunchbase