Business Intelligence Reporting Analyst (Power BI)

Summary

Mutual of Omaha Mortgage is a company focused on providing business intelligence solutions to its leaders. They are seeking a Business Intelligence Reporting Analyst to develop and enhance their Power BI reporting environment, creating impactful dashboards and reports to drive 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
• Automate/streamline manual processes
• Monitor reports for data discrepancies and issues through use of Power BI and SQL
• Address, diagnose, and resolve reporting issues identified by business partners
• Propose changes and enhancements to established semantic models to support new reporting, or improve existing reporting
• Implement minor changes to semantic models as needed
• 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

Skills

• 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 highly preferred
• Experience with Financial reporting a plus

Qualifications

Must Haves

• 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

Nice to Haves

• Mortgage experience highly preferred
• Experience with Financial reporting a plus

Benefits

• Vacation — Vacation hours accrue on a per pay period basis. Balance maximums are based on years of service.
• Paid Sick Time — 40 hours of paid sick time after 90 days of employment. State sick time requirements will be added as needed.
• 9 Paid Holidays + 1 Cultural Celebration Day (Floating Holiday)
• Multiple PPO Medical Plans, as well as HDHP eligible plan.
• Dental Coverage
• Vision Coverage
• Company Paid Life Insurance
• 401K with a generous employer match
• Additional Benefits including – Optional Life, FSA, Pet Insurance etc.
• Free Legal Services
• Employee Loan Program