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, dynamic 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 refresh PBI Datasets).
-
Collaborate closely with SQL/Data Engineers on normalized schema alignment, ensuring PBI semantic models consume views and transformations correctly - coordinating on dimension views, fact views, and BI schema objects.
-
Connect Data Warehouse and reporting together (Make adjustments in Dataset as necessary - Perform end-to-end data validation and participate in release planning).
-
Produce Technical Design Documents (TDDs) covering dimension views, fact views, BI schema objects, QA approach, and schema alignment documentation.
-
Conduct gap analysis and measures cataloging - documenting existing report inventories, identifying coverage maps, building measures catalogs with calculation logic, and assessing data/feature gaps.
-
Build config-driven / dictionary-driven reporting solutions - avoiding hard-coded business logic, filters, or status semantics in the report layer.
-
Implement Row-Level Security (RLS/RBAC) for Power BI reports across multi-tenant environments.
-
Document development and operational procedures.
-
Engage in Peer Reviews and validate implementations of self and others to ensure they meet requirements and match specifications.
-
Mentor and support colleagues and developers' work positively.
-
Enforce and evolve software development standards and best practices.
-
Troubleshoot reporting issues across the full stack (data source model measure visual).
-
Provide on-call support as necessary.
Job Requirements
Required Education and Experience
-
Bachelor's, Master's degree, or equivalent combination of education and experience.
-
At least 5+ years professional experience in all stages of definition, design, implementation, testing, and deployment of BI solutions using Power BI.
-
Experience in the following tools/technologies: Power BI Desktop, Power BI Service, Azure SQL Elastic Pool, SQL Server.
-
Strong proficiency in Power BI semantic model design - star schemas, relationship optimization, cardinality, and cross-filter direction.
-
Advanced DAX proficiency including:
-
Calculation groups and time intelligence patterns (YTD, MTD, QTD, YoY, rolling periods)
-
Disconnected date table patterns for independent period comparisons
-
Dynamic currency conversion patterns (avoiding per-currency measure duplication)
-
CALCULATE, REMOVEFILTERS, context transition, and iterator functions
-
Strong proficiency in Power Query (M) for data transformation and shaping.
-
Experience with Power BI Service - publishing, workspace management, deployment pipelines, capacity planning, and dataset refresh scheduling.
-
Solid understanding of data warehousing concepts - conformed dimensions, facts, normalized schemas, star schemas.
-
Experience connecting Power BI to various data sources including SQL Server, Azure SQL, Excel, SharePoint, and cloud-based sources.
-
Experience building conformed/shared dimensions across multiple data products or business domains.
-
Experience in development of Data Warehouse, Operational Data Store, and ETL solutions.
-
Ability to produce Technical Design Documents (TDDs) covering data model design, dimension/fact view documentation, and QA approach.
-
Experience implementing RLS/RBAC for Power BI reports in multi-tenant scenarios.
-
Experience with Agile (Scrum) and working closely with Software Development Process and methodologies.
-
Experience with source control such as Git or Azure DevOps and branching/merging best practices.
-
Experience with database management and security a plus.
-
Strong analytical and problem-solving skills.
-
Excellent communication and interpersonal skills.
Required Skills
-
Power BI Report Development
-
Power BI Semantic Model Design (Star Schema)
-
DAX (Calculation Groups, Time Intelligence, Disconnected Date Patterns, Dynamic Currency)
-
Power Query (M)
-
SQL (Queries, Views, Stored Procedures)
-
Technical Design Documentation
-
Data Warehouse Concepts (Conformed Dimensions, Facts, Normalized Schemas)
-
RLS / Row-Level Security
-
Azure SQL / Elastic Pool
-
Power BI Service (Workspaces, Deployment Pipelines, Capacity Management)
Good to Have
-
Azure Data Factory (ADF), Azure Synapse Analytics, Microsoft Fabric, Data APIs, Data Pipelines
-
SSIS, Talend, ETL design and orchestration
-
DBA skills, MongoDB, RedShift, MySQL
-
ALM Toolkit / Tabular Editor / TMDL for model version control and CI/CD
-
Composite Models (DirectQuery + Import hybrid)
-
Power BI Embedded / ISV embedding
-
Power BI Copilot / AI narrative integration
-
Paginated Reports (PBIRS / SSRS) for transactional and scheduled reporting
-
Experience migrating BI solutions from legacy platforms to modern cloud-based architectures
-
Python or R for data analysis
-
Familiarity with other BI tools (Tableau, Qlik)
-
Metadata-driven or dictionary-driven reporting patterns
Work Timings:
Monday through Friday from 12 PM to 9 PM IST to provide healthy overlap between India team and US team and supporting both to ensure adequate collaboration. This role will be working in Hybrid Mode and will require at least 2 days’ work from office at Hyderabad. Occasional evening and weekend work may be expected in case of job-related emergencies or client needs.
EEO Statement:
Cendyn provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Cendyn complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Cendyn expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Cendyn’s employees to perform their job duties may result in discipline up to and including discharge.
Other Duties:
Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.
