Note: The job is a remote job and is open to candidates in USA. MCA Connect is a leading solution partner in Microsoft Business Applications and Azure Data & AI. The Data & AI Senior Consultant is responsible for leading project implementations, mentoring junior teammates, and building client relationships while implementing scalable technical architectures and 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
- 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
- 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
- Knowledge of Microsoft ERP and CRM tools desirable
- 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
Company Overview
Company H1B Sponsorship