Senior Power BI Developer (GeoLocation Specialist)

Company: Madar Soft –

WebSite: Fleming, Alexandria, Egypt

Job Description:We are seeking a highly skilled and experienced Senior Power BI Developer possessing extensive expertise in GeoLocation data analysis. This pivotal role entails the design, development, and optimization of interactive dashboards and impactful reports. The ideal candidate will demonstrate a substantial record in spatial data visualization, sophisticated mapping techniques, and geographic data modeling, contributing significantly to data-driven decision-making across the organization by transforming raw location data into actionable insights.

**Key Responsibilities:**

**Dashboard & Report Development:**

* Design, develop, and deploy advanced Power BI dashboards, paginated reports, and compelling data visualizations, with a primary focus on GeoLocation analytics (e.g., heatmaps, proximity analysis, region-based trends, route optimization solutions).
* Collaborate closely with stakeholders to gather and translate complex business requirements into effective wireframes, mockups, and intuitive data visualizations.
* Promote adherence to best practices in report design and user experience.

**Data Modeling & Transformation:**

* Create, maintain, and optimize robust semantic models (datasets) within Power BI.
* Develop complex and efficient calculations and measures using Data Analysis Expressions (DAX).
* Construct and manage robust data transformation pipelines utilizing Power Query (M) to cleanse, reshape, and prepare data for analysis.
* Ensure optimized data structures to minimize report refresh times and enhance query performance.
* Structure event logs, location records, and associated metadata into usable, scalable schemas.
* Apply sophisticated transformation logic to standardize, normalize, and enrich diverse datasets.

**Data Governance & Quality Assurance:**

* Establish and implement comprehensive data validation rules and processes (e.g., null checks, anomaly detection, timestamp gap analysis).
* Ensure the accuracy, consistency, and reliability of reported data through rigorous testing, validation, and reconciliation procedures.
* Implement and manage row-level security (RLS) and other data governance practices within the Power BI environment.

**Integration & Collaboration:**

* Connect Power BI to a wide variety of data sources, including SQL databases (on-premises and cloud-based such as Azure SQL), data warehouses (e.g., Azure Synapse, Snowflake), APIs, cloud services (e.g., SharePoint Online), Excel, CSV files, and other enterprise systems.
* Collaborate effectively with product managers, data engineers, software developers, and business stakeholders to enhance data accessibility, analytical capabilities, and decision-making processes.
* Mentor junior developers or share expertise within the team, as required.

Skills: