Apply on Employer Site

True Care Home Care · 1 month ago

Power BI Developer & Data Analyst (100% Onsite)

Brooklyn, NY

Full-time

Onsite

Senior Level

$100K/yr - $130K/yr

5+ years exp

True Care is a leader in community-based healthcare focused on enhancing health and well-being. They are seeking a Power BI Developer & Data Analyst to build impactful dashboards and translate business needs into data solutions across multiple platforms.

Health CareHospitalTherapeutics

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

Qualification

Power BI developmentDAX proficiencySQL expertiseData modelingETL processesData integrationData architectureAnalytical skillsCritical thinkingAttention to detailCommunication skillsProblem-solving

Required

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