Power BI Specialist- CPT at Optimal Growth Technologies

Role Overview

• We are seeking a highly skilled Power BI Specialist to design, develop, and maintain interactive dashboards and business intelligence solutions that support data-driven decision-making.
• The successful candidate will work closely with business stakeholders, analysts, and IT teams to transform complex data into meaningful insights using Microsoft Power BI.

Key Responsibilities

Data Visualization & Reporting

• Design, develop, and maintain interactive Power BI dashboards and reports.
• Translate business requirements into effective data visualizations and reporting solutions.
• Optimize dashboards for performance, usability, and scalability.

Data Modelling & Integration

• Develop and maintain robust data models within Power BI.
• Integrate data from multiple sources including databases, data warehouses, APIs, and cloud platforms.
• Create and maintain DAX calculations, measures, and KPIs.

Business Analysis & Collaboration

• Work with stakeholders to understand business requirements and reporting needs.
• Provide insights and recommendations based on data analysis.
• Support business users with training and adoption of Power BI solutions.

Data Quality & Governance

• Ensure data accuracy, integrity, and consistency across reports.
• Implement best practices for data governance and security.
• Maintain documentation for reports, data models, and processes.

Performance & Optimization

• Monitor and improve Power BI report performance.
• Implement efficient queries and data refresh processes.
• Troubleshoot and resolve data and reporting issues.

Required Experience

• Proven experience working with Microsoft Power BI in a BI or data analytics role.
• Experience with data modelling and data visualization techniques.
• Strong knowledge of DAX, Power Query, and data transformation.
• Experience integrating data from SQL databases and other enterprise systems.
• Experience building enterprise-level dashboards and reporting solutions.

Technical Skills

• Microsoft Power BI Desktop & Power BI Service
• DAX (Data Analysis Expressions)
• Power Query / M Language
• SQL and relational databases
• Data modelling and data warehousing concepts
• Microsoft Excel and Office tools

Preferred Skills

• 10 years' experience with Azure Data Services (Azure SQL, Synapse, Data Factory)
• Knowledge of ETL processes and data pipelines
• Understanding of data governance and security best practices

Education

• Bachelor's Degree in Information Systems, Computer Science, Data Analytics, or related field preferred.

Key Competencies

• Strong analytical and problem-solving skills
• Attention to detail and data accuracy
• Excellent communication and stakeholder engagement
• Ability to translate complex data into clear business insights