Remote Microsoft Data & Analytics Solution Architect

Summary

Join MCA Connect and become a Data & Analytics Solution Architect, leading the Business Requirements, Design, and implementation of Data Warehouse solutions for current and future customers/projects. As a partner to team members, you will support hiring, project implementation, and stability of the Business Analytics business at MCA.

Requirements

• 7+ years Data Warehouse development experience or equivalent
• 7+ years Data Warehousing (Azure/SQL/Synapse), ETL (Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent Data Warehouse platform development experience, such as Oracle Database
• 7+ years of customer facing consulting experience with an understanding of enterprise solutions
• Bachelor’s degree in computer science or equivalent combination of education and experience preferable
• Knowledge of ERP, MRP and CRM data entity structures (OLTP database) desirable
• Multiple database engine and Data Warehouse experience (SQL Server, DB2, Oracle, Teradata)
• Deep knowledge of Data Warehouse Modeling and ETL development
• Familiarity with database performance tuning activities
• Excellent technical, cross group collaboration and customer facing communication skills
• Experience with strategic Data Warehouse consulting with a minimum of 2-4 years in two or more of the following
• Industry experience with a BI focus within an ERP, MRP or CRM Platform
• Data Modeling, ETL and Data Warehouse Consulting experience with a Transactional Solution (OLTP)
• Data Modeling, ETL and Data Warehouse Development using Microsoft SQL Server/Azure Data Services
• Excellent communication skills both written and verbal
• Ability to adjust communication to the level of understanding of the audience

Responsibilities

• Provide Architectural and Design consultative services to clients regarding their preparedness for enterprise levels of Data Warehouse utilizing Microsoft’s Azure Data Services and other RDBMS Platforms
• Implement scalable and maintainable Dimensional Data Models to meet business objectives. Includes accurate Source to Target mapping, construction of ETL and automation of Data Architectures implemented
• Develop and design key performance indicators based on analysis and requirements gathering with the customer
• Document accurate logical design and technical architectural documents for analytics solutions
• Define BI standards, guidelines and best practices for requirements gathering, development and build phase management
• Full BI application lifecycle development, from envisioning of features through to their end development into production
• Work across technologies to design, develop and deliver the best and most practical BI solution given the current customer landscape
• Implement design and software development life cycle using (Agile/ prototyping) concepts and have a strong quality ethic
• Recommend strategies to improve performance and capacity of the customer’s current and future Data Warehouse landscape
• Ability to troubleshoot existing solutions as well as manage the build and train clients on new artifacts
• With Project Management, Identify and resolve issues pertinent to the success of projects, including change management, data flow, application implementation, and issue escalation and resolution
• Continually keep current Data Warehouse knowledge up to date with new features and functionality and share this knowledge to clients through updating current Data Warehouse training offerings and through internal employee communication
• Conduct work sessions with clients in person, by telephone, using desktop video conferencing technology or remote access to client

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