Business Intelligence Developer

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.

Minimum Qualifications

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

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.

Residency Requirement

New York City Residency is not required for this position