Senior Software Engineer Power BI Developer

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

• Bachelors Masters 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 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 Cendyns 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.