BI Developer

$90,000 - $110,000/Yr

Public Partnerships - Alpharetta, GA

Full-time - Mid Level

Alpharetta, GA

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The BI Developer at Public Partnerships LLC is responsible for designing and building data models, developing Power BI reports and dashboards, and ensuring high performance of analytical datasets for enterprise reporting. This role involves collaboration with Data Engineers and business stakeholders to create optimized data solutions that enable self-service BI and effective data visualization.

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.

Requirements

• Proficiency in Power BI (Dashboards, Reports, Dataflows).
• Experience with SQL Server and Databricks SQL for building analytical models and queries.
• Knowledge of Data Warehousing and ETL pipelines.
• Familiarity with DAX and Power Query for advanced reporting.
• Experience with row-level security (RLS) and column-level security (CLS).
• Understanding of Azure Data Factory and Databricks for orchestrating data pipelines.
• Experience in report automation, data scheduling, and self-service BI.

Benefits

• Competitive salary ranging from $90,000 to $110,000 per year.
• Full-time employment with opportunities for professional growth.