Previous Job
BI Developer
Ref No.: 18-01256
Location: New York, New York
Start Date: 10/22/2018
Assignment Number: RCI-ITCS4-4305A
Agency: Office of the Mayor
Work Location: New York, NY
Scheduled Work Hours: 35 hours/week
Assignment Start/End Date: Immediate start
Total Estimated Assignment Hours: 13 months
Functional Job Title BI Developer

  • Provide technical support for the maintenance and development of MOCS reports and dashboards in IBM BI.
  • Develop enterprise reports or ad hoc analysis based on defined requirements for projects in IBM BI
  • Design and build successful technical solutions that involve BI Reporting and Dashboarding against enterprise data warehouse, relational tables, and other source systems
  • Analyze historical data to identify trends and insights (such as spend analysis and business KPIs) and benchmark against previous performance periods and across the City
  • Perform proper testing and validation techniques to insure accuracy and integrity of reported or extracted data and document the unit test and validation processes used
  • Support the maintenance of existing reports and data sets for interim system updates and major system releases while contributing to maintaining the report inventory
  • Manage requests and/or components of larger projects with appropriate documentation and status reports

  • Extensive experience with IBM BI (Analytics 11 platform required) Dashboard and Reporting modules
  • Strong knowledge of and experience with IBM BI Data Framework Manager, data modules, creating and modifying hierarchies, integration with Mapbox
  • Ability to write complex SQL statements using SQL / T-SQL. Experience working with complex SQL and its variations (such as PL/SQL) is an asset.
  • Strong Knowledge of XML technologies (XML, XSL, XSD)
  • Hands on knowledge of SOA, PKI, web services, Enterprise Service Bus technologies.
  • Strong knowledge of python (pandas library experience preferred) and java
  • Expertise with integration technologies and processes, enterprise data warehouse implementations and reporting tools, integrating multiple legacy and strategic systems.
  • Knowledge of testing tools and techniques and executing test scripts to test performance
  • Strong knowledge of database back-end systems, including SQL Server 2008 R2 / 2012.
  • Proficient with BI, including Facts, Dimensions & various Schemas supporting them.
  • Strong written, verbal and interpersonal skills;
  • Excellent analytical, organization, presentation and facilitation skills; ability to handle multiple tasks under tight deadlines;
  • Knowledge of database administration, repository management, and data warehousing practices.
  • Familiarity with New York City's data share platforms, including Open Data (DOITT's DataShare) (FMS, PIP, VENDEX, APT, HHS Accelerator).
  • Working knowledge of database front-end systems, including MS Access.
  • Experience in object-oriented languages (i.e. Java, C#, etc.)
  • Experience in scripting languages (i.e. VBA, PowerShell, etc.)
  • Past utilization of code repositories including, GitHub, Bitbucket, or GitLab.
  • Experience with developing solutions for distributed architecture and management of large datasets using Hadoop and Spark or similar frameworks;
  • Use of software development collaboration tools, including Jira, Slack, Team Foundation, and Base Camp.