Job Summary:
We are seeking a highly skilled Power BI Developer / Data Analyst to design, build, and maintain scalable business intelligence solutions. The ideal candidate will possess strong analytical acumen and hands-on expertise with the Microsoft BI stack to deliver actionable insights that drive data-informed decision-making across departments.
Key Responsibilities
- Data Modelling & Architecture: Design robust semantic data models, define relationships, hierarchies, and KPIs that align with business rules and analytics goals
- Data Transformation: Utilize Power Query (M) and SQL to cleanse, transform, and aggregate data from diverse sources including enterprise systems, data warehouses, and APIs
- Visualization & Storytelling: Build insightful and interactive dashboards, reports, and visualizations in Power BI that translate complex data into clear, business-relevant narratives
- Advanced Analytics: Develop and optimize complex DAX measures and time-intelligent calculations to support trend analysis, forecasting, and comparative insights (e.g., YoY, MTD, YTD)
- Collaboration: Partner with cross-functional stakeholders (business, IT, operations, and management) to gather requirements, understand pain points, and deliver tailored BI solutions
- Performance Optimization: Monitor, troubleshoot, and enhance report performance and refresh schedules for high-volume datasets using Direct Query or Import modes
- Governance & Documentation: Ensure compliance with data governance policies and maintain thorough documentation for data lineage, metrics definitions, and BI processes.
Required Skills and Qualifications:
- Bachelor's or Master's degree in Computer Science, Information Systems, Data Analytics, or a related field.
- 5+ years of hands-on experience in Power BI development, including data modelling, Power Query, and advanced DAX.
- Solid understanding of data warehousing concepts, ETL pipelines, and relational database management systems (e.g., SQL Server, Oracle).
- Proficiency in SQL for querying and transforming data across large datasets.
- Familiarity with Python for data processing or integration is a plus.
- Strong analytical and problem-solving skills with a keen attention to detail.
- Excellent communication skills to convey technical concepts and business insights effectivey.
- Experience working in Agile environments and with tools like Jira, or Confluence is advantageous.
Tools and Technologies:
- Power BI Desktop and Power BI Service (publishing, scheduling, and workspace management)
- Microsoft SQL Server (SSMS, SSIS, T-SQL)
- Power Query (M) and DAXExcel (Power Pivot, Power Query)
