Z5
Job Description
Job description
- You will be responsible for designing, developing, and optimizing Power BI reports, dashboards, and data models to meet business needs.
- You will build and maintain data models , datasets, and Power Automate flows, ensuring data consistency and accuracy across reports.
- Writing and optimizing DAX queries and calculations for high performance will be a key part of the role.
- You will connect to various data sources, including SQL Server, Azure, APIs, Excel, and other cloud-based services, ensuring seamless data flow.
- Collaborating with business users to understand reporting needs and deliver intuitive, user-friendly visualizations is essential.
- You will partner with data engineers and analysts to acquire, clean, and transform data for reporting purposes.
- Ensuring data governance, security protocols, and brand consistency across all reporting solutions will be a critical responsibility.
- Additionally, you will troubleshoot and resolve Power BI performance issues, optimizing report load times and improving overall efficiency.
- Your expertise in SQL will be utilized to fetch and validate data using queries, stored procedures, and database objects.
- You will also provide ongoing training, documentation, and support to end-users, ensuring they can fully utilize Power BI reports and dashboards.
- Finally, you will stay up to date with the latest Power BI features, tools, and best practices, introducing innovative ideas to enhance reporting capabilities.
What Youll Bring:
- The ideal candidate will have at least 3+ years of experience in Power BI development and data visualization.
- They must be highly proficient in DAX (Data Analysis Expressions) and M Query for complex calculations, as well as possess a knowledge of SQL Server, T-SQL , and relational databases.
- Familiarity with ETL tools and processes, such as Azure Data Factory and Power Query , is required.
- Experience with Power BI Service , Power BI Apps , and Row-Level Security (RLS) is essential, along with a solid understanding of data modeling concepts like Star Schema and Snowflake Schema .
- The candidate should have experience integrating Power BI with cloud platforms, such as Azure , SharePoint , and APIs.
- A familiarity with Power Automate and Power Apps and their integration with Power BI is a plus.
- The candidate should also possess strong analytical and problem-solving skills, as well as excellent communication and stakeholder management abilities.
- Experience with Python or R for advanced data analysis would be beneficial.
- Knowledge of AI/ML integration with Power BI would also be an asset.
- Microsoft certification (e.g., PL-300: Power BI Data Analyst ) is a plus.
Role: Analytics Consultant
Industry Type: Management Consulting
Department: Data Science & Analytics
Employment Type: Full Time, Permanent
Role Category: Business Intelligence & Analytics
Education
UG: Any Graduate
PG: Any Postgraduate
Key Skills
Data analysisData modelingAnalyticalSchemaManagement consultingdata governanceStored proceduresmicrosoftStakeholder managementPytho
