Business Intelligence Reporting Analyst / Remote / PowerBI / SQL

Motion Recruitment Partners LLC; Los Angeles (CA); Remote; USD 80,000 - 110,000; Full time

Job summary

A national leader in the mortgage and financial services industry seeks a Business Intelligence Reporting Analyst for a fully remote role. Responsibilities include developing Power BI dashboards and analyzing data to enhance sales performance metrics. Ideal candidates will have a strong background in BI, SQL, and data visualization principles, aiming to leverage their skills in a dynamic, remote-first environment.

Benefits

Comprehensive benefits package including medical, dental, vision

Opportunities for professional development and mentorship

Qualifications

• 3–5 years in business intelligence, data analytics, or reporting roles.
• 3+ years developing dashboards and reports in Power BI.
• 2+ years of hands-on SQL experience.

Responsibilities

• Develop and maintain Power BI reporting environment.
• Analyze sales pipeline and design efficient data models.
• Collaborate cross-functionally with sales and operations teams.

Skills

Data Analysis

Business Intelligence

Power BI

SQL

Data Visualization

CRM Data Understanding

Communication Skills

Job description

Job Description
This is a full-time, US-based remote opportunity with a national leader in the mortgage and financial services industry.
We are looking for a Business Intelligence Reporting Analyst to develop and maintain our Power BI reporting environment, with a specific focus on Sales performance metrics. In this role, you'll go beyond generating static reports; you’ll help shape the narrative around our data and build dashboards that drive real business impact. From analyzing the sales pipeline to designing efficient data models, you’ll serve as a key data partner to sales leadership.
If you're highly proficient in Power BI, love digging into CRM data, and are passionate about crafting visualizations that tell compelling stories, this role is for you.

Required Skills & Experience

• 3–5 years in business intelligence, data analytics, or reporting roles
• 3+ years developing dashboards and reports in Power BI
• 2+ years of hands-on SQL experience for data mining and transformation
• Strong understanding of CRM data, especially sales pipeline dynamics
• Demonstrated ability to independently explore, interpret, and leverage new datasets
• Attention to design and visualization best practices (e.g., Storytelling with Data, Gestalt principles)
• Excellent written and verbal communication skills

Desired Skills & Experience

• Deep Power BI expertise:
  • Semantic model development
  • Advanced DAX and calculation groups
  • Power Query transformations
  • Row-level security implementation
  • Familiarity with DAX Studio and Performance Analyzer
• Solid SQL skills (T-SQL preferred):
  • Multi-key joins, window functions, and data normalization
• Previous experience in the mortgage, lending, or financial services industry is a plus

What You Will Be Doing
Tech Breakdown

• 50% Report Development (Power BI dashboards, business engagement)
• 25% Data Analysis (trends, pipeline insights, proactive exploration)
• 15% Semantic Model Design (CRM data modeling, performance optimization)
• 5% Documentation (data lineage, report indexing, changelogs)
• 5% Team Support & Ad Hoc Collaboration

Daily Responsibilities

• 70% Hands-On Development & Analysis
• 20% Cross-Functional Collaboration (Sales, BI, Ops)
• 10% Strategic Planning & Reporting Documentation

The Offer

• Fully remote
• Join a dynamic, remote-first team supporting a national business across time zones
• Comprehensive benefits package including medical, dental, vision
• Opportunities for professional development and mentorship within the BI & Analytics space

Applicants must be currently authorized to work in the US on a full-time basis. We are unable to provide visa sponsorship for this position.