Senior BI and Data Analyst (Power BI)

TL;DR

Senior BI and Data Analyst (Power BI): Responsible for the end-to-end delivery of high-impact analytics, from data cleaning and ETL automation to designing intuitive Power BI dashboards, with an accent on turning fragmented, unstructured data into a standardized "single source of truth." Focus on designing, building, and maintaining high-performance Power BI dashboards and developing automated data pipelines to eliminate manual reporting.

Location: Preference for hybrid in Pittsburgh (US) or fully remote from Eastern or Central US time zones.

Company

hirify.global is a global production ecosystem empowering content creators and rights holders to tell their stories through technology solutions for live production, live events, and virtual production.

What you will do

• Design, build, and maintain high-performance Power BI dashboards for global stakeholders.
• Perform advanced data cleansing, transformation, and ETL automation using Power Query.
• Translate business objectives into clearly defined, reliable KPIs and metrics.
• Develop and optimize automated data pipelines to improve data accuracy and efficiency.
• Conduct thorough data validation, QA, and UAT for all BI outputs.
• Partner with business stakeholders to gather requirements and deliver data storytelling.
• Maintain technical documentation, including data dictionaries and process documentation.

Requirements

• 5+ years of experience in Business Intelligence, data analysis, or analytics, with a strong portfolio of Power BI projects.
• Advanced proficiency in Power BI, Power Query, and DAX, including complex measures and data models.
• Expert-level Excel skills (advanced formulas, Power Pivot, and data modeling).
• Working knowledge of SQL for querying and extracting data from relational databases.
• Strong analytical mindset with exceptional attention to detail.
• Ability to communicate technical concepts clearly to non-technical audiences.