Microsoft Data & AI Services Solution Architect

Role 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
• 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 junior resources.
• Lead, design, and implement DevOps and CI/CD solutions.
• Own the project backlog, sprint planning, and task estimations.
• Ensure projects stay on track, within budget, and that the development team is supported.
• Demonstrate the ability to be a key decision maker and strategist.
• Understand 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.
• Understand technology options for batch, streaming, and application integrations.
• Design and create data models that align with the organization's needs and goals.
• Support technical pre-sales conversations, requirements, and estimations.
• Understand Master Data Management approaches and technologies.
• Define project scope, timelines, and resource requirements.
• Be open to ~10% travel on an as-needed basis.

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

Benefits

• 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