Power BI Developer

DataGraders is seeking a skilled Power BI Developer with 2 to 4 years of experience to join its Data & Analytics team in Lahore. The ideal candidate will manage the entire Power BI development lifecycle, including connecting directly to source systems, extracting and transforming data, building data models, developing dashboards, deploying solutions, and optimizing performance. A strong emphasis is placed on hands-on experience with data extraction from various source systems, ensuring the ability to work independently in a dynamic environment.

Key Responsibilities
- Design, develop, and maintain interactive Power BI dashboards and reports.
- Connect Power BI directly with various source systems, databases, APIs, ERP applications, and other enterprise platforms.
- Analyze source system structures to independently identify and extract data required for reporting.
- Develop and optimize SQL queries for efficient data extraction and reporting.
- Perform data transformation, cleansing, and preparation using Power Query / M.
- Build scalable and efficient data models applying dimensional modeling and star-schema concepts.
- Create business calculations and KPIs using DAX.
- Gather and translate business requirements into actionable analytical solutions.
- Configure Row-Level Security (RLS) and manage data access controls.
- Publish and manage reports, semantic models, datasets, and workspaces within Power BI Service.
- Configure and troubleshoot data gateways and scheduled data refreshes.
- Identify and resolve issues related to data extraction, integration, refresh, performance, and reporting.
- Optimize Power BI reports and data models for improved performance and scalability.
- Collaborate closely with customers, functional consultants, data engineers, and other technical teams.
- Prepare technical documentation and provide knowledge transfer as needed.

Required Qualifications
- 2 to 4 years of hands-on experience in Power BI development.
- Strong proficiency with Power BI Desktop and Power BI Service.
- Proven experience connecting directly to source systems and extracting data independently.
- Advanced SQL skills with the ability to write and optimize queries.
- Experience integrating data from databases, APIs, ERP/business applications, and other enterprise systems.
- Expertise in DAX for business calculations and KPIs.
- Solid knowledge of Power Query / M for data transformation tasks.
- Good understanding of data modeling principles, including dimensional modeling and star schema design.
- Experience implementing Row-Level Security (RLS).
- Familiarity with Power BI gateways, scheduled refreshes, workspace management, and deployment processes.
- Strong troubleshooting skills related to data and integration issues.
- Excellent analytical and problem-solving abilities.
- Effective communication skills with the ability to engage both business and technical stakeholders.

Preferred Qualifications
- Experience with Microsoft Fabric.
- Exposure to Azure Data Factory, Azure SQL, Synapse, or other Azure data services.
- Knowledge of data warehousing and ETL/ELT concepts.
- Experience extracting and reporting data from SAP or other ERP systems.
- Background in consulting or customer-facing analytics projects.

This is a full-time, onsite position based in Lahore. Candidates should be comfortable working from the DataGraders office.