{"schemaVersion":"jobsearcher.job.v1","id":"5bd8a0f011de8f1ec6b064c9","url":"https://jobsearcher.com/jobs/5bd8a0f011de8f1ec6b064c9","canonicalUrl":"https://jobsearcher.com/jobs/5bd8a0f011de8f1ec6b064c9","title":"Microsoft Data & AI Services Solution Architect","description":"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.\nEstablished 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.\n\nTitle Data & AI Solution Architect\nLocation Virtual, home based office with travel (20%)\nDescription\nThe 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.\nWithin 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.\nResponsibilities\nWork across Microsoft technologies in Azure and On-Prem to design, develop and deliver solutions that satisfy client requirements.\nDesign and document scalable, secure, and efficient data integration and analytics architectures.\nPerform complex organization wide analysis and create a Data Strategy to support client specific needs.\nEffectively communicate the data strategy, implementation plan, and associated costs.\nMentor's junior resources.\nLeads, designs, and implements DevOps and CI/CD solutions.\nOwns the project backlog, sprint planning, and task estimations.\nResponsible for ensuring projects stay on track, within budget, and that the development team is supported.\nDemonstrates the ability to be a key decision maker and strategist.\nUnderstands Data Governance techniques and MCA “Go To Market” Technologies & common Architecture Designs.\nObtain professional certifications to support our partner designations.\nOversee project team and source code.\nUnderstands technology options for batch, streaming, and application integrations\nResponsible for designing and creating data models that align with the organization's needs and goals.\nSupports technical pre-sales conversations, requirements, and estimations.\nUnderstands Master Data Management approaches and technologies.\nDefines project scope, timelines, and resource requirements.\nMust be open to ~10% travel on an as needed basis.\nRequired Qualifications\n7+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent.\n2+ years working in a Data Architect capacity.\nFamiliarity with big data and event driven technologies like Hadoop, Spark, Kafka, Event Hubs, and Service Bus architectures.\nHigh level understanding of various Azure cloud data platforms and services.\nDemonstrated experience in designing and implementing data solutions for complex business problems.\nExperience working on projects involving large volumes of data, preferably in the Manufacturing industry.\nExperience migrating data processing workloads from on-premises to Azure cloud technologies.\nDemonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties.\nBachelor’s degree in computer science or equivalent combination of education and experience preferable.\nKnowledge of Microsoft ERP and CRM tools desirable.\nKimball Dimensional Modeling and batch/incremental ETL development approaches.\nExperience with database performance tuning activities.\nExperience developing and managing data quality monitoring and an understanding of data governance methodologies.\nExcellent communication skills both written and verbal.\nAdditional annual supplemental compensation $20,000 - 30,000 (paid quarterly)\nWhy work for MCA Connect?\nOur compensation plan offers one of the best bonus structures in the industry. Along with this we also offer a generous benefit package:\n\nWork/Life Balance with Unlimited Paid Time Off (UPTO)\n401k Plan with Company Matching Contribution\nMonthly Stipend for Home Office Expenses\nSubsidized Medical, Dental and Vision Coverage\nHealth Savings and Flexible Spending Accounts\nCompany Paid Life and Disability Insurance\nTraining, Certification and Continuing Education Support\n\nMCA 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.\n\nMCA 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!\nWe may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.","company":"Mcaconnect","rawCompany":"mcaconnect","city":"Remote","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-08-06T16:24:50.844Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541690","title":"Other Scientific and Technical Consulting Services","slug":"other-scientific-and-technical-consulting-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Microsoft Data & AI Services Solution Architect","description":"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.\nEstablished 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.\n\nTitle Data & AI Solution Architect\nLocation Virtual, home based office with travel (20%)\nDescription\nThe 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.\nWithin 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.\nResponsibilities\nWork across Microsoft technologies in Azure and On-Prem to design, develop and deliver solutions that satisfy client requirements.\nDesign and document scalable, secure, and efficient data integration and analytics architectures.\nPerform complex organization wide analysis and create a Data Strategy to support client specific needs.\nEffectively communicate the data strategy, implementation plan, and associated costs.\nMentor's junior resources.\nLeads, designs, and implements DevOps and CI/CD solutions.\nOwns the project backlog, sprint planning, and task estimations.\nResponsible for ensuring projects stay on track, within budget, and that the development team is supported.\nDemonstrates the ability to be a key decision maker and strategist.\nUnderstands Data Governance techniques and MCA “Go To Market” Technologies & common Architecture Designs.\nObtain professional certifications to support our partner designations.\nOversee project team and source code.\nUnderstands technology options for batch, streaming, and application integrations\nResponsible for designing and creating data models that align with the organization's needs and goals.\nSupports technical pre-sales conversations, requirements, and estimations.\nUnderstands Master Data Management approaches and technologies.\nDefines project scope, timelines, and resource requirements.\nMust be open to ~10% travel on an as needed basis.\nRequired Qualifications\n7+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent.\n2+ years working in a Data Architect capacity.\nFamiliarity with big data and event driven technologies like Hadoop, Spark, Kafka, Event Hubs, and Service Bus architectures.\nHigh level understanding of various Azure cloud data platforms and services.\nDemonstrated experience in designing and implementing data solutions for complex business problems.\nExperience working on projects involving large volumes of data, preferably in the Manufacturing industry.\nExperience migrating data processing workloads from on-premises to Azure cloud technologies.\nDemonstrated the ability to communicate effectively with technical teams, business stakeholders, and other relevant parties.\nBachelor’s degree in computer science or equivalent combination of education and experience preferable.\nKnowledge of Microsoft ERP and CRM tools desirable.\nKimball Dimensional Modeling and batch/incremental ETL development approaches.\nExperience with database performance tuning activities.\nExperience developing and managing data quality monitoring and an understanding of data governance methodologies.\nExcellent communication skills both written and verbal.\nAdditional annual supplemental compensation $20,000 - 30,000 (paid quarterly)\nWhy work for MCA Connect?\nOur compensation plan offers one of the best bonus structures in the industry. Along with this we also offer a generous benefit package:\n\nWork/Life Balance with Unlimited Paid Time Off (UPTO)\n401k Plan with Company Matching Contribution\nMonthly Stipend for Home Office Expenses\nSubsidized Medical, Dental and Vision Coverage\nHealth Savings and Flexible Spending Accounts\nCompany Paid Life and Disability Insurance\nTraining, Certification and Continuing Education Support\n\nMCA 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.\n\nMCA 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!\nWe may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.","datePosted":"2026-08-06T16:24:50.844Z","dateModified":"2026-08-06T16:24:50.844Z","hiringOrganization":{"@type":"Organization","name":"Mcaconnect","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Remote","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"5bd8a0f011de8f1ec6b064c9"},"url":"https://jobsearcher.com/jobs/5bd8a0f011de8f1ec6b064c9"}}