Job Description
The purpose of this role is to support the Business Intelligence and Analytics team by designing, developing, and maintaining interactive dashboards and reports. The position will contribute to translating complex business data into actionable insights, optimizing reporting processes, and supporting informed decision-making across the organization, while also providing opportunities to further enhance analytical and technical expertise.
Strategy
RESPONSIBILITIES
Design, develop, and maintain Power BI dashboards, reports, and datasets.
Connect to various data sources such as SQL Server, Excel, SharePoint, APIs, and cloud databases.
Perform data cleaning, transformation, and shaping using Power Query (M language).
Build efficient data models using star schema, relationships, and calculated tables.Write DAX measures and calculated columns for business logic and KPIs.
Optimize report performance (model size, query folding, visual optimization).
Work closely with business stakeholders to gather requirements and translate them into BI solutions.
Publish reports to Power BI Service, manage workspaces, and configure scheduled refreshes.Implement Row-Level Security (RLS) and access controls.
Troubleshoot data issues and ensure data accuracy and consistency.Document data flows, report logic, and development processes.
Operational
- Design, develop, and maintain interactive Power BI reports, dashboards, and datasets
- Transform and model raw data using Power Query (M) and DAX to support business metrics and KPIs
- Optimize Power BI datasets and reports for performance and usability
- Implement row-level security (RLS) and govern access to sensitive information
- Automate report publishing, refresh schedules, and manage workspaces using Power BI Service and Power BI Gateways
- Participate in data quality validation and ensure reporting accuracy across sources
Product / Process Improvement
- Identify and implement enhancements to existing Power BI dashboards to improve usability, performance, and business impact
- Streamline data integration workflows from Azure and AWS to reduce latency and improve report refresh efficiency
- Collaborate with stakeholders to refine KPIs and metrics, ensuring reports align with evolving business goals and decision-making needs
Education
QUALIFICATIONS
A Bachelor's degree in CS/IT
