Sr. Business Intelligence Reporting Analyst (Power BI)

Mutual of Omaha Mortgage is a company that focuses on providing reliable and actionable data through their Business Intelligence platform. They are seeking a Sr. Business Intelligence Reporting Analyst to develop Power BI reporting solutions that deliver meaningful insights to business leaders and support organizational goals.

Responsibilities:

• 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
• 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
• Update semantic models to support new reporting needs
• Monitor model efficiency and implement changes as needed to optimize performance
• Identify pertinent trends to share with leaders
• Proactively dive headfirst into data to offer deeper insights into high/low performing KPIs
• Document report development processes for business contingency purposes
• 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

Requirements:

• 4+ years' experience in a data or business intelligence focused role
• 4+ years creating BI dashboards and reports with a focus on data visualization and storytelling with a high proficiency using Power BI
• 4+ years writing SQL queries for data mining
• Ability to independently understand data through business context, exploration, and logical connections
• Advanced level proficiency with Power BI
• Building efficient semantic models
• Understand/create dynamic measures using DAX
• Power Query for data sourcing/transformation
• Row-level security implementation
• Calculation groups
• Data visualization
• Performance Analyzer
• Intermediate level proficiency with SQL (T-SQL)
• Standard select queries
• Joins across multivariate datasets including multiple keys
• Data normalization
• Window functions and methods
• Strong written and verbal communication skills
• Mortgage experience preferred
• Familiarity with Databricks Data Warehouse a plus