Data Analyst

• Design and develop data pipelines using Microsoft Fabric Data Factory
• Create and maintain Lakehouse and Warehouse solutions within Microsoft Fabric
• Implement and manage Bronze, Silver, and Gold Layer architectures
• Develop scalable ETL/ELT pipelines for ingesting and transforming data from multiple sources
• Monitor pipeline performance and troubleshoot data quality issues
• Design and develop Fact Tables and Dimension Tables following dimensional modeling principles
• Create and maintain Star Schema and Snowflake Schema data models
• Define surrogate keys, business keys, and Slowly Changing Dimensions (SCD) where required
• Optimize data models for reporting and analytics performance
• Write complex SQL queries for data extraction, transformation, and validation
• Build views, stored procedures, and reusable query frameworks
• Perform query optimization and performance tuning
• Develop Python-based data transformation and validation scripts using Pandas, NumPy, PySpark, and Requests
• Automate data quality checks and reconciliation processes
• Partner with business stakeholders to gather reporting and analytics requirements
• Develop datasets optimized for Power BI reporting
• Support creation of KPIs, metrics, and business data definitions
• Ensure data governance and consistency across analytical solutions