Senior Consultant - Data & AI

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. Within a project framework, the Data & AI Senior Consultant is responsible for building client relationships, effectively utilizing Agile project delivery methodologies, implementing scalable and efficient technical architectures to satisfy client requirements, and performing hands-on implementations of Microsoft data solutions for MCA Connect’s current and future customers/projects.

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.
• Able to present how your suggested solution will work and why it should be implemented.
• Able to 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 our partner designations.
• Drives new revenue through successful delivery, client relationships, and some pre-sales support.
• Learning Master Data Management techniques and technologies.
• Learns Data Governance processes and technologies.
• Expertise with database and pipeline performance tuning activities.
• Must be 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 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.

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.