Leads the team this role joins
Decides on early hires
Runs hiring at the company
From your own Gmail and LinkedIn.
About the role
This is a full-time senior consulting role for a data and AI specialist on Microsoft platforms, open to remote candidates anywhere. You will design data platforms and Power BI solutions and lead client delivery for MCA Connect. The role requires at least five years of data warehousing experience with Azure, SQL and related tools.
What you’ll do
- Gather client requirements and document business and technical needs.
- Design dimensional data models and scalable architectures.
- Build and support data integration pipelines.
- Design and develop Power BI reports, dashboards and apps.
- Manage Agile delivery using Azure DevOps backlogs and sprints.
- Mentor junior consultants and support pre-sales work.
What they’re looking for
- Five or more years of data warehousing experience with Azure, SQL, Synapse, Spark or Delta Lake.
- ETL development using ADF pipelines, SSIS, and batch or incremental approaches.
- Experience with Analysis Services, DAX, Power BI Pro and Premium.
- Knowledge of Kimball dimensional modelling.
- Strong database and pipeline performance tuning.
- Ability to communicate with technical teams and business stakeholders.
Nice to have
- A bachelor's degree in computer science or equivalent experience.
- Microsoft ERP or CRM knowledge.
- Manufacturing industry experience.
What’s on offer
- Industry-leading bonus structure.
- Unlimited paid time off.
- 401(k) with company matching.
- Monthly home-office stipend.
- Subsidised medical, dental and vision cover.
- Health savings and flexible spending accounts.
- Company-paid life and disability insurance.
- Training, certification and continuing-education support.
Skills
Questions about this role
Is this role remote?
The role is listed as anywhere, and the work mode is remote.
How many years of experience do I need?
At least five years of data warehousing experience with Azure and SQL tools.
Do I need a degree?
A bachelor's degree is preferred, but equivalent education and experience is accepted.
What benefits are offered?
Bonus, unlimited PTO, 401(k) matching, home-office stipend, health cover and training support.