logo

View all jobs

DATASTAGE DEVELOPER

Brooklyn, NY
JOB TITLE: DATASTAGE DEVELOPER
CUSTOMER: CITY OF NEW YORK
LOCATION: Metrotech Brooklyn
DURATION: 3 years with 2 year extension
POSITION NUMBER: 8

PLEASE NOTE: ALL APPLICANTS MUST INCLUDE 2 (TWO) REFERENCES with resume 

PROJECT DESCRIPTION: 
Our Customer (NY City Agency) is mandated to record incidents connected to their facilities and affecting their target population. There is a need for an Incident Management System that will provide process and business automation as well as on demand analytics for any one incident that has occurred in a DHS facility.

Tasks & Duties
  • Develop database design specification
  • Work with Data Architecture team to understand the source and target data models
  • Develop and be a proponent for Data Warehouse development standards, including ETL standards and best practices
  • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data
  • Develop system documentation
  • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs
  • Provide documentation for all developed ETL processes, including process flow and source and target mapping
  • Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures
  • Perform system coding/ evaluation
  • Conduct ETL performance tuning and troubleshooting
  • Perform data analysis and troubleshooting
  • Write complex SQLs and integrate technologies with internal and external data sources
REQUIRED SKILLS:
  • Minimum 4 years experience with Microsoft reporting products, including SharePoint, SQL Server Analysis Services, SQL Server Reporting Services
  • Minimum 4 years experience with Excel Power Query, PowerPivot, Power Map, and other related data products
  • Minimum 4 years experience with Cognos, OBIEE, SAS, Hyperion DW/ETL Tools: Informatica, ODI, Datastage EPM: Hyperion Essbase, Cognos Planning
  • Minimum 4 years experience with Data Analytics: Big Data, ZoomData, Hadoop, machine learning, text analytics, Tableau
     
If interested in pursuing this opportunity, please respond back and include the following:
• Full MS WORD Resume
• Required compensation
• Contact information
• 2 (TWO) references with contact information
• Availability
 
Upon receipt, one of our managers will contact you to discuss in full
 
Stephen Fleischer
Director
INTERMEDIA GROUP, INC.
131 Varick Street
New York, NY 10013
Voice: 212-248-0100
sfleischner@intermediagroup.com
www.intermediagroup.com
 

 
Powered by