Source description
About the role
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. - Robust 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 This role i
More at Cendyn