The Data & AI Solution Architect leads project implementations, mentors team members, supports pre-sales efforts, and designs scalable data architectures.
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.
Title Data & AI Solution Architect
Location Virtual, home based office with travel (10%)
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.
Responsibilities
- 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.
Required Qualifications
- 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.
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
Adf Pipelines
Azure
Dax
Delta Lake
Event Hubs
Hadoop
Kafka
Microsoft Crm
Microsoft Erp
Power BI
Spark
SQL
Ssis
Synapse
Similar Jobs
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
The Regional Sales Manager drives sales of DMS solutions, generates new revenue, manages relationships with dealers, and achieves sales targets while traveling extensively across the assigned territory.
Top Skills:
CRMDealer Management System (Dms) Solutions
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
The Senior Data Scientist will lead advanced analytics and AI/ML model development, collaborating on projects, mentoring junior members, and applying statistical expertise for strategic insights.
Top Skills:
AWSPower BIPythonPyTorchScikit LearnSQLTableauTensorFlow
Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Lead the content strategy for environmental advocacy at Cox, oversee storytelling across multiple formats, manage partnerships, and track performance metrics.
Top Skills:
Brand ManagementContent StrategyDigital AssetsEditorial StandardsPerformance MetricsStorytelling
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
