Data Analyst

SmartRecruiters, Inc.; Chennai District; On-site; INR 800,000 - 1,700,000; Full time

Job summary

Sutherland is seeking a Data Engineering & Fabric Development professional to design and implement data pipelines using Microsoft Fabric Data Factory. You will create Lakehouse/Warehouse solutions and manage multi-layer architectures across Bronze, Silver, and Gold data zones.

You will design dimensional models, optimize for analytics, and develop Python-based transformations to support Power BI reporting and KPI definition. Collaboration with business stakeholders is key.

Qualifications

• 3–7 years in Data Analytics, Data Engineering, or BI.
• Hands-on with Microsoft Fabric or Azure analytics.
• Proficiency in dimensional modeling concepts.

Responsibilities

• Design and develop data pipelines with Fabric Data Factory.
• Build Lakehouse/Warehouse solutions in Fabric.
• Develop Bronze, Silver, Gold layer architectures.
• Create scalable ETL/ELT pipelines from multiple sources.
• Monitor pipelines and resolve data quality issues.
• Design Fact and Dimension tables; Star/Snowflake schemas.
• Write complex SQL for data extraction and validation.
• Develop Python data transformation scripts.
• Create datasets for Power BI reporting and KPIs.

Skills

Data Analytics

Data Engineering

Business Intelligence

Power BI

Azure Data Services

Delta Tables

Apache Spark

CI/CD

Git

Data Governance

Education

DP-600 Certification

DP-700 Certification

Tools

Microsoft Fabric

Azure Data Factory

Power BI

Delta Lake

Spark (PySpark)

Job description

Artificial Intelligence. Automation. Cloud Engineering. Advanced Analytics.
For Enterprises, these are key factors of success. For us, they're our core expertise.
We work with global iconic brands. We bring them a unique value proposition through market-leading technologies and business process excellence. At the heart of it all is Digital Engineering - the foundation that powers rapid innovation and scalable business transformation.
We've created 363 unique and independent inventions, 250 of which are AI-based and rolled up under several patent grants in critical technologies. Leveraging our advanced products and platforms, we drive digital transformation at scale, optimize critical business operations, reinvent experiences, and pioneer new solutions, all provided through a seamless "as-a-service" model.
For each company, we provide new keys for their businesses, the people they work with, and the customers they serve. With proven strategies and agile execution, we don't just enable change - we engineer digital outcomes.Sutherland
Digital Outcomes.

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.

Qualifications

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.
• Fact Tables
• Dimension Tables
• 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