Job: Developer – Data Warehouse/Business Intelligence (HBITS 2107)

Title Developer – Data Warehouse/Business Intelligence (HBITS 2107)
Start Date 2015-02-18
Location US-NY-Rensselaer
Job Information

Position Description/Responsibilities:

Join a world leader in IT metrics and productivity! Computer Aid, Inc.  (CAI) is a full service Information Technology outsourcing firm with more than 30 years of experience and a world leader in IT measurement and IT productivity.


Computer Aid, Inc. is looking for an Expert Level Developer-Data Warehouse/Business Intelligence with 7+ years of experience!   Duration 24 months.
This position comes to us from our NY State contract for Hourly Based Information Technology Services and is located in the Rensselaer – Albany, NY area.  Rensselaer is in the beautiful upstate region of NY, which is only a few hours from Boston, New York City, Montreal, and the spectacular mountains of the Adirondacks.



Consider applying today as time is limited on this and other positions like it for the state of NY.


Respond with your updated resume to be considered and read all the details listed here as the State contract is very specific concerning experience level and skills.



Position Requirements/Technical Skills:


Project Scope- duties of position


Data Warehouse for Juvenile Justice enhancements


A Data Warehouse/Business Intelligence Developer resource is needed for the OCFS Data Warehouse/CONNECTIONS Reporting Module. The DW is sourced from the agency’s major child welfare case management related systems: CONNECTIONS, CCRS, and WMS. The Data Warehouse effort consists of multiple sub-projects. The efforts over the next period will include priorities including: Kinship Guardianship Assistance program Reporting Module; Casework Contact reporting; Risk Assessment details Reporting Module; Family assessment Service Plans Analysis Reporting Module; National Youth in Transition Database reporting Module Modifications; B2H and Health Reporting Module; StatsPop Redesign and Building JJIS Data Mart; Load Issue resolutions; Load inquires; Phase II Load monitoring; 2nd level testing of issues and code fixes; CONNECTIONS Quarterly Build changes; Infrastructure upgrades and enhancements (Cognos and Oracle upgrades); and more.


Daily Tasks will include but are not limited to the following:

  • Work in coordination with a team of developers to expand the current Data Warehouse.
  • Work with Business Analyst & customers on analysis and logical design for mappings and ETL.
  • Perform unit testing and correct all identified bugs.
  • Perform complex PL/SQL coding in a Data Warehouse environment.
  • Assist with responding to Juvenile Justice data requests.
  • The individual in this position will work under the direction of a Technical Lead & Project Manager.
  • Perform writing of complex stored procedures/triggers in an Oracle database utilizing PL/SQL.



Expert Level 

You must be an Expert Developer – Data Warehouse/Business Intelligence with documented employment experience of 7+ years (84+ months).


–  You must have experience with analysis, design, coding, component and assembly testing of all application code owned by the Application Team.  Maintenance (Including production support), enhancement and development work.  Write application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions.


–  You must be able to provide leadership of large teams and/or extensive industry experience and is considered at the top of his/her field.


PART B:   Requested Desirable  Qualifications:  The numbered qualifications below are not mandatory, but candidates should meet or exceed in duration and skill set target asked for, at least 4 of numbers 1 through 7.

  1. 84 months experience in a data warehouse setting as a developer utilizing an enterprise data warehouse with dependent data marts.
  2. 60 months experience using advanced Extract/Transform/Load techniques including bulk select, bulk insert, arrays, dynamic SQL and developing detailed incremental ETL processes.
  3. 48 months experience building, maintaining and optimizing Data Marts for efficient usage by applications and users for such tasks as reporting.
  4. 60 months experience in an Oracle Data Warehouse as a developer performing development work.
  5. 84 months experience using PL/SQL.
  6. 48 months experience developing and testing maps in Oracle Warehouse Builder (OWB) or Informatica, including data versioning techniques.
  7. Bachelor’s Degree. Proof of Education for all candidates are to be submitted with all responses.
Apply Now