← Back to jobs

Reporting Analyst (SQL) | Brooklyn, NY · $80K–$100K - 2530

Location
Brooklyn, NY
Work type
Full time
Posted
2026-08-26

Job description

Reporting Analyst (SQL) | Brooklyn, NY · $80K–$100K

About the Role

This role is about owning reporting end to end for a healthcare organization — sitting with business users to understand what they're actually trying to answer, writing the SQL, and delivering results people can trust. Much of the work centers on patient-visit and compliance reporting, so accuracy and consistency really matter. The real value isn't just fulfilling requests as written; it's helping stakeholders get to the right question, which frees the wider data team to focus on integrations, automation, and longer-term improvements. Expect a lot of independence, direct ownership, and steady contact with the people who depend on your work.

Key Responsibilities

Own the Reporting Pipeline

  • Manage reporting requests from start to finish — gathering requirements, writing SQL queries, validating results, and delivering reports
  • Build and maintain recurring reports and dashboards in IBM Cognos Analytics and Power BI, sourced from the eClinicalWorks (eCW) EMR

Partner with Stakeholders

  • Work with users to refine requests and ensure the final report answers the underlying business question
  • Deliver reporting on patient visits, compliance, and other operational needs across the organization

Safeguard Quality & Documentation

  • Review and validate report outputs before delivery, and document report logic so results stay consistent, transparent, and reusable
  • Develop a deep understanding of the data model, including its strengths, limitations, and areas that require extra caution

Improve & Automate

  • Identify opportunities to automate recurring reporting needs
  • Expand self-service reporting capabilities over time

Qualifications

  • Strong SQL skills, including multi-table joins, aggregations, window functions, and common table expressions (CTEs)
  • Solid understanding of relational database concepts and data relationships
  • A consistent habit of validating results through reconciliations, record checks, and other quality-control methods
  • Ability to gather requirements from non-technical users and turn business needs into practical reporting solutions
  • Strong written communication, since much of the clarification process happens over email
  • Comfortable working where priorities shift and requirements aren't always fully defined upfront
  • Experience working with healthcare data or other regulated, sensitive data environments
  • Bonus: familiarity with eClinicalWorks (eCW) or a comparable EMR
  • Bonus: experience with Cognos (Report Studio or Cognos Analytics authoring) — not required, as strong SQL matters far more
  • Bonus: a track record of reducing recurring reporting through automation or self-service solutions

Interested? Send your resume to: [email protected]

Original source