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

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