Job Opportunities API

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)&n