Data & Analytics Solution Architect

November 5

Apply Now

Receive Emails with Similar Jobs

MCA Connect

WebsiteLinkedInAll Job Openings

Microsoft Dynamics AX • Microsoft Dynamics CRM • Business Transformation • Managed Services • Microsoft Dynamics 365

201 - 500 employees

💰 Private Equity Round on 2020-07

Description

• Through passion and deep industry expertise, MCA Connect helps manufacturers succeed by unlocking innovation with actionable business insights. • 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. • The Data & Analytics Solution Architect is responsible for being a partner to team members charged with building and growing the Business Analytics business at MCA. • This role expects to support hiring, project implementation and stability of the team as a partner with the Business Analytics director as the business grows. • The Data & Analytics Solution Architect is responsible for leading the Business Requirements, Design and implementation of Data Warehouse and Data Warehouse solutions for MCA Connect’s current and future customers/projects. • Design key performance indicators and analytics. • Responsible for the physical implementation of the entire project as a single team member or leading a team of developers.

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

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