Business Intelligence Reporting Analyst / Remote / PowerBI / SQL

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.