Data & Analytics Solution Architect

Summary

Join MCA Connect as a Data & Analytics Solution Architect and partner with team members, mentor junior colleagues, and directly contribute to the growth of the Manufacturing Intelligence team. Support pre-sales activities, lead project implementations, drive innovation, and collaborate with leadership for continuous improvement. Responsibilities include building client relationships, leading delivery teams using Agile methodologies, designing efficient technical architectures, and performing hands-on implementations of Microsoft data solutions. You will also be responsible for ensuring projects stay on track and within budget, while demonstrating strong decision-making and strategic thinking skills. The role requires extensive experience with Microsoft technologies and data warehousing, along with strong communication and leadership abilities. Travel is expected to be approximately 10%.

Requirements

• 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

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

Preferred Qualifications

• Committed to mentoring and upskilling teammates
• Committed to learning, exploring new ideas, and staying at the leading edge
• Creativity to initiate new ideas and think out of the norm
• Committed to quality and ability to solve customer problems without conflict

Benefits

• $110,000 - $170,000 a year
• PLUS Uncapped Supplemental Compensation (Bonus) Plan paid out quarterly
• 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