Business Intelligence Analyst

Qualifications

• 5 years of hands on experience in business intelligence analytics or reporting roles with a strong focus on Power BI development
• Advanced proficiency in Power BI including:
  • Building and maintaining Power BI semantic models
  • Developing production quality reports and dashboards
  • Writing and optimizing DAX measures for analytical use cases
• Strong data analysis skills with the ability to:
  • Explore validate and interpret data
  • Identify trends anomalies and root causes
  • Translate business questions into analytical logic and metrics
• Solid SQL experience including writing modifying and troubleshooting queries used for reporting and modeling
• Experience designing clean scalable data models including star schemas relationships and reusable metrics
• Familiarity with governed self service analytics and Citizen IT models in Power BI (datasets certified/promoted content shared measures)
• Strong understanding of business operations KPIs and performance metrics with the ability to challenge assumptions using data
• Experience working cross functionally with IT data engineering and business teams
• Excellent communication skills with the ability to explain analytical concepts and data findings to non technical stakeholders
• Ability to work independently take ownership of BI assets and drive solutions from concept through delivery
• Comfort leading in person working sessions and collaborating directly with business leaders

Key Responsibilities

• Design build and maintain Power BI semantic models that support consistent reliable reporting and analysis across the organization
• Perform hands on data analysis to understand business drivers validate data quality and uncover actionable insights
• Develop Power BI reports and dashboards that clearly communicate trends performance and key business outcomes
• Translate business questions and requirements into:
  • Analytical logic
  • DAX measures
  • SQL queries
  • Intuitive Power BI visualizations
• Lead the consolidation and rationalization of existing reports into standardized scalable Power BI solutions
• Ensure semantic consistency across models and reports including metric definitions calculation logic filters and naming conventions
• Partner with IT and data engineering teams to:
  • Understand source data
  • Address data gaps or quality issues
  • Align on modeling and refresh strategies
• Support and guide business users in a self service analytics environment enabling them to confidently consume and extend trusted datasets
• Conduct in person working sessions to gather requirements review data findings and iterate on reports with stakeholders
• Continuously improve Power BI assets by identifying opportunities for optimization simplification and automation