Overview:
We are seeking a highly skilled and motivated Power BI Data Analyst to join our dynamic team. The ideal candidate will be responsible for developing and maintaining business intelligence solutions using Power BI, with a focus on data visualization, analysis, and reporting. In addition to expertise in Power BI and Excel, the candidate should possess knowledge in SQL, Power Automate flows, and ServiceNow reporting.

Key Responsibilities:
• Design, develop, and implement Power BI dashboards and reports to meet business requirements.
• Work closely with stakeholders to gather and understand reporting requirements.
• Utilize DAX (Data Analysis Expressions) to create complex calculations and measures.
• Develop and maintain Power Automate flows to automate data workflows and processes.
• Integrate Power BI with Power Automate and SharePoint for seamless data updates and synchronization.
• Leverage knowledge of ServiceNow to extract, transform, and load data into Power BI.
• Create reports and dashboards that provide insights into ServiceNow metrics and KPIs.
• Apply basic knowledge of IT service desk operations and Asset Management Database (AMDB) concepts.
• Collaborate with IT teams to understand data sources related to service desk and AMDB.
• Utilize Rest API for data extraction and integration into Power BI.
• Write and optimize SQL queries to retrieve and manipulate data from various databases.
• Implement and maintain data security measures within Power BI, ensuring compliance with organizational policies.
• Develop role-based access control and manage user access to reports and dashboards.

Qualifications
• 5 Years in Data analysis, business intelligence or related field.
• Power BI Experience required:
o Data Modeling and Transformation:
o Apply advanced data visualization techniques
o Power BI Administration Experience
o Data integration with External sources
o Identify and resolve performance bottlenecks in Power BI reports and dashboards.
o Implement version control for Power BI artifacts to track changes and facilitate collaboration
o Advanced understanding of data warehousing concepts, including star and snowflake schemas.
o Proficiency in optimizing data models for large datasets and complex relationships.
o Ability to troubleshoot and resolve issues related to data refresh, connectivity, and performance.
o Conduct training sessions for end-users on Power BI functionality and best practices.
o In-depth knowledge of Power BI features such as row-level security, custom connectors, and Power Query M language.
o Experience with Power BI Premium and Power BI Service administration.
o Capability to design and implement complex data transformations using Power Query Editor.
• Strong proficiency in SQL queries, SQL Agent, and Store procedures.
• Experience with Power Automate, SharePoint, ServiceNow reporting, and AMDB concepts.
• Knowledge of Rest API, and authentication methods.
• Understanding of data security principles and best practices.
• Excellent communication and collaboration skills.

Preferred Skills:
• Certification in Power BI, Azure data, or related data technologies.
• Familiarity with data warehousing concepts.
• Experience with cloud-based BI solutions.
• Knowledge of business analysis and requirements gathering.