Power BI Developer & Data Analyst
1 day ago
New York
Job DescriptionSalary: $100,000 - $130,000 Company Overview At True Venture Group, we are more than a leader in community-based healthcarewe are catalysts for meaningful change. Our mission is to identify and nurture business opportunities that drive innovation, enhancing the health and well-being of the communities we serve. Our unwavering commitment to expanding access to care and promoting health equity fuels everything we do. We empower underserved populations with a diverse range of home-based care services, including Home Health Aide (HHA) services, Remote Patient Monitoring (RPM), Chronic Care Management (CCM), Independent Living Skills Training (ILST), Community Health Initiatives (CHI), and the Consumer Directed Personal Assistance Program (CDPAP). By navigating the complexities of the healthcare system, we ensure that high-quality care reaches those who need it mosthelping individuals thrive at home with dignity and independence. At True Ventures Group, we dont just shape businesseswe shape the future of care. Through strategic innovation, deep expertise, and an unwavering focus on excellence, we deliver transformative healthcare solutions that make a lasting impact. Together, we are redefining community-focused care and setting new standards for whats possible. Reports To: Director of Technical Operations & Analytics About the Opportunity 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. Youll work across multiple enterprise platformsSalesforce, HubSpot, HHAExchange, AdvancedMD, HRIS, Payroll, CliniqueIQ, phone systems, and morehelping 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. What Youll Do Power BI Development • 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., • 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., • 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., • 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. A successful candidate: • Learns new systems quickly and builds reports independently., • Delivers meaningful dashboards within tight timelines., • Understands business logic behind KPIs, not just the visuals., • Brings forward-thinking ideas and streamlined approaches., • Handles messy, complex real-world data with confidence., • Communicates clearly with both technical and non-technical teams., • Thrives in a dynamic, fast-paced environment and adapts quickly to changing priorities. Required Qualifications • 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. Preferred Qualifications (Nice-to-Have) • 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 Why Join Us? • Build high-visibility dashboards that influence operational and executive decisions., • Work directly with leadership in a role that has immediate impact., • Help shape a modern reporting infrastructure from the ground up., • Join a collaborative, growth-oriented team where your skills and ideas matter., • Be part of a mission-driven organization focused on improving patient care and caregiver operations. What We Offer • Comprehensive Medical, Dental, and Vision Benefits, • Weekly pay with direct deposit, • 9 Paid company holidays, • 401(k) Employer Matching