Power BI Analyst

Ipipeline - Exton, PA

Full-time - Mid Level

Exton, PA

501-1,000 employees

Professional, Scientific, and Technical Services

About the position

The Power BI Analyst role at iPipeline involves designing, developing, and maintaining business intelligence solutions using Microsoft's Power BI platform. The position is crucial for helping the organization make data-driven decisions by transforming raw data into meaningful insights through effective data visualizations. The analyst will collaborate with various stakeholders to understand data needs and optimize reporting capabilities.

Responsibilities

• Develop and maintain Power BI reports and dashboards to visualize key business metrics and insights.
• Work closely with business stakeholders to gather requirements, understand data needs, and design effective data visualizations.
• Connect Power BI to various data sources such as SQL databases, Excel, and APIs.
• Transform raw data into meaningful insights by cleaning, transforming, and modelling data using Power Query and DAX.
• Collaborate with data engineers and IT teams to design and implement data models and data integration solutions to support reporting requirements.
• Optimize and streamline existing Power BI reports and dashboards for improved performance and usability.
• Provide support to business users on how to use Power BI to access, analyse, and visualize data.
• Stay current with Power BI and/or other BI tools features, updates, and best practices, and recommend enhancements to improve reporting capabilities.
• Participate in cross-functional projects and initiatives to support broader business intelligence and analytics objectives.
• Troubleshoot issues and provide technical support for Power BI solutions as needed.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field.
• 6+ years of experience in data analysis, business intelligence, or related roles.
• Proficiency in Power BI Desktop, Power Query, DAX, and Power BI Service.
• Strong understanding of data visualization principles and best practices.
• Experience with data modelling, data warehousing, and SQL databases.
• Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
• Ability to work independently and manage multiple priorities in a fast-paced environment.

Nice-to-haves

• Experience in JIRA, Salesforce, Project Management software a plus.
• Power BI certification is a plus.