Data Engineer - Data Warehouse Power BI API Development

ABOUT THE ORGANIZATION

StarUnion Dai-ichi Life Insurance (SUD Life) is a joint venture formed in 2007between two major Indian PSU banks - Bank of India and Union Bank of India -and Japan's Dai-ichi Life Holdings.

We haveserved over 15 million customers through more than 19, 500 bank branches acrossIndia. Our network includes 1, 950 rural bank branches, ensuring insurancereaches remote areas.

SUD Lifefocuses on creating insurance products that meet different customer needsacross all segments of society. With our promoters' 100+ years of commitmentand combined strengths, we aim to become a leading name in India's lifeinsurance sector while delivering value to all stakeholders.

Establishedin 1902, Dai-ichi Life is the second largest life insurance company of Japanand is one of the top ten life insurers globally, renowned for sound productknowledge, superior asset management skills, and strong operationalcapabilities to manage life insurance businesses.

At SUDLife, our customers are our priority. We are committed to providing insuranceproducts that serve our customers unique needs across various strata ofsociety and geographies.

Thepromoters of SUD Life have a long-term commitment towards their customers andstakeholder. These strengths and values have been inherited by SUD Life, as wemake our way to becoming the next rising star in the Indian life insurancebusiness, promising exceptional value to all.

To know more about us please visit:

Our Website: https://www.sudlife.in/

Our LinkedIn Page: https://www.linkedin.com/compan y/13201422

Our Talent Philosophy

At Star Union Dai-ichi Life Insurance, we will ensure to nurture our people and provide opportunities to learn, succeed and build careers to the best of their abilities, thus creating andunlocking value for self, the organization, and the society at large.

About the Role

Function: IT Data & AI

Role: Data Engineer (Data Warehouse, Power BI & API Development)

Experience: 4 to 7 years

Location: Navi Mumbai

Employment Type: Full-time

Job Overview:

The incumbent will be responsiblefor the design, development, modernization, integration and productionsupport of enterprise data and analytics platforms, covering On-PremisesDWH, Microsoft Fabric, API/application services, Power BI, semantic models andanalytics.

The rolerequires strong hands-on capabilities across the complete technology lifecycle:

SourceSystems APIs & Integration DWH/Fabric Semantic Layer Power BI/MIS

Thecandidate should be capable of building enterprise-grade solutions whileensuring scalability, performance, security, data quality, automation, monitoring and production reliability.

1. DWH On-Premises & Microsoft Fabric

Key Responsibilities

• Design, develop and support enterprise data warehouse solutions across On-Premises and Microsoft Fabric .

• Build scalable ETL/ELT and data-integration frameworks for structured and semi-structured enterprise data.

• Design Lakehouse, Warehouse and Medallion architecture patterns based on solution requirements.

• Develop and maintain ingestion, transformation and orchestration pipelines.

• Build curated data layers for operational MIS, regulatory reporting, management reporting, Power BI, APIs consumption.

• Perform complex data transformation using SQL/T-SQL, Spark/PySpark and Fabric-native technologies.

• Modernize/migrate existing on-premises data warehouse workloads to Microsoft Fabric.

• Perform performance optimization of SQL, pipelines, data models and Fabric workloads.

• Monitor DWH jobs, pipelines and production data processing, including root-cause analysis of failures.

• Implement appropriate security, access control, governance, deployment and monitoring practices.

2. API Development & Application Support

Key Responsibilities

• Design, develop, enhance and support enterprise APIs and data/application integration services.

• Build RESTful APIs and services for integration between enterprise applications, DWH, analytics platforms and downstream consumer systems.

• Implement authentication, authorization, validation, structured logging and appropriate error handling.

• Support APIs used by customer-facing and internal enterprise applications.

• Investigate API failures, performance degradation, integration issues and data discrepancies.

• Manage API testing, release, deployment and post-production monitoring.

3. Power BI Dashboard Development

Key Responsibilities

• Design and develop enterprise-grade Power BI dashboards and analytical reports .

• Convert complex business requirements into intuitive management and operational dashboards.

• Develop KPIs, measures, calculations, drill-through and analytical views.

• Implement advanced DAX calculations.

• Develop reports connecting to Microsoft Fabric and enterprise data sources.

• Modernize legacy/static MIS into Power BI solutions where appropriate.

• Implement Row-Level Security and appropriate report access controls.

4. Semantic Model Design & Development

Key Responsibilities

• Design enterprise semantic models as the standardized consumption layer between enterprise data and reporting.

• Develop reusable dimensions, measures, calculations, relationships and hierarchies.

• Establish common KPI definitions and business logic across reports.

• Develop scalable star-schema-based semantic models.

• Implement advanced DAX measures and calculation logic.

• Support Direct Lake, Import and DirectQuery scenarios based on appropriate architecture.

• Implement model-level data security.

Core Technical Skills Required:

Data Engineering & Analytics:
Microsoft Fabric, SQL/T-SQL, Data Warehousing, Lakehouse/WarehouseArchitecture , OneLake, ETL/ELT, Data Pipelines, Power BI, DAX, Semantic Models.

Modern Data Engineering & AI:
PySpark, Apache Spark, Delta Lake, Medallion Architecture, Fabric Notebooks, Direct Lake, KQL, Python, Fabric Data Agents, Copilot Studio, Foundry, LLMConcepts, MCP, Conversational Analytics.

API & Integration:
Java, Spring Boot, REST APIs, Microservices, OpenAPI/Swagger, JPA/Hibernate, GraphQL, OAuth 2.0, JWT, Entra ID, API Management.

DevOps & Production Support:
Git, CI/CD, Deployment Automation, API Testing, Monitoring, Logging, Troubleshooting, Performance Optimization, L2/L3 Support.

Qualification & Experience: