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.
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 ERP and CRM tools desirable.
- Kimball Dimensional Modeling and batch/incremental ETL development approaches.
- Excellent communication skills both written and verbal.
Top Skills
What We Do
Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights.
We understand manufacturing’s unique culture and challenges because we’ve spent more than 20 years in the industry. Through strategic solutions, innovation, and industry intelligence, we help manufacturers across all sub-industries solve critical issues, modernize operations, and gain a competitive edge.
MCA Connect helps clients digitally transform through:
Manufacturing Strategy: Expert and curated guidance that delivers actionable insights, a path for continuous improvement, and P&L results.
Connected Applications: Global Dynamics 365 enterprise implementations and integrations that enable clients to execute against their strategic roadmap.
Modern Platform Management: Proactive support, intelligent insights, and optimization of modern manufacturing platform.
Manufacturing Intelligence: A connected enterprise powered by Industry 4.0 capabilities that delivers the wisdom of prediction and prescription.
As a ten-time Microsoft Partner of the Year, we excel in empowering manufacturers to transform with the Microsoft Cloud. Microsoft’s full suite of secure cloud solutions unifies modern business applications and industry intelligence, enabling organizations to do more.
.png)
