Job Description PROGRAM DESCRIPTION HR Workforce Analytics drives HR business process improvements, which include the following duties: -systems automation, -providing HR workforce reporting analytic solutions and visualizations, -fulfilling day-to-day data analysis requests across the agency, and -overseeing user permission access authorization for HR Central applications. JOB DESCRIPTION: As the Business Intelligence Analyst you will collect, analyze and present data to help DOHMH make informed business decisions. Reporting directly to the Senior Director of Workforce Analytics the Business Intelligence (BI) Analyst will perform the following: 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. --Perform other duties as assigned. WHY YOU SHOULD WORK FOR US: - Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance. For more information, please visit the U.S. Department of Education’s website (https://studentaid.gov/pslf/) - Benefits: City employees are entitled to unmatched benefits such as: o a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment. o additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund. o a public sector defined benefit pension plan with steady monthly payments in retirement. o a tax-deferred savings program and o a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers. - Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home. - Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work. Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of 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 social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise. Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers! COMMITMENT TO EQUITY: 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. The NYC Health Department is an inclusive equal opportunity employer committed to providing access and reasonable accommodation to all individuals. To request reasonable accommodation to participate in the job application or interview process, contact Sye-Eun Ahn, Director of the Office of Equal Employment Opportunity, at sahn1@health.nyc.gov or 347-396-6549. Qualifications 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. Additional Information 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.