Power BI Developer & Data Analyst (100% Onsite)

True Care•New York, NY

15d•Onsite

About The Position

We are expanding our DataOps & Analytics team and seeking a Power BI Developer & Data Analyst who can move quickly, think strategically, and build high-impact dashboards with minimal direction. This role is ideal for someone who thrives in a fast-paced environment, understands how to translate conversations into data solutions, and enjoys building reporting ecosystems from the ground up. You’ll work across multiple enterprise platforms—Salesforce, HubSpot, HHAExchange, AdvancedMD, HRIS, Payroll, CliniqueIQ, phone systems, and more—helping create dashboards that drive operational performance, strategic decision-making, and company-wide visibility. If you are a Power BI rockstar who wants autonomy, visibility, and meaningful work, this role is for you.

Requirements

5+ years of hands-on Power BI development experience.
Advanced proficiency in DAX, Power Query (M), data modeling, and data visualization.
Expert-level SQL skills – able to write complex joins, CTEs, window functions, aggregations, and multi-table queries without guidance.
Able to rapidly create SQL scripts from business requirements (e.g., KPIs in Excel, verbal direction, or existing reports) and reverse-engineer existing logic when needed.
Experience profiling data and understanding database schemas, including identifying keys, interpreting relationships across databases, and diagnosing data quality issues.
Experience integrating data via APIs, ODBC connectors, cloud storage, CSV/Excel, or other modern ingestion methods.
Hands-on experience with relational databases (SQL Server, MySQL, Postgres, etc.) and building new views, tables, or stored logic for reporting.
Familiarity with AWS S3 and data lake concepts, and how Power BI leverages those architectures.
Strong understanding of data architecture and ETL processes, including fact/dimension modeling, star schemas, transformation logic, and incremental loading.
Comfortable working with incomplete or messy data, resolving key mismatches, deduping logic, and creating temporary structures to support high-quality reporting.
Ability to quickly convert business conversations into technical requirements and deliver working dashboards.
Experience optimizing queries for performance, scalability, and large datasets.
Strong analytical and critical-thinking skills with exceptional attention to detail.

Nice To Haves

Experience with Salesforce object model & reporting
Experience with HubSpot, HHAExchange, AdvancedMD, or HRIS/payroll systems
Knowledge of healthcare or home care data workflows
Python, R, or Alteryx experience
Familiarity with data governance, master data management (MDM), or data quality frameworks

Responsibilities

Build visually compelling, insight-driven dashboards in Power BI for executive and operational use.
Convert SQL queries, Excel KPIs, and multi-system datasets into interactive Power BI visuals.
Design robust data models, develop DAX measures, and optimize report performance.
Establish standards for layout, UX, storytelling, and design consistency.
Connect Power BI to multiple sources (API, ODBC, cloud connectors, AWS S3, flat files).
Partner with IT and external vendors to leverage data lakes and pipelines.
Create and manage ETL/ELT workflows and data transformations as needed.
Handle complex data relationships, including mismatched IDs or incomplete keys across systems.
Translate verbal requirements and business problems into measurable KPIs and dashboards.
Understand operational processes (caregiver, patient, HR, marketing, scheduling) and integrate them into analytics.
Conduct data validation, identify anomalies, and propose data-driven solutions.
Provide executive-ready summaries and analytic insights that support decision-making.
Deliver high-quality dashboards rapidly, even when working with unfamiliar systems.
Ask sharp clarifying questions early to lock in direction and minimize rework.
Communicate progress clearly and manage multiple projects simultaneously.
Operate with a high sense of ownership, accountability, and attention to detail.