Senior Consultant – Data, AI
Posted 12ds ago
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data & AI Senior Consultant driving project implementations and mentoring teams at MCA Connect. Focusing on business insights and innovation for manufacturing companies.
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.
Requirements:
- 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.
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




