Business Intelligence Analyst / Data Engineer

Role overview

Responsibilities

• Design end-to-end BI solutions, including semantic and metric layers, dimensional data models, reports, dashboards, scorecards, and visual analytics products.
• Develop, maintain, and optimize Power BI semantic models, reports, dashboards, and analytical solutions using DAX, Power Query, and enterprise reporting standards.
• Apply advanced analytical and statistical techniques to identify trends, performance drivers, customer behaviors, and opportunities for improvement.
• Translate descriptive reporting into diagnostic insight and introduce predictive approaches where appropriate to the business question and available data.
• Partner with stakeholders to frame analytical questions, evaluate findings, and translate analyses into recommendations.
• Establish and document semantic modeling standards, reusable design patterns, visualization standards, and reporting best practices.
• Support report certification by validating solution quality, consistency, usability, maintainability, performance, documentation, and adherence to standards.
• Publish and support Power BI solutions through Power BI Service, including Workspaces, Apps, Deployment Pipelines, and semantic model refresh processes.
• Optimize report and semantic model performance, refresh reliability, storage-mode selection, and user experience across BI platforms.
• Assess design impacts involving Import, DirectQuery, composite models, Row-Level Security, refresh strategies, and Power BI capacity.
• Evaluate visualization technologies and select appropriate tools based on business need, scalability, maintainability, and user experience.
• Use Snowflake and other approved enterprise data sources to deliver reliable, scalable reporting and analytics solutions; coordinate with data engineering and technology partners.

Level expectations

• Analyst III designs end-to-end BI solutions, works independently with minimal guidance, leads solution components, frames analytical questions with stakeholders, and provides technical guidance to peers.
• Analyst IV leads complex reusable BI solutions and cross-functional initiatives; establishes standards, reviews technical designs, influences architecture and tooling decisions, and mentors analysts and developers.