Note: The job is a remote job and is open to candidates in USA. MCA Connect helps manufacturers succeed through Microsoft Business Applications, Azure Data & AI, and digital innovation solutions. The Senior Consultant leads Data & AI project implementations, develops scalable Microsoft data solutions, manages client relationships, and mentors junior team members. The role also supports innovation, performance optimization, delivery leadership, and pre-sales activities.
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
Skills
- 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
- Must be open to ~10% travel on an as needed basis
- 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
- Bonus structures
- 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
Company Overview
Company H1B Sponsorship