Public Partnerships
BI Developer
Public Partnerships, Denver, Colorado, United States, 80285
Key Responsibilities: Collaborate with Data Engineers to design and build data models within Databricks SQL Create optimized external tables for serving data from the Gold layer to BI tools. Develop and maintain analytical datasets for enterprise reporting and self-service BI. Design and develop Power BI reports and dashboards. Enable business users to extract data through self-service extracts. Implement row-level security (RLS) and column-level security (CLS) in Power BI. Create compelling data visualizations using Power BI for enterprise analytics. Ensure high performance of reports and dashboards through proper data modeling. Automate the scheduling and publishing of Power BI reports. Monitor and optimize Power BI datasets and dataflows for performance. Work closely with business stakeholders to gather reporting requirements. Document the data models, metrics, and KPI definitions. Technical Skills: Power BI (Dashboards, Reports, Dataflows). SQL Server and Databricks SQL for building analytical models and queries. Data Warehousing and ETL pipelines. DAX and Power Query for advanced reporting. Row-level security (RLS), column-level security (CLS). Azure Data Factory and Databricks for orchestrating data pipelines. Report automation, data scheduling, and self-service BI Public Partnerships is an Equal Opportunity Employer dedicated to celebrating diversity and intentionally creating a culture of inclusion. We believe that we work best when our employees feel empowered and accepted, and that starts by honoring each of our unique life experiences. At PPL, all aspects of employment regarding recruitment, hiring, training, promotion, compensation, benefits, transfers, layoffs, return from layoff, company-sponsored training, education, and social and recreational programs are based on merit, business needs, job requirements, and individual qualifications. We do not discriminate on the basis of race, color, religion or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, past or present military service, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law. PPL will not tolerate discrimination or harassment based on any of these characteristics. PPL does not discriminate based on race, color, religion, or belief, national, social, or ethnic origin, sex, gender identity and/or expression, age, physical, mental, or sensory disability, sexual orientation, marital, civil union, or domestic partnership status, protected veteran status, citizenship status, family medical history or genetic information, family or parental status, or any other status protected under federal, state, or local law.