Developer Reporting, Correctional Health Services

About NYC Health + HospitalsNYC Health + Hospitals is the largest public health care system in the nation. We are a network of 11 hospitals, trauma centers, neighborhood health centers, nursing homes, post-acute care centers, and correctional health services. We are a home care agency and a health plan, MetroPlus. Our health system provides essential services to 1.4 million New Yorkers every year in more than 70 locations across the city's five boroughs. Our diverse workforce of more than 42,000 employees are uniquely focused on empowering New Yorkers, without exception, to live the healthiest life possible. Visit us at and stay connected on or Twitter@hhcnyc.NYC Health + Hospitals/Correctional Health Services is one of the nation's leading correctional health care systems in quality of and innovations to care, and access from pre-arraignment through compassionate release. In-jail services include medical, nursing, mental health, substance use treatment, social work, dental and vision care, discharge planning, and reentry support. In addition to providing direct patient care in the jails, CHS leverages the resources of the nation's largest municipal health care system to help discharged patients successfully return to their communities. CHS is also a pivotal partner in New York City's criminal justice reform efforts.Job DescriptionA Report Writer who is team oriented and can also work independently would be responsible for Report programming, creation of Ad Hoc data sets, TSQL Stored procedures, creating functions, Data Extraction, Importing of data for the use of reports or analysis.Conduct code QA, testing and remediation. The data reported or pulled is from various internal systems (Centricity, Ascend, eCW, home grown systems) will analyze, design, program, test, troubleshoot, publish, maintain existing reports and data based dashboards. Work on multiple projects independently and part of a larger team based projects. Performs first-level QA of generated reports. As needed, becomes familiar with CHS workflows. Maintains reference tables, functions and other tools needed to improve report accuracy.Position requires excellent T-SQL programming language skills (i.e. multiple joins, combining queries with set operators, scalar and aggregate functions, nested group aggregates, crosstabs, correlated subqueries, table variables, query optimization, stored procedures etc.} and experience with SQL Server, SSRS 2008 R2 or later, Power BI.Troubleshoot problems and maintain legacy reports and dashboards. Help to collect and define functional requirements, document and contribute to technical design discussions as well as perform other organizational related duty or projects as needed.Healthcare experience/at least 2+years of work experience/bachelor's degree preferred.Minimum Qualifications1. A Masters Degree or advanced clinical degree from an accredited college or university and two years of experience serving as a lead in soliciting, defining, and managing requirements for internally and externally developed software in a clinical, allied health, non-allied health, behavioral health, information technology, information services, business, analytics or related area; or, one year of experience in a relevant clinical and/or healthcare administration role/function; or2. A Baccalaureate Degree from an accredited college or university and five years of experience as described above; or3. A satisfactory combination of education, training, and experience.4. Specialty certification(s) issued by a national commercially available program, state, professional society, academic or technical institution in an area(s) listed above, may be credited on a month-to-month basis toward the required work experience for a total of one year.How To ApplyIf you wish to apply for this position, please apply online by clicking the "Apply Now" button or mail your resume, noting the above Job ID #, to:NYC Health + Hospitals / Correctional Health ServicesTalent AcquisitionHuman Resources Department55 Water Street, 18th FloorNew York, NY 10041Attn: Talent AcquisitionIf applying online, please include your cover letter in the same file attachment with your uploaded resume.NYC Health and Hospitals offers a competitive benefits package that includes:Comprehensive Health Benefits for employees hired to work 20+ hrs. per weekRetirement Savings and Pension PlansLoan Forgiveness Programs for eligible employeesPaid Holidays and Vacation in accordance with employees' Collectively bargained contractsCollege tuition discounts and professional development opportunitiesMultiple employee discounts programs