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 thirteen-time Microsoft Partner of the Year and two-time Inc. Best Workplaces award winner.
Title Data & Analytics Solution Architect
Location Virtual, home based office with travel
Description
The Data & Analytics Solution Architect is responsible for being a partner to team members charged with building and growing the Business Analytics business at MCA. The Data & Analytics Solution Architect is expected to support hiring, project implementation and stability of the team as a partner with the Business Analytics director as the business grows.
Within a project framework, the Data & Analytics Solution Architect is responsible for leading the Business Requirements, Design and implementation of Data Warehouse and Data Warehouse solutions for MCA Connect’s current and future customers/ projects. The Data & Analytics Solution Architect will work onsite with MCA Connect’s directors, team members and developers to understand information requirements and prioritize customer data.
Key roles will include designing key performance indicators and analytics based on defined business process and success criteria, as well as modeling data for end user consumption. The Data & Analytics Solution Architect serves as the force for correct technical design and architecture practices, as well as being responsible for the physical implementation of the entire project as a single team member or leading a team of developers.
Responsibilities
- Provide Architectural and Design consultative services to clients regarding their preparedness for enterprise levels of Data Warehouse utilizing Microsoft’s Azure Data Services and other RDBMS Platforms.
- Provide expert architecture guidance on Data Warehouse, Data Lake, and Modern BI Architecture concepts and technologies. Preferred experience with Azure Synapse Analytics and ML/AI.
- Implement scalable and maintainable Dimensional Data Models to meet business objectives. Includes accurate Source to Target mapping, construction of ETL and automation of Data Architectures implemented. This is a hands-on role.
- Develop and design key performance indicators based on analysis and requirements gathering with the customer.
- Document accurate logical design and technical architectural documents for analytics solutions.
- Define BI standards, guidelines and best practices for requirements gathering, development and build phase management.
- Full BI application lifecycle development, from envisioning of features through to their end development into production.
- Work across technologies to design, develop and deliver the best and most practical BI solution given the current customer landscape.
- Implement design and software development life cycle using (Agile/ prototyping) concepts and have a strong quality ethic.
- Recommend strategies to improve performance and capacity of the customer’s current and future Data Warehouse landscape.
- Ability to troubleshoot existing solutions as well as manage the build and train clients on new artifacts
- With Project Management, Identify and resolve issues pertinent to the success of projects, including change management, data flow, application implementation, and issue escalation and resolution.
- Continually keep current Data Warehouse knowledge up to date with new features and functionality and share this knowledge to clients through updating current Data Warehouse training offerings and through internal employee communication.
- Conduct work sessions with clients in person, by telephone, using desktop video conferencing technology or remote access to client.
- Technically responsible for participating in Business Requirements Phases and Technical Design. Responsible for implementation of MCA solutions at all levels. Accountable for mistakes and delays, with support from MCA Leadership.
- Develop and deliver presentations to all levels within an organization.
- Manage small teams of developers as well as trainees learning MCA solutions on active project sites. Mentor and effectively lead Analytics team members on multiple projects, as well as individual career growth.
- Participate with Directors in Sales cycles with C level audience with clients.
- Ensure all peripheral business areas and alternative client divisions are investigated for project work. Responsible for expanding project footprint at client.
- Ability to take Initiative during bench time in between projects without instructions.
- Strong relationship-building with clients – have a personal relationship with clients and entertain them sufficiently to maintain the relationship.
Qualifications
- 7+ years Data Warehouse development experience or equivalent
- 7+ years Data Warehousing (Azure/SQL/Synapse), ETL (Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent Data Warehouse platform development experience, such as Oracle Database
- 7+ years of customer facing consulting experience with an understanding of enterprise solutions
- Bachelor’s degree in computer science or equivalent combination of education and experience preferable
- Knowledge of ERP, MRP and CRM data entity structures (OLTP database) desirable
- Multiple database engine and Data Warehouse experience (SQL Server, DB2, Oracle, Teradata)
- Deep knowledge of Data Warehouse Modeling and ETL development
- Familiarity with database performance tuning activities
- Excellent technical, cross group collaboration and customer facing communication skills
- Experience with strategic Data Warehouse consulting with a minimum of 2-4 years in two or more of the following:
- Industry experience with a BI focus within an ERP, MRP or CRM Platform
- Data Modeling, ETL and Data Warehouse Consulting experience with a Transactional Solution (OLTP)
- Data Modeling, ETL and Data Warehouse Development using Microsoft SQL Server/Azure Data Services
- Excellent communication skills both written and verbal
- Ability to adjust communication to the level of understanding of the audience
- Committed to learning, exploring new ideas, and staying at the leading edge.
- Committed to quality and customer success.
- Creativity to initiate new ideas and think out of the norm.
- Committed to learning, exploring new ideas, and staying at the leading edge.
- Committed to quality and ability to solve customer problems without conflict.
- Creativity to initiate new ideas and think out of the norm.
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
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.