Business Intelligence Developer

City of New York•New York, NY

1d•$125,000 - $136,500•Hybrid

About The Position

The NYC Department of Finance (DOF) is responsible for administering the city's tax revenue laws. The Finance Information Technology (FIT) Division supports all aspects of DOF's computer systems. The Web Application and Data Warehouse Development and Support unit is seeking a Business Intelligence Developer for the FIT Data Integration and Business Intelligence Team (FIT DIBI). This role will utilize Power BI and Business Objects to create data visualizations, dashboards, and reports to provide stakeholders with business and operational insights. The developer will be involved in the full software development lifecycle for the reporting team and will collaborate with the Data Integration team. Experience in enterprise business visualization and reporting with Power BI and Business Objects, along with strong SQL skills, is required.

Requirements

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 on Webi.
Experience working with Oracle, DB2 and SQL Server.
Excellent collaboration and communications (oral and written) skills are required.
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, Education and/or experience which is equivalent to '1' above.

Nice To Haves

Experience with Crystal Reporting is a plus.

Responsibilities

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.
Collaborates 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.
Demonstrates these models to the users to ensure that user expectations are met.
Ensures that software products and solutions are appropriately tested to meet functional (usability) and technical (performance) requirements.
Creates test cases, test scripts and defect reports.
Executes test scripts and documents progress and results.
Assists testers during the testing phase to ensure that the users understand the changes and/or new features.
Researches and identifies emerging technologies, coordinates 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.
Collaborates with business analysts to understand business requirements and objectives.
Analyzes reporting requirements and translating these requirements into technical requirements.
Designs solutions to satisfy the visualization and reporting requirements using best practices.
Develops solutions for these deliverables using Business Objects, Power BI, SQL, KSH and other technologies.
Tests solutions to ensure that dashboards and reports meet requirements and achieve the desired outcomes.
Implements/Migrates the business intelligence dashboards and reports to other environments and provides documentation for users.
Supports the reports (outside of working hours if needed) by addressing scheduling and run-time issues raised by the users or FIT personnel.
Collaborates and communicates with management, end users, the Solutions Delivery Office, data analysts, and other technologists to ensure the success of the project.
Provides statuses and updates to management as required.