About the role
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
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.
Originally posted on Himalayas