Business Intelligence Reporting Analyst (Power BI)

Mutual of Omaha Mortgage is seeking a Business Intelligence Reporting Analyst to focus on the development of their Power BI reporting environment. The role involves creating impactful dashboards and reports to provide meaningful data to business leaders, ensuring data quality, and maintaining reporting processes.

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
• Automate/streamline manual processes
• Ongoing monitoring of exceptions, including engagement with business partners to resolve data discrepancies
• Collection and curation of data points from business partners
• Execution of regulatory data preparation processes
• Documented validation of datasets against system of record
• Update semantic models to support new reporting needs
• Monitor model efficiency and implement changes as needed to optimize performance
• Make minor changes and updates to existing reports as needed
• 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
• Provide backfill support for ongoing team work as needed

Requirements:

• 3+ years' experience in a data or business intelligence focused role
• 3+ years creating BI dashboards and reports with a focus on data visualization and storytelling with a high proficiency using Power BI
• 3+ years writing SQL queries for data mining
• 3+ years' experience collecting and documenting business requirements
• Intermediate proficiency with Power BI
• Understand how to navigate semantic models
• Understand/create dynamic measures using DAX
• Power Query for data sourcing/transformation
• Row-level security implementation
• Calculation groups
• Data visualization
• 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