Microsoft Azure Data & Analytics Solution Architect

at MCA Connect
Published November 17, 2023
Location Denver, CO
Category All  
Job Type Full-Time  



Title Data & Analytics Solution Architect  

Location Virtual, home-based office with travel


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.


  • 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.


  • 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

Desired Qualifications

  • 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.

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 are a leading consultancy firm specializing in designing and implementing enterprise software systems, specifically Microsoft Dynamics 365. We are the Microsoft partner of choice for industry leading Fortune 100 and 500 companies. If you are looking for a dynamic opportunity, MCA Connect may be the place for you!

Established in 2002, MCA Connect has grown into one of the largest US-based Microsoft Gold Certified Partners focused exclusively on delivering Microsoft Dynamics 365 solutions and services to mid-market and enterprise-size manufacturing, distribution, and energy companies. MCA Connect is headquartered in Denver, CO, has offices throughout the United States, and supports global implementations around the world.

Why work for MCA Connect?

  • You can work with a world-class consulting organization that will help you take your experience to the next level.
  • You will have the opportunity to lead and contribute to highly desirable and visible projects using the latest Microsoft technologies.
  • You can work in an environment where teamwork is encouraged and where you have opportunities for personal growth and advancement.
  • Our compensation plan offers one of the best bonus structures in the industry. 
  • We only hire the best and brightest consultants and software developers.
  • 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.
  • We are a midsized company with great people, a proven sales and marketing process, and a history of steady growth and profitability.
  • We have a strong management team who is fully supportive of work-life balance.

Comprehensive Benefit Plan Including:

o  Work/Life Balance with Unlimited Paid Time Off (UPTO)

o  401k Plan with Company Matching Contribution

o  Monthly Stipend for Home Office Expenses

o  Subsidized Medical, Dental and Vision coverage

o  Health Savings and Flexible Spending Accounts

o  Company Paid Life and Disability Insurance

o  Training, Certification and Continuing Education Support

Base Salary $110,000-170,000 USD PLUS Supplemental Compensation (Bonus) Plan 

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 orientation, status as a protected disabled or Vietnam Era Veteran, disability, or any other legally protected status.


Only registered members can apply for jobs.