> Markdown version of [/jobs/ext/1730975-data-ai-solution-architect](https://www.wearedevelopers.com/jobs/ext/1730975-data-ai-solution-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data & AI Solution Architect - **Company:** Mca Connect - **Location:** Denver, CO, United States (Remote available) - **Experience:** Expert - **Salary:** $120,000.0 - $170,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Azure, Big Data, Continuous Integration, Data Architecture, Data Governance, Data Integration, Extract Transform Load (ETL), Data Systems, Data Warehousing, DevOps, Dimensional Modeling, Event-Driven Programming, Apache Hadoop, Microsoft Data Access Components, Microsoft Software, Scrum Methodology, Power BI, SQL Databases, SQL Server Integration Services, Azure Service Bus, Database Optimization, Apache Spark, Data Strategy, Data Lakes, Information Technology, Apache Kafka, Data Management - **Published:** July 23, 2026 - **Apply:** https://jobs.lever.co/mcaconnect/58f44609-b05d-42cb-aa85-5f3616eab884/apply?lever-origin=applied&lever-source%5B%5D=BuiltInNationwide ## About the Role * 7+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent. * 2+ years working in a Data Architect capacity. * Familiarity with big data and event driven technologies like Hadoop, Spark, Kafka, Event Hubs, and Service Bus architectures. * High level understanding of various Azure cloud data platforms and services. * Demonstrated experience in designing and implementing data solutions for complex business problems. * Experience working on projects involving large volumes of data, preferably in the Manufacturing industry. * Experience migrating data processing workloads from on-premises to Azure cloud technologies. * 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. * Experience with database performance tuning activities. * Experience developing and managing data quality monitoring and an understanding of data governance methodologies. * Excellent communication skills both written and verbal. ## Description The Data & AI Solution Architect is responsible for being a partner to team members, a mentor, and directly enabling growth of the Data & AI Services team at MCA. The Solution Architect is expected to support pre-sales efforts, lead project implementations, drive innovation, upskill and mentor junior teammates, and partner with leadership to drive continuous improvement. Within a project framework, the Data & AI Solution Architect is responsible for building client relationships, leading delivery teams, effectively utilizing Agile project delivery methodologies, designing 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., * Work across Microsoft technologies in Azure and On-Prem to design, develop and deliver solutions that satisfy client requirements. * Design and document scalable, secure, and efficient data integration and analytics architectures. * Perform complex organization wide analysis and create a Data Strategy to support client specific needs. * Effectively communicate the data strategy, implementation plan, and associated costs. * Mentor's junior resources. * Leads, designs, and implements DevOps and CI/CD solutions. * Owns the project backlog, sprint planning, and task estimations. * Responsible for ensuring projects stay on track, within budget, and that the development team is supported. * Demonstrates the ability to be a key decision maker and strategist. * Understands Data Governance techniques and MCA "Go To Market" Technologies & common Architecture Designs. * Obtain professional certifications to support our partner designations. * Oversee project team and source code. * Understands technology options for batch, streaming, and application integrations * Responsible for designing and creating data models that align with the organization's needs and goals. * Supports technical pre-sales conversations, requirements, and estimations. * Understands Master Data Management approaches and technologies. * Defines project scope, timelines, and resource requirements. * Must be open to ~10% travel on an as needed basis. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [MLOps – What’s the deal behind it?](https://www.wearedevelopers.com/magazine/125-mlops-what-s-the-deal-behind-it)