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 impactful Power BI reports and dashboards for our Sales team. You will create data visualizations, tell compelling data stories, and provide meaningful insights to business leaders. The ideal candidate possesses strong Power BI skills, including semantic model design and DAX, and experience with SQL and CRM systems. You will collaborate with business leaders to understand their needs and build efficient reporting solutions. This position requires 5+ years of experience in a data or business intelligence role and proficiency in data visualization and storytelling. We offer a fully remote work environment with the option to work from our offices in San Diego, CA, Irvine, CA, or Omaha, NE.

Requirements

• 5+ years’ experience in a data or business intelligence focused role
• 5+ 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
• Strong understanding of CRM systems and data
• 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

• Report Development (50%)
• 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
• Semantic Model Design (15%)
• Build semantic models for our CRM data to support reporting needs
• Monitor model efficiency and implement changes as needed to optimize performance
• Analysis (25%)
• Identify pertinent trends to share with sales leaders
• Proactively dive head first into data to offer deeper insights into high/low performing KPIs
• Documentation (5%)
• 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
• Team Support & Other Duties (5%)
• Provide backfill support for ongoing team work as needed

Preferred Qualifications

Mortgage experience

Benefits

This opportunity is fully remote with the option to work from our offices in San Diego, CA, Irvine, CA, or Omaha, NE for those who prefer an office environment