Develop and maintain complex Power BI dashboards, stabilize and redesign reporting ecosystems, and work collaboratively with a 6-person analytics team. Strong DAX and semantic modeling skills required. Opportunity for long-term extension and conversion.
Key Highlights
Technical Skills Required
Benefits & Perks
Job Description
Power BI Developer
Location: 100% Remote (U.S.)
Duration: 6-month contract (potential to convert)
Industry: Banking & Financial Services
Team Size: 6-person analytics/ETL generalist team
Focus: Digital acquisition funnel, metric ownership, reporting stabilization & redesign
Overview
Our client’s Channels Analytics team has recently inherited ownership of all Digital Sales reporting, including the metrics, insights, and dashboards that measure customer behavior across the entire digital acquisition funnel.
This team is now responsible for understanding how customers move from application start → submission → review → funding → digital enrollment and beyond. They are seeking a Power BI Developer who can step into a high-visibility environment, stabilize an inherited reporting ecosystem, and eventually help redesign it for long-term scalability.
This role is ideal for a Power BI “Swiss Army knife” — someone who can take complex requirements, understand the underlying data structures, work through technical debt, and design clean, accurate, user-friendly reporting in Power BI.
What You’ll Do
Own 150+ Metrics Across 4 Dashboards
- Maintain, troubleshoot, and re-engineer DAX logic (all metrics are built in DAX).
- Take ownership of metric definitions, logic consistency, and reporting accuracy.
- Inherit each dashboard one at a time, beginning with the most critical.
Power BI Development & Design
- Build, refine, and optimize dashboards used by Digital Sales, Branch, Call Center, and P&BB teams.
- Apply semantic modeling best practices (star schema, relationships, tabular modeling).
- Improve and standardize templates and reporting schema created by the team over the past year.
Manual Adobe → Power BI Integration (Short Term)
- Support an existing manual workflow where Adobe Analytics data is exported and inserted into Power BI.
- Maintain this process initially; help evaluate and propose opportunities for automation.
Work With SAS-Based Pipelines
- Upstream teams use SAS to normalize and prepare data tables feeding Power BI.
- You will not write SAS, but you should understand how the SAS outputs map into your models.
Troubleshoot Power BI at a Deep Level
- Identify breakpoints in DAX, modeling, and refresh logic.
- Validate data across multiple systems using SQL.
- Investigate discrepancies and communicate impacts clearly.
Partner Across a Collaborative BI Team
- Work closely with a 6-person generalist analytics team that spans ETL, SQL, analytics, and BI design.
- Participate in BI work outside of Digital Sales as needed.
- Support knowledge transfer from the team currently managing these dashboards.
Required Qualifications
Technical Must-Haves
- Expert-level Power BI development experience
- Advanced DAX (complex, nested measures; large metric libraries)
- Strong semantic modeling (star schema, tables, relationships)
- Intermediate to advanced SQL for validation and troubleshooting
- Ability to diagnose and fix complex Power BI issues (performance, logic, refreshes)
- Experience working through technical debt in BI/reporting environments
- Strong analytical thinking and problem-solving skills
Nice-to-Have
- Adobe Analytics experience
- SAS familiarity
- Python exposure (team occasionally uses it for ETL checks)
- Digital analytics or financial services experience
Soft Skills (Critical)
- Emotionally mature — stays calm when dashboards break (they will)
- Comfortable working in an evolving environment with manual processes
- Proactive, curious, and solution-oriented
- Strong communicator who collaborates well with cross-functional teams
- Positive, grounded mindset — the team values people who “work to live,” not the reverse
- Enjoys metrics, customer behavior insights, and digging into complex data
Why This Role Is Exciting
- High visibility → your dashboards are seen by senior leadership (Briana, Aaron, Digital Sales executives)
- Opportunity to stabilize and rebuild a core reporting function from the ground up
- Full remote flexibility
- Chance to join a collaborative, startup-like analytics function inside a major financial institution
- Strong extension and conversion potential as the team scales.