Job Description

Job Purpose
This role is responsible for designing, implementing, testing, and delivering BI reporting solutions using Power BI, building semantic models connected to Data Warehouse infrastructure replicated via Azure SQL Elastic Pool. The developer will work across multiple products using conformed dimensions and a common data model approach, delivering analytics that serve diverse business needs.

Job Responsibilities
Essential Functions
- Collaborate with Product, other developers, SQL/Data Engineers, and architects to design, build, and maintain Power BI reporting services across multiple products.
- Understand the business needs including existing reports and types (Standard, Scheduled, Transactional, Subscriptions).
- Determine operational feasibility by evaluating requirements, analysis, problem definition, solution development, and proposed solutions.
- Build Power BI reports for various products (multi-product) based on a common data model with conformed/shared dimensions.
- Design and build Power BI semantic models with star schemas,



defining and optimizing relationships, cardinality, and cross-filter direction.
- Define the Dataset for use in Data Warehouse including Data Content (Facts, Dimensions, Measures, Standard Calculations).
- Implement advanced DAX patterns including disconnected date tables for independent period comparisons, agile currency conversion (no hard-coded currency duplication), calculation groups, and time intelligence (YTD, MTD, QTD, YoY, rolling periods, variance).
- Build Development Datasets and Report Wireframes (Define the Star Schema, Build Development Dataset with dummy data exclusively used by Power BI Dataset, Define Reports and Views, Create Wireframe for Reports and Views).
- Understand and work with Data Warehouse components (Database Replication, Structured Views to reshape data, Stored Procedures, and Azure Data Factory Pipelines to convert data daily, Azure Elastic Pool Jobs to schedule tasks and ref

📌 Senior Software Engineer (Hyderabad)
🏢 Cendyn
📍 Hyderabad