Support data engineering and analytics implementations for manufacturing clients: gather requirements, build data integration pipelines, perform SQL/Python/DAX transformations, create Power BI reports, validate pipelines, and collaborate with clients using Agile methods.
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 & Analytics Associate Consultant
Location Virtual, home based office with travel
Description
The Data & Analytics Associate Consultant is responsible for being a partner to team members and directly enabling growth of the Manufacturing Intelligence team at MCA. The Associate Consultant is expected to be involved in all aspects of project implementations, support innovation, be committed to upskilling themself, and partner with leadership to drive continuous improvement.
Within a project framework, the Data & Analytics Associate Consultant is responsible for building client relationships, effectively utilizing Agile project delivery methodologies, implementing technical solutions to satisfy client requirements, and 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 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.
Why work for MCA Connect?
Our compensation plan offers one of the best bonus structures in the industry. Along with this we also offer a generous benefit package:
· 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
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!
Top Skills
Azure
Azure Data Factory (Adf)
Azure Devops
Dax
ETL
Power BI
Power Platform
Python
Relational Databases
SQL
Ssis
Similar Jobs
Artificial Intelligence • Information Technology
The Data & AI Consultant leads project implementations, builds client relationships, mentors junior staff, and develops technical data solutions using Microsoft technologies.
Top Skills:
Adf PipelinesAzureAzure DevopsDaxDelta LakePower BISparkSQLSsisSynapse
Edtech • Healthtech • HR Tech • Information Technology • Professional Services • Software • Telehealth
The AR/Collections Specialist manages the collections cycle, follows up on overdue accounts, resolves billing issues, ensures HIPAA compliance, and collaborates with teams for complex customer issues.
Top Skills:
Erp SystemsExcelSalesforce
Edtech • Healthtech • HR Tech • Information Technology • Professional Services • Software • Telehealth
The Customer Billing Advocate manages billing for therapy sessions, ensuring efficient reimbursements, resolving outstanding accounts receivable, and coordinating with insurance companies and internal teams. They lead client meetings and monitor account health.
Top Skills:
AvailityAzaleaMicrosoft SuiteRethinkSalesforceTebraTrizettoWaystar
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
