Business Intelligence Developer

City of New York • New York City, NY

10d • Hybrid

About The Position

The NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city. The Finance Information Technology (FIT) Division designs, builds, and supports all facets of DOF’s computer systems. 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. The 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. 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:

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level