Microsoft Data & AI Services Solution Architect

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.