AIP Connect

Senior Consultant, Microsoft Data & Analytics

Remote

Not SpecifiedCompensation
Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Data & Analytics, Cloud Computing, Business IntelligenceIndustries

Position Overview

  • Location Type: Remote (US, CA)
  • Employment Type: Full-time
  • Salary: (Not provided in the text)

MCA Connect is a leading solution partner for Microsoft Business Applications and Azure Data & AI / Digital & App Innovation. We are seeking a Data & Analytics Senior Consultant to join our Manufacturing Intelligence team and drive project implementations, innovation, and mentorship. This role involves leading project delivery, building client relationships, and implementing scalable data solutions.

Requirements

  • 5+ years of experience in Data Warehousing (Azure/SQL/Synapse/Spark/Delta Lake)
  • Experience with ETL tools (ADF Pipelines/SSIS)
  • Proficiency in Power BI (Reports, Dashboards, and Apps)
  • Strong communication and presentation skills
  • Experience with Agile project delivery methodologies
  • Ability to identify optimization opportunities and plan implementation
  • Professional certifications (desired)

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 proposed solutions and justify implementation.
  • 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, client relationships, and some pre-sales support.
  • Learning Master Data Management techniques and technologies.
  • Learning Data Governance processes and technologies.
  • Expertise with database and pipeline performance tuning activities.

Company Information

  • Company: MCA Connect
  • Established: 2002
  • Industry: Microsoft Partner Solutions (Finance and Supply Chain, Analytics on Azure, Data Warehouse Migration, Power Platform)
  • Awards: Fifteen-time Microsoft Partner of the Year, Three-time Inc. Best Workplaces award winner.

Skills

Azure
SQL
Synapse
Spark
Delta Lake
ADF Pipelines
SSIS
Power BI
Data Warehousing
ETL
Agile
Azure DevOps
Data Governance
Master Data Management
Database Performance Tuning
Pipeline Performance Tuning

AIP Connect

Facilitates connections among like-minded individuals

About AIP Connect

AIP Connect specializes in connecting individuals and organizations that share similar interests and goals. The team at AIP is composed of skilled connectors who leverage their extensive network and industry knowledge to facilitate meaningful relationships. They focus on understanding the unique needs of each party to ensure a suitable match. Unlike many competitors, AIP Connect emphasizes integrity and an open approach in their interactions, which helps build trust and long-lasting connections. The primary goal of AIP Connect is to create a community where like-minded individuals can collaborate and thrive together.

None, CanadaHeadquarters
2006Year Founded
VENTURE_UNKNOWNCompany Stage
ConsultingIndustries
11-50Employees

Benefits

Professional Development Budget
Flexible Work Hours

Risks

AI-driven platforms may reduce demand for traditional recruitment services.
Remote work shifts require talent with specific skills, challenging AIP Connect's candidate pool.
Economic uncertainty slows hiring, impacting demand for recruitment services.

Differentiation

AIP Connect excels in staffing, consultation, marketing, outsourcing, and recruitment services.
The team is known for integrity, open approach, and powerful industry network.
AIP Connect focuses on finding the right 'fit' for clients and candidates.

Upsides

Remote work trends boost demand for AIP Connect's flexible talent solutions.
AI in recruitment enhances AIP Connect's candidate screening and matching efficiency.
Diversity initiatives increase demand for AIP Connect's diverse talent pools.

Land your dream remote job 3x faster with AI