Business Intelligence Report Developer

Program Overview

The Bureau of Human Resources and Labor Relations provides effective human resource management by developing and implementing policies, programs, and services in support of the agency's values, vision, and mission. The Workforce Analytics Unit drives HR business process improvements including systems automation.

Position Summary

The Business Intelligence Report Developer will join the team to support the core functions of the Division of Administration, Bureau of Human Resources, Workforce Analytics Unit. This position is critical for the success of business decisions made by the bureau, senior management, and leadership.

Duties

• Work with all HR cross-functional teams and other key stakeholders across the agency to identify and implement improvements within HR business process, Human Resources compliance management, Incident Command System Logistics, and other initiatives.
• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions for scalability, manageability, extensibility, performance, and re-use.
• Perform and document data analysis, data validation, and data mapping/design.
• Conduct unit tests and developing database queries and objects to analyze the effects and troubleshoot any issues.
• Design and implement data models to support business intelligence.
• Apply advanced SQL skills to build data models that power BI Dashboards.
• Migrate or replicate existing SSRS and Tableau reports to Power BI environment successfully.
• Triage issues and manage support. Provide proper articulation and reporting of work productivity status to supervisor and HR stakeholders as well as conduct status meetings.
• Create and establish project plans, tasks to ensure timelines/deadlines are met.
• Develop requirement documents, prepare design specifications, document existing data transmission, loading and reporting processes.
• Establish and monitor best practices, policies, procedures and documentation for HR Analytics new solutions in our data warehouse.
• Able to assist in analytics and other related projects across departments as needed.

Qualifications

• Bachelor's or Advanced Degree in Information Systems, Technology, Finance, Economics, or other relevant field is a plus, but not required.
• Strong experience developing and maintaining metrics, dashboards, scorecards, and management reports using Excel, Power BI, Tableau, or similar tools.
• 4-5 years of experience as a dedicated Power BI, SSRS, Tableau Developer.
• Knowledge Power BI, and Tableau Server, Tableau Online and Tableau Desktop.
• Extensive experience in developing, maintaining, and managing Power BI and Tableau-driven dashboards & analytics.
• Working knowledge of Power BI and Tableau administrator/architecture.
• Advanced Power BI, and Tableau development skills required.
• Understanding of advanced calculations and statistical functions.
• Extensive understanding of SQL, rational databases, and normalization.
• Proficiency in use of query and reporting analysis tools, preferably MS SQL Manager.
• High level of competency in Excel (macros, pivot tables, etc.).
• Proven ability to work with business owners in identifying reporting and dashboard requirements.
• Exemplary oral and written communications skills, with the ability to translate technical concepts to non-technical community.
• High attention to detail, data confidentiality, and accuracy.

Benefits

• Hybrid Work Schedule.
• Generous Paid Time Off and Holidays.
• An attractive and comprehensive benefits package including Medical, Dental and Vision.
• Flexible Spending Accounts and Commuter Benefits.
• Company Paid Life Insurance and Disability Coverage.
• 403(b) + employer matching and discretionary company contributions.
• College Savings Plan.
• Ongoing trainings and continuous opportunities for professional growth and development.

Additional Information

• This is a temporary grant-funded position ending November 30, 2027.
• The individual must reside in the tri-state area (NY, NJ, CT) by their confirmed start date.
• Possession of a valid driver's license and reliable transportation is required.
• Preference may be given to individuals residing in New York City (5 boroughs) or surrounding New York State counties.
• This individual will be expected to work non-business hours during emergencies.