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: Jobs@bhirednyc.com