Sr. Business Intelligence Reporting Analyst (Power BI)

Report Development

Build effective and efficient reports and dashboards using best practices in data presentation and design language
Migrate existing reporting inventory to a centralized semantic model
Leverage Valtrune to complete full data and report validation
Automate/streamline manual processes

Data Transformation/Preparation

Use advanced SQL techniques and multi-stage transformation methodologies to normalize, cleanse, and standardize inconsistent datasets
Infer and establish relationships between disparate data sources and systems of record to support unified reporting and analytics
Transform raw source data into reporting-layer-ready objects, including the creation of synthetic keys derived from non-standardized attributes

Semantic Model Maintenance

Update semantic models to support new reporting needs
Monitor model efficiency and implement changes as needed to optimize performance

Analysis

Identify pertinent trends to share with leaders
Proactively dive headfirst into data to offer deeper insights into high/low performing KPIs

Documentation

Maintain semantic model documentation, including data sources and table relationships
Maintain an index of all active reports, including data lineage, purpose, and audience
Maintain reporting changelog