Data Analyst

Sutherland

full-time mid Chennai, //TN, India · More jobs in Chennai, Tamil Nadu, India Remote

This position is sourced from Sutherland's career page . Apply through Job-Scouts to track your application status.

Job Description

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.