MS Fabric Data and SQL Engineer

Responsibilities

• Design and implement Lakehouse architecture using OneLake, Lakehouse, and Fabric Data Warehouse
• Build Bronze / Silver / Gold data layers using Delta tables and medallion architecture
• Migrate and modernize legacy SQL Server / SSIS workloads to Microsoft Fabric Pipelines and Notebooks
• Analyze and study existing stored procedures, views, functions, triggers, and SQL jobs within on-prem SQL Server
• Reverse-engineer complex business and calculation logic embedded in database objects
• Document logic in a clear, structured manner suitable for Workday re-implementation
• Produce functional descriptions, data mappings, and dependency documentation
• Collaborate with functional and HRIS teams
• Support clarification of legacy logic during development and migration activities
• Identify redundant or obsolete logic and highlight simplification opportunities

Requirements

• 3+ years of experience
• Minimum 1 year of experience with MS Fabric
• Proficiency in Fabric Data Pipelines, PySpark, Spark SQL notebooks, and Dataflows Gen2
• Experience with MS SQL Server 2016 and advanced T-SQL (Stored Procedures, Functions, Views, Triggers)
• Strong understanding of complex joins, CTEs, and query optimization
• Excellent analytical and documentation skills
• Ability to translate technical SQL logic into functional documentation

Preferred Qualifications

• Knowledge of .Net
• Experience with SSIS or PowerBI
• Agile delivery experience

About the Company

Tibil Solutions is an IT consulting and data engineering company founded in 2010 that specializes in artificial intelligence, analytics, cloud data platforms, and business intelligence solutions.