IMPORTANT NOTE: ONLY CANDIDATES WHO HAVE A PERMANENT COMPUTER SPECIALIST (SOFTWARE) OR COMPARABLE CIVIL SERVICE TITLE WILL BE CONSIDERED FOR AN INTERVIEW. PLEASE INCLUDE YOUR EMPLOYEE IDENTIFICATION NUMBER (EIN) AND TITLE WHEN APPLYING.

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.

DOF’s Finance Information Technology (FIT) Division designs, builds, and supports all facets of DOF’s computer systems, including hardware, software, applications, infrastructure, telephone, and data security. FIT delivers and administers tax-related payment programs for the City of New York by providing the information technology solutions needed to achieve its mission of collecting revenue while ensuring an efficient and improved customer experience. FIT is also responsible for the systems and websites which enable citywide payments, land records, property assessment, parking adjudications, customer service, and the Sheriff’s public safety work.

FIT is seeking a Business Intelligence Developer for the FIT Data Integration and Business Intelligence Team (FIT DIBI). The Business Intelligence Developer will use Power BI and Business Objects to develop data visualizations, dashboards, and reports to help stakeholders glean business and operational insights from data. In addition, the successful candidate will be directly involved in all aspects of the software development life cycle for the reporting team and will work closely with the Data Integration team. Applicants should be experienced in enterprise business visualization and reporting using Power BI and Business Objects and well versed in Structured Query Language (SQL).

Reporting to the Director of Information Management, the selected candidate’s responsibilities will include, but not be limited to the following:

- Analyzing reporting requirements and translating these requirements into technical requirements.
- Designing solutions to satisfy the visualization and reporting requirements using best practices.
- Developing solutions for these deliverables using Business Objects, Power BI, SQL, KSH and other technologies.
- Testing solutions to ensure that dashboards and reports meet requirements and achieve the desired outcomes.
- Implementing/Migrating the business intelligence dashboards and reports to other environments and providing documentation for users.
- Supporting the reports (outside of working hours if needed) by addressing scheduling and run-time issues raised by the users or FIT personnel.
- Collaborating and communicating with management, end users, the Solutions Delivery Office, data analysts, and other technologists to ensure the success of the project.
- Providing statuses and updates to management as required.


Additional Information:

In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

This position may be eligible for remote work up to 2 days per week, pursuant to the Remote Work Pilot Program agreed between the City and the Collective Bargaining Unit representing employees serving in the civil service title.

Required Skills:

- A strong background in business intelligence reporting, dashboarding and SQL (Required).
- Five or more years of experience with Business Objects and Power BI.
- Professional experience in creating, designing and formatting reports in Webi.
- Experience working with Oracle, DB2 and SQL Server.
- Excellent collaboration and communications (oral and written) skills are required.

COMPUTER SPECIALIST (SOFTWARE) - 13632

(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.

- Experience in creating or modifying Universes to map legacy SQL queries into functional business objects (Dimensions, Measures, Attributes) - Knowledge of scheduling, security settings, and publishing reports to the SAP BusinessObjects Enterprise repository. - Ability to extract and analyze SQL code (including stored procedures, views, and joins) to reconstruct them in the Universe. - Understanding of how to transform relational data into a dimensional model suitable for WebI, especially when converting complex sub-reports. - Experience with Crystal Reporting is a plus. - Ability to translate Crystal Syntax or Basic Syntax formulas into WebI formula language. - Ability to parse complex, nested formulas and conditional formatting to move that logic into the database layer (SQL) or the Universe. - Proficiency in comparing data outputs between the old reports and modified reports to ensure accuracy. - Experience with designing and creating dashboards using Power BI.

This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

New York City residency is not required for this position.

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.