Provides direct support to an assigned area. Applies relevant principles to support projects and ongoing activities. Completes tasks which support a project or functional team.
Responsibilities
- Design and develop end-to-end Power BI dashboards and semantic models that translate complex operational data into actionable insights for leadership and operations teams; create PBIP projects with advanced features including calculated tables, relationships, DAX measures, and data validation logic.
- Conduct requirements gathering and translate business needs into functional and technical specifications, working directly with stakeholders to document scope, success criteria, and edge cases; document design decisions and architectural patterns for model maintainability.
- Develop KPIs and performance metrics that drive operational visibility and decision-making.
- Build and maintain semantic data models that integrate data from multiple sources (Redshift, ODBC connections, enterprise systems).
- Write and optimize complex SQL (Redshift-compatible) to extract, transform, and stage data for analytics.
- Create and document design specifications and requirement documents that serve as source-of-truth for dashboard actionable insights for leadership and operations teams.
- Conduct requirements gathering and translate business needs into functional and technical specifications, working directly with stakeholders to document scope, success criteria, and edge cases; document design decisions and architectural patterns for model maintainability.
- Perform requirement validation and UAT coordination — gather stakeholder feedback on prototypes, incorporate design iterations, and validate that delivered dashboards meet acceptance criteria.
- Support dashboard deployment and user enablement — publish to production environments, troubleshoot connectivity issues, and provide training and documentation to end users.
- Leverage AI and emerging technologies to identify and implement continuous improvement opportunities, enhance efficiency and decision-making, and support innovation in alignment with business priorities.