Implement and deliver Microsoft-based data solutions: gather requirements, build ETL pipelines, perform dimensional modeling, develop complex transformations (SQL, Python, DAX), and create Power BI reports while mentoring teammates and supporting client engagements.
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.
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.
Within a project framework, the Data & AI Consultant is responsible for building client relationships, effectively utilizing Agile project delivery methodologies, implementing scalable and efficient technical architectures to satisfy client requirements, and performing hands on implementations of Microsoft data solutions for MCA Connect’s current and future customers/projects.
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
- 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.
- 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.
Desired Qualifications
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
Analysis Services
Azure
Azure Data Factory (Adf)
Azure Devops
Azure Synapse
Dax
Delta Lake
Kimball Dimensional Modeling
Power Bi (Pro
Premium)
Python
Spark
SQL
Ssis
MCA Connect Denver, Colorado, USA Office
8055 East Tufts Avenue, Suite 1300, Denver, CO, United States, 80237
Similar Jobs
Cloud • Information Technology • Consulting
This role involves designing and implementing Azure data and AI solutions, building data pipelines, integrating AI services, and engaging with clients to support business transformations.
Top Skills:
Azure Ai ServicesAzure Data ServicesAzure DevopsAzure OpenaiAzure SqlAzure Synapse AnalyticsBicepCognitive ServicesCosmos DbDatabricksGithub ActionsAzureMicrosoft FabricPower BIPythonSQLTerraform
Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
The Software Engineer, iOS will develop high-performance mobile apps, architect and implement Objective-C software, evaluate technical decisions, and collaborate with design teams while ensuring code quality.
Top Skills:
C/C++MetalObjective-COpenglSwift
Gaming • Information Technology • Mobile • Software • Esports
The Senior Server Engineer will develop server-side applications, with a focus on performance, distribution, and security in gaming. Responsibilities include optimizing databases and backend code for seamless player experience.
Top Skills:
C++Microsoft Sql ServerMySQLPerlPHPPythonRubySQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
