This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more.

Role Description

The Data & AI Senior Consultant is responsible for being a partner to team members, a mentor, and directly enabling growth of the Data & AI Services team at MCA. The Sr. Consultant is expected to lead project implementations, drive innovation, upskill and mentor junior teammates, and partner with leadership to drive continuous improvement.

• Build client relationships
• Utilize Agile project delivery methodologies
• Implement scalable and efficient technical architectures
• Perform hands-on implementations of Microsoft data solutions

Responsibilities

• Lead requirements gathering sessions and documentation of client requirements
• Design and implement dimensional models
• Design, build, maintain, and support complex data integration pipelines
• Design and build Power BI Reports, Dashboards, and Apps
• Present suggested solutions and their implementation rationale
• Identify optimization opportunities and plan implementation
• Mentor junior resources
• Lead working sessions with clients
• Lead and delegate ad hoc requests from clients
• Troubleshoot BI solutions, identify problems, and improve performance and security
• Design Azure DevOps backlog, sprints, and lead delivery
• Oversee project team and source code
• Obtain professional certifications to support partner designations
• Drive new revenue through successful delivery and client relationships
• Learn Master Data Management techniques and technologies
• Learn Data Governance processes and technologies
• Expertise with database and pipeline performance tuning activities
• Open to ~10% travel on an as needed basis

Qualifications

• 5+ years Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake), ETL (ADF Pipelines/SSIS), Analysis Services, DAX, Power BI Pro and Premium and/or equivalent
• 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
• 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 understanding of data governance methodologies
• Excellent communication skills both written and verbal

Desired 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

• 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