Power BI Report Analyst

$83,200 - $104,000/Yr

Consultnet - Salt Lake City, UT

Full-time - Mid Level

Salt Lake City, UT

Professional, Scientific, and Technical Services

About the position

The Power BI Report Analyst will play a crucial role in a large-scale data warehouse project within a financial services organization. This position involves converting manually created reports into Power BI and ensuring data accuracy and integrity across various reporting platforms. The analyst will collaborate with stakeholders to gather requirements and deliver actionable insights through interactive reports and dashboards.

Responsibilities

• Develop and maintain interactive reports and dashboards in Power BI to visualize key performance indicators (KPIs) and business metrics
• Write and optimize SQL queries to extract, transform, and load (ETL) data from various sources
• Utilize Python for data analysis, automation of reporting tasks, and enhancing existing reporting processes
• Collaborate with stakeholders to understand reporting requirements and translate them into technical specifications
• Ensure data accuracy, consistency, and integrity across reports and dashboards
• Provide support and training to end-users on report usage and best practices
• Document processes, data sources, and reporting methodologies for future reference
• Stay updated on industry trends and best practices in data visualization and reporting

Requirements

• 3+ years as a Power BI Report Developer or BI Data Analyst within the financial services industry
• Deep understanding of the financial services industry and terminology
• Expertise transforming manually built reports to Power BI
• Strong expertise in Power BI, including DAX functions and report design
• Proficiency in SQL for data extraction and manipulation
• Experience with Python for data analysis and automation tasks
• Familiarity with financial data and metrics
• Knowledge of data warehousing concepts and ETL processes

Nice-to-haves

• Experience with data visualization best practices
• Experience with Data Warehousing, specifically Snowflake
• Excellent analytical and problem-solving skills
• Strong communication and interpersonal skills to collaborate effectively with stakeholders

Benefits

• Competitive pay rate
• Opportunity to work in a hybrid environment
• Experience in a reputable financial services organization