As a Data Tech Lead, you will be the technical authority for the company’s analytical data foundation built on Microsoft Fabric.
Your primary mission is to design and enforce high-quality dimensional models following Kimball methodology, ensuring analytical consistency, scalability, and performance across the platform.
You will lead the implementation of robust SQL / T-SQL transformation layers, establish strong CI/CD practices using Azure DevOps, and guarantee optimal Microsoft Fabric capacity utilization through precise workload governance and cost optimization.
You will act as the reference expert for data modeling standards, transformation engineering, and Fabric platform efficiency.
Highly hands-on, you will work on a major consolidation project involving sales and operational data to create a scalable, reliable, and modern data foundation.
You will define technical architecture, lead engineering best practices, and collaborate closely with data source owners. Strong communication and synthesis skills are essential, as you will regularly provide clear, structured updates to management.
Your Key responsibilities :
Dimensional Modeling Leadership :
- Design and enforce enterprise-wide dimensional modeling standards based on Kimball methodology.
- Build and validate star schemas, fact tables, conformed dimensions, and Slowly Changing Dimensions (SCD).
- Ensure analytical consistency across domains (sales, operations, etc.).
- Guarantee semantic clarity and business-aligned modeling structures.
- Conduct systematic model reviews to ensure scalability, maintainability, and performance.
- Act as the internal authority on data warehouse best practices.
Advanced SQL / T-SQL Engineering:
- Develop high-performance SQL / T-SQL transformations on large-scale datasets.
- Optimize complex queries for computing efficiency and scalability.
- Structure transformation layers with clarity, modularity, and maintainability.
- Implement robust data quality checks and reconciliation logic.
- Establish SQL coding standards and performance benchmarking practices.
Python Development Notions:
- Create and maintain a toolbox of python scripts available to IT stakeholders to accelerate data collection.
- Guide and support IT stakeholders in using the toolbox.
Collaboration, Communication & Project Steering:
- Work closely with data source owners (IT, business teams, external partners) to understand systems and secure integrations.
- Clarify requirements, challenge assumptions, and structure technical discussions.
- Provide concise progress summaries, risks, and key decisions to management.
- Coordinate with Data Engineers, Data Analysts and Business Analysts.
Transformation Framework & dbt-core Discipline:
- Design and maintain modular transformation workflows.
- Leverage dbt-core where applicable for version-controlled, testable transformations.
- Define naming conventions, dependency management, and documentation standards.
Microsoft Fabric Platform & Capacity Governance:
- Design and operate Microsoft Fabric Warehouse / Lakehouse environments.
- Define a capacity sizing strategy based on workload characteristics.
- Monitor and optimize Fabric capacity utilization.
- Manage workload distribution across capacities and workspaces.
- Ensure cost-performance balance through proactive pricing governance.
- Implement observability mechanisms to track compute and storage consumption.
CI/CD & Azure DevOps Leadership:
- Design and maintain CI/CD pipelines for data artifacts (models, SQL objects, semantic layers).
- Define branching strategies and release management processes.
- Manage artifact lifecycle across development, test, and production environments.
- Automate deployment processes and enforce quality gates.
- Ensure traceability and reproducibility of platform changes.
Technical Leadership & Engineering Governance:
- Mentor Data Engineers on modeling rigor and SQL optimization techniques.
- Lead architecture and code reviews.
- Define and maintain documentation standards.
- Promote a culture of engineering excellence and continuous improvement.
- Provide technical decision rationales to stakeholders when required.