Business Intelligence Developer

Talentify; New York (NY); Hybrid; USD 95,000 - 135,000; Full time

Benefits offered by this job

Remote work up to 2 days/wk

Job summary

City of New York Department of Finance (DOF) seeks a seasoned Business Intelligence Developer to design, build, and optimize BI solutions using Power BI and Business Objects. You will work with the FIT Data Integration and BI team to deliver dashboards and reports that drive actionable insights for city services.

The role requires 5+ years in BI reporting, strong SQL skills, and experience with WebI, Oracle, DB2, and SQL Server.

Qualifications

• 5+ years of experience in BI reporting, dashboards, and SQL.
• At least 5 years with Business Objects and Power BI.
• Experience creating, designing and formatting WebI reports.
• Experience with Oracle, DB2 and SQL Server.
• Strong collaboration and communication skills.

Responsibilities

• Lead design, development, testing and implementation of BI solutions.
• Create interaction models and interface designs for IT projects based on requirements.
• Develop dashboards and reports using Power BI and Business Objects.
• Translate business requirements into technical specifications and solutions.
• Support and maintain BI dashboards/reports across environments and users.
• Collaborate with management, analysts and other technologists to ensure project success.

Skills

BI reporting

Dashboards

Power BI

Business Objects

SQL

Crystal Reports

WebI

Oracle

DB2

SQL Server

Communication

Education

Bachelor's degree

Tools

Power BI

Business Objects

Crystal Reports

WebI

Oracle

DB2

SQL Server

SQL

Job description

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

Qualifications

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. Education and/or experience which is equivalent to "1" above.

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.