Junior Power BI Analyst

Job Description

We are looking for a Junior Power BI Analyst for a contract to hire opportunity in Phoenix. This will be a fully onsite position in Phoenix, Arizona. You will be at the forefront of helping our organization leverage Power BI reports and dashboards, providing key insights and solutions for data visualization and reporting challenges

Key Accountabilities:

Data Model Design: Transform raw data into meaningful insights by designing robust data models tailored to business requirements.

Dashboard Creation: Develop visual interactive reports and dashboards using Power BI.

Project Management: Drive project execution, manage timelines, and ensure the timely completion of tasks and projects.

Subject Matter Expertise: Offer expert insights and solutions for complex data visualization and reporting challenges.

KPI Identification: Identify key performance indicators, set clear objectives, and monitor them consistently.

Data Analysis: Analyze data and present findings through comprehensive reports that aid decision-making.

Business Collaboration: Convert business requirements into technical specifications and plan timelines for task completion.

Script Development: Design, develop, and deploy Power BI scripts and conduct detailed analysis.

DAX Functions: Perform DAX queries and functions in Power BI.

Data Documentation: Create charts and document data algorithms, parameters, models, and relationships.

SQL Querying: Conduct SQL querying to achieve optimal results and develop data warehouses.

Data Visualization: Use filters and graphs to enhance data understanding.

System Enhancement: Enhance existing BI systems and define new systems by analyzing current ETL processes.

Key Knowledge, Skills, and Behaviors:

Must Have:

· Bachelor’s or higher in Computer Science, Business Engineering, or a related field.

· Minimum of 3 years as a Power BI engineer OR Some experience or internships in Power BI or related fields.

· Proficient in BI tools such as Power BI, SAP, Tableau, with experience in creating data-rich dashboards, implementing Row-level Security (RLS) in Power BI, and writing DAX expressions.

· Knowledge in database management, data modeling, business intelligence, SQL querying, and data warehousing.

· Familiarity with Microsoft BI stacks like Power Pivot, SSIS, SSRS, and SSAS.

· Ability to effectively visualize data through charts, reports, and dashboards.

Nice to Have:

· Software Development: Understanding of software development architecture and technical aspects.

· ETL/ELT Processes: Experience with ETL/ELT processes using Azure Data Factory, Azure Synapse, and/or Data Bricks.

· SAP Experience: SAP Core and SAP BW experience.

· Adaptability: Eager to learn and adapt to new technologies.

· Team Collaboration: Service-minded team player with excellent communication skills.