Job Description

YOU MUST BE PERMANENT IN THE COMPUTER SPECIALIST SOFTWARE CIVIL SERVICE TITLE, PERMANENT IN A COMPARABLE TITLE ELIGIBLE FOR 6.1.9 TITLE CHANGE.

The Office of Performance Management & Data Analytics (OPMDA) reports critical statistics and data related to the Department of Homeless Services (DHS) as well as to Human Resources

Administration’s (HRA) operations and program services.

OPMDA is requesting to hire one Computer Specialist Software IV to function as a SENIOR MICROSOFT POWER BI DEVELOPER who will:

Lead and oversee the implementation, maintenance, and enhancement of our agency's Power BI reporting and analytics solutions. As the Power BI Systems Manager, he/she will play a crucial role in managing the entire lifecycle of Power BI projects, from requirements gathering and design to development, testing, and deployment. Need expertise in Power BI, data modeling, and system administration will be instrumental in ensuring the effective utilization of Power BI to drive data insights and support data-driven decision-making across the agency.

Manage data extraction, manipulation, transformation and aggregation; evaluate user requests for new or modified programs and development of related business models.

Program and automate reports using SSRS on Oracle and MS SQL Server DB Platforms.

In consultation with the business analysts, develop system modifications as needed for the production of new reports and current reports.

Coordinate with agency ITS staff on development and modifications for interrelated source systems.

Develop and implement a comprehensive Power BI strategy aligned with the organization's goals and business needs. Also maintain OPMDA’s current SSRS infrastructure to eventually convert to Power BI.

Collaborate with business stakeholders and IT teams to identify requirements for Power BI solutions and prioritize projects.

Design and develop data models to support efficient data retrieval and analysis in Power BI.

Implement data integration processes to bring data from various sources into Power BI datasets.

Lead the creation of interactive and visually compelling Power BI reports and dashboards to meet business requirements.

Ensure that reports are user-friendly, provide valuable insights, and adhere to data visualization best practices.

Establish data governance processes to maintain data accuracy, consistency, and compliance with data privacy regulations.

Implement security measures to safeguard sensitive data and control user access to Power BI resources.

Optimize Power BI reports and queries for improved performance and faster response times.

Provide training sessions and user support to help employees effectively utilize Power BI for self-service reporting and analytics.

Address and resolve any Power BI-related issues raised by end-users.

Manage the Power BI environment, including user provisioning, licenses, and system configurations by working with ITS.

Monitor and troubleshoot system issues to ensure smooth operation.

Work Location: 4 WTC/150 Greenwich Street, New York, NY 10007

Hours/Schedule: 9-5

Qualifications

(1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or

(2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in “1" above, including one year in a project leader capacity or as a major contributor on a complex project; or

(3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project.

NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification

requirements.

Special Note

To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming.

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.