Established in 1805, the New York City Department of Health and Mental Hygiene (the NYC Health Department) is the oldest and largest health department in the country. Our mission is to protect and improve the health of all New Yorkers, in service of a vision of a city in which all New Yorkers can realize their full health potential, regardless of who they are, how old they are, where they are from, or where they live.

As a world-renowned public health agency with a history of building transformative public health programming and infrastructure, innovating in science and scholarship to advance public health knowledge, and responding to urgent public health crises from New York City’s yellow fever outbreak in 1822, to the COVID-19 pandemic we are a hub for public health innovation, expertise, and programs, and services. We serve as the population health strategist, and policy, and planning authority for the City of New York, while also having a vast impact on national and international public policy, including programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and racial and social justice work, among others.

Our Agency’s five strategic priorities, building off a recently-completed strategic planning process emerging from the COVID-19 emergency, are:
1) To re-envision how the Health Department prepares for and responds to health emergencies, with a focus on building a “response-ready” organization, with faster decision-making, transparent public communications, and stronger surveillance and bridges to healthcare systems 2) Address and prevent chronic and diet-related disease, including addressing rising rates of childhood obesity and the impact of diabetes, and transforming our food systems to improve nutrition and enhance access to healthy foods
3) Address the second pandemic of mental illness including: reducing overdose deaths, strengthening our youth mental health systems, and supporting people with serious mental illness
4) Reduce black maternal mortality and make New York a model city for women’s health
5) Mobilize against and combat the health impacts of climate change

Our 7,000-plus team members bring extraordinary diversity to the work of public health. True to our value of equity as a foundational element of all of our work, and a critical foundation to achieving population health impact in New York City, the NYC Health Department has been a leader in recognizing and dismantling racism’s impacts on the health of New Yorkers and beyond. In 2021, the NYC Board of Health declared racism as a public health crisis. With commitment to advance anti-racist public health practices that dismantle systems that perpetuate inequitable power, opportunity and access, the NYC Health Department continues to work in and with communities and community organizations to increase their access to health services and decrease avoidable health outcomes.

PROGRAM AND JOB DESCRIPTION:

The Bureau of Human Resources and Labor Relations seeks to hire a Business Intelligence (BI) Analyst/Certified IT Developer (Applications) I.

DUTIES WILL INCLUDE BUT NOT BE LIMITED TO:

--Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft SQL Server platform (SQL Server, SSIS, SSAS, and SSRS).

--Contribute to the development lifecycle including gathering and understating of requirements, database and report development using SQL Server 2008 R2/2012.

--Develop prototype views and reports of the data, and work with business users both internal and external to refine their requirements.

--Build solutions for Management Dashboards, KPI's Reporting and Operational Business Intelligence.

--Design and monitor construction of user-facing presentation tools, such as Microsoft SQL Server Reporting Services (SSRS) reports.

--Develop stored procedures and complex functions and views for use in analysis and reporting.

--Develop queries in SQL to provide ad hoc reports, analysis, and datasets based on business needs.

-- Develop Tables, Database objects, ETL Packages, Reports, Cube Models and support the existing components.

--Develop database views to extract data via a consistent means for daily ETL processes routines using SSIS Troubleshoot data issues, validate result sets, recommend and implement process improvements.

--Create and maintain the logical and physical data models for the production and Business Intelligence data warehouse and data marts.

--Define best practices and standards for the data modeling process.

--Perform maintenance and administration of the database platforms and data protection needs as they relate to the database platforms and solutions.

--Conduct performance tuning of existing data structures. Identifies critical integration issues and develop corrective solutions.

--Perform Unit testing and resolve defects Lead the design and construction of an enterprise data warehouse.

--Analyze existing complex systems to understand and document data elements, relationships, data flow, dependencies and their related interfaces.

--Communicate with team members to assess progress of deliverables.

--Explain and teach business intelligence and data warehouse concepts throughout the bureau.

--Demonstrate self-reliance in researching technical solutions and product functionality.

--Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions.

--Establish and implement standards and strategies for data management, lifecycle, and quality.

--Performs other duties as assigned.

1. A baccalaureate degree from an accredited college in computer science, engineering or a related field and four years of satisfactory full-time experience related to information technology service management, process management, operations;

2. A baccalaureate degree from an accredited college and eight years of satisfactory full-time experience related to information technology service management, process management, operations;

3. Education and/or experience which is equivalent to "1" or "2" above.

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.