Business Intelligence Reporting Analyst

Summary

Join our Mortgage Business Intelligence & Analytics team as a Business Intelligence Reporting Analyst! This remote US-based role focuses on developing our Power BI reporting environment, creating impactful dashboards and reports that deliver meaningful data to business leaders. You will use data visualization best practices to tell a compelling story with data and derive meaningful insights. The ideal candidate has a strong Power BI background, is detail-oriented, and proactively ensures data quality. This role offers opportunities to become a subject matter expert and stay current with the latest Power BI features. The compensation range is $80,000-$105,000.

Requirements

• 4+ 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
• 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
• DAX Studio
• 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

Responsibilities

• Meet with business leaders/users to understand their needs and requirements
• 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
• 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 head first into data to offer deeper insights into high/low performing KPIs
• 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

Preferred Qualifications

Mortgage experience

Benefits

• Medical, Dental, and Vision insurance
• Company paid life insurance
• 401K with a generous employer match
• Free Legal Services
• An Employee Loan Program