Data Analyst

Data Engineering & Fabric Development

• 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.

Data Modeling

• 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.

SQL Development

• Write complex SQL queries for data extraction, transformation, and validation.
• Build views, stored procedures, and reusable query frameworks.
• Perform query optimization and performance tuning.

Python Development

• Develop Python-based data transformation and validation scripts.
• Use libraries such as:
  • Pandas
  • NumPy
  • PySpark
  • Requests
• Automate data quality checks and reconciliation processes.

Analytics & Reporting

• 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.

Our most successful candidates will have:

• 3-7 years of experience in Data Analytics, Data Engineering, or Business Intelligence.
• Minimum 2 years of hands-on experience with Microsoft Fabric or Azure-based analytics platforms.
• Proven experience building:
  • Fact Tables
  • Dimension Tables
  • Data Pipelines
  • Power BI datasets

• Experience with Microsoft Azure Data Services.
• Experience with Delta Tables and Apache Spark.
• Familiarity with CI/CD and Git-based development.
• Understanding of data governance and lineage concepts.
• Microsoft Fabric Certification preferred:
  • DP-600
  • DP-700