Power BI Analyst & Dashboard Developer

About the Role
The Power BI Analyst & Dashboard Developer integrates data from company’s Electronic Medical Record (EMR), CRM, survey platforms, and outcome tracking tools into clean, validated dashboards that leadership can actually act on.
This is an analyst role first, developer second. Technical Power BI skill gets you in the door — but your data instincts, validation discipline, and willingness to ask 'does this even make sense?' are what make you successful here.
What You'll Do
Data Validation & Analytical Thinking (Your Primary Focus)
Validate every dataset for plausibility, completeness, and consistency before building — flag outliers, gaps, and improbable distributions

Treat large 'Other,' 'Unknown,' or null buckets as findings to investigate, not defaults to leave alone

Reconcile metrics against operational reality; if a number doesn't match what stakeholders see, stop and investigate

Document data quality findings and ship every dashboard with a written caveat and limitations note

Constructively push back on requests built on flawed assumptions — ask questions before building

Dashboard Development & Reporting
Design and maintain Power BI dashboards for executive, director, and department audiences using DAX, Power Query (M), and solid data modeling

Connect Power BI to source systems via native connectors, REST APIs, ODBC, SQL, and file-based extracts

Build and monitor automated dashboard refreshes; troubleshoot failures fast

Track and report on clinical outcomes, admissions conversion, marketing performance, revenue, and alumni engagement

Translate leadership's business questions into dashboards that support decisions — not just visualizations

Process, Documentation & Collaboration
Document data sources, transformations, refresh schedules, and logic so the work is transferable

Develop ad hoc reports with clearly documented methodology and assumptions

Audit data quality across source systems on a recurring basis

Participate in scheduled calls during Arizona business hours; meet deadlines without daily oversight

Follow all HIPAA, 42 CFR Part 2, and Horizon information security protocols strictly

Your First 90-Day Deliverable: Marketing & Lead Analytics Platform
This is a concrete, non-negotiable deliverable — not a stretch goal.
By Day 90, you will have delivered:
• End-to-end lead funnel (inquiry → assessment → admission) with conversion rates and drop-off by stage
• Source and channel attribution for every lead with documented categorization rules
• Lead loss / fallout analysis with categorized reasons (no unexplained 'Other' >10%)
• Marketing spend tracking: cost per lead, cost per qualified lead, cost per admission by channel
• Cohort views by month, campaign, and channel
• A written data dictionary and refresh-schedule document
• Validated, reconciled metrics with documented limitations
• Two structured handoff sessions with the VP of Growth
Who You Are
You instinctively ask 'does this make sense?' before publishing anything

You recognize implausible data, flat trends, and suspiciously clean distributions — and you investigate

You have expert-level Power BI: DAX, Power Query (M), data modeling, RLS, Power BI Service

You write efficient SQL and can query against relational databases confidently

You've integrated Power BI with multiple disparate systems (APIs, ODBC, web connectors, file extracts)

You're comfortable with healthcare or behavioral-health data — EMR/EHR exports, CRM pipelines, survey instruments

You communicate clearly in written and spoken English with non-technical executives

You push back constructively when requirements are ambiguous or data is unreliable

You are self-managing, deadline-driven, and proactive when something is at risk

Minimum Qualifications
Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Health Informatics, or equivalent demonstrated experience

5+ years building production Power BI dashboards used by business leadership, with verifiable references

Microsoft certification preferred (PL-300 Power BI Data Analyst Associate or equivalent)

Documented experience integrating Power BI with at least 3 distinct source systems (e.g., CRM, EMR/EHR, survey platform, financial system)

Proven track record of catching and resolving data quality issues

Reliable high-speed internet (min. 50 Mbps down / 10 Mbps up), backup power, and a private secure home workspace

Ability to work 40 hours/week consistently aligned to Arizona (Mountain Time) business hours

Willingness to sign a BAA, Independent Contractor Agreement, and NDA before any system access

Completion of HIPAA and 42 CFR Part 2 training (with certificate) prior to system access; annual renewal required

Encrypted device, MFA, VPN, no local PHI storage, no personal cloud storage — full compliance with company’s information security policy

Requirements
This is a full time job
$7-$8/hr
100% Remote
Originally posted on Himalayas