Business Intelligence Developer

Department-of-Finance; New York (NY); Hybrid; USD 90,000 - 125,000; Full time

Benefits offered by this job

Remote work up to 2 days/week

Diversity & Equal Opportunity Employer

Job summary

NYC Department of Finance is seeking a Business Intelligence Developer for the FIT Data Integration and BI Team. You will build dashboards and reports using Power BI and Business Objects, collaborate across IT, and participate in the full software development lifecycle.

The role emphasizes BI visualization, SQL proficiency, and effective communication with stakeholders; remote work up to two days per week is possible under the pilot program.

Qualifications

• Experience in BI reporting, dashboards and SQL is required.
• Min. 5+ years with Business Objects and Power BI; Crystal Reporting is a plus.
• Proven ability to design and format reports on WebI.
• Experience with Oracle, DB2 and SQL Server databases.
• Strong collaboration and written/verbal communication skills.

Responsibilities

• Lead design, development, testing and implementation of BI solutions.
• Collaborate with technical teams to define requirements and ensure delivery.
• Create interaction models and interface designs for IT projects.
• Test dashboards and reports to meet usability and technical requirements.
• Document and maintain dashboards and provide user support.
• Communicate project status to management and stakeholders.

Skills

BI reporting

Dashboarding

SQL

Business Objects

Power BI

Crystal Reports

WebI

Oracle

DB2

SQL Server

Communication

Education

Bachelor's degree

Tools

Power BI

Business Objects

WebI

Crystal Reports

Oracle

DB2

SQL Server

Job description

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’s Web Application and Data Warehouse Development and Support unit, seeks 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 duties and responsibilities will include, but not be limited to:

• Leads and participates in the design, development, testing and implementation of business solutions using collaboration tools that focus on speed to market, return on investment and delivery of business value. Collaborate with technical teams to understand application capabilities, environment set up and defect fixes.
• Creates interaction models and interface designs for IT projects based on established standards, business and technical requirements and input from functional team members. Demonstrate these models to the users to ensure that user expectations are met.
• Ensure that software products and solutions are appropriately tested to meet functional (usability) and technical (performance) requirements. Create test cases, test scripts and defect reports. Execute test scripts and document progress and results. Assist testers during the testing phase to ensure that the users understand the changes and/or new features.
• Research and identifies emerging technologies, coordinate demonstrations, and proof of concept initiatives.
• Effectively articulates project nuances and complexities to management, stakeholders and colleagues while being responsive and sensitive to underlying politics.
• Elicits, documents, and analyzes business requirements on information technology projects to recommend business and information technology solutions. Assesses business problems and process gaps; identifies opportunities for new requirements. Collaborate with business analysts to understand business requirements and objectives.
• 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. Experience with Crystal Reporting is a plus.
• Professional experience in creating, designing and formatting reports on Webi.
• Experience working with Oracle, DB2 and SQL Server.
• Excellent collaboration and communications (oral and written) skills are required.

IT PROJECT SPECIALIST - 06797

Minimum Qualifications

1. 1. A baccalaureate degree from an accredited college and four years of satisfactory full-time experience related to the area(s) required by the particular position; or,
2. 2. Education and/or experience which is equivalent to "1" above.

Preferred Skills

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

Public Service Loan Forgiveness

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

Residency Requirement

New York City Residency is not required for this position

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.