Sr Consultant
Sr Consultant
Job Summary
To lead a group of Junior Analysts. Deliver projects within timelines in collaboration with internal/external stakeholders
- Design Fabric architectures: OneLake, Lakehouse/Warehouse, medallion layering, workspace strategy, and capacity planning.
- Build pipelines using Data Factory, Dataflows Gen2, and PySpark notebooks, including incremental and CDC loads.
- Deliver Power BI semantic models using Direct Lake and optimised DAX.
- Implement governance and security with Microsoft Purview, OneLake security, and RLS.
- Set up CI/CD with Git integration and deployment pipelines.
- Monitor and optimise capacity usage and cost.
- Lead migrations from Synapse, ADF, or on-prem SQL to Fabric.
- Mentor engineers and support estimates and solution proposals.
Key Responsibilities
2. Prepare And Develop Documentation For Tools And Project Processes To Support The Lead Trainer And Team Lead. Define Deliverables And Measures For The Project. Track Metrics At And Engagement And Individual Level And Monitor Timelines / Milestones
3. Prepare Periodic Report. Escalate And Solve Challenges With Respect To Projects In Coordination With Internal/External Stake Holders
4. Oversee A Small Group Of Project Team Who Are Responsible To Optimize Work Allocation To Maximize And Balance The Broad Set Of Goals Defined By The Team Leads
Skill Requirements
- 10+ years in data platforms, with 3+ years in an architect or lead role.
- Production delivery experience on Microsoft Fabric.
- Strong Azure data stack: ADF, Synapse, ADLS Gen2, Azure SQL.
- Expert SQL and PySpark; dimensional modelling; Delta Lake.
- Advanced Power BI and DAX.
- Microsoft Purview and data governance experience.
- Strong stakeholder communication.