Previous Job
Previous
Senior Data Warehouse developer
Ref No.: 12-00041
Location: New York, New York
Position Type:Direct Placement
Experience Level: 7 Years
Start Date: 02/13/2012
 

Job Definition:

  • The Senior Data Warehouse Developer provides technical support and direction in the development and support of the Data Warehouse, Data Mart, and Business Intelligence solutions.
    • The Data Warehouse Manager would delegate prioritized tasks to the Senior Data Warehouse Developer, who is responsible for understanding the assigned task, dependencies and expected time frames that such task should be completed.
    • The IT Project Manager coordinates project activities while the Manager of Application Architecture and Development would provide technical direction, standards and conduct code quality reviews for the Senior Data Warehouse Developer.

 Authority

  • Executes the responsibilities of the Senior Data Warehouse Developer according to policies, procedures and standards, as established in ¿Published Policies and Procedures¿ and ¿Tower Employee Handbook - Working at Tower¿.

Required Skills

Duties and Responsibilities

  • Participates in all phases of the development life-cycle with minimal direction.
  • Interfaces with analysts to review requirements and develop design specification documents.
  • Designs and develops new database objects including procedures, SSIS ETL packages, data marts, universes, and reports as per the business user requirements and jobs as per the business user requirements and the design documentation.
  • Provides production support and maintenance of database and BI applications and objects used within the data warehouse, data marts, and BI solutions, and works with other team members in optimizing system performance, addressing operational issues, resolving production problems and providing timely follow up.
  • Knowledgeable about the data residing in the data warehouse and can deliver the information to business customers through technology to meet specific business needs.
    • Develops data flow, application and ER diagrams and technical specifications.
    • Develops production migration steps, and perform unit and system integration testing.
    • Works with the rest of the team to continually improve development standards, tools, code templates, checklists and other company methods, processes, and documentation.

Required Experience

Skills and Experience Desired

  • A Bachelor degree in Computer Science or equivalent experience, and at least 7 years of developing and implementing applications in the workplace.
  • Strong  SSIS development experience
  • Experience designing systems in a distributed software environment is required.
  • Utilized development and architectural standards, methodologies, version control, software deployment preferred, packaging and quality control.
  • Deployment of data access and analysis tools
  • Finalized requirements document
  • Business metadata definitions and access methods
  • End user training sessions
  • Documentation of process, including configuration and security
  • Timely change management documentation5-7 years Database Design/Development - SQL Server ,SSAS, SSIS, Oracle (a plus)
  • 3+ years Business Objects Universe Design and Report Design/Development
  • Strong stored procedure development experience
  • Data Warehouse / Business Intelligence analysis, design and development experience (including Dimensional Data Modeling - Star Schema, Facts & Dimensions)
  • Strong analytical skills, especially data analysis and problem resolution
  • Ability and willingness to learn quickly and independently and work on multiple technologies simultaneously
  • P&C insurance experience in Data Warehousing is a big plus

Key Deliverables

  • Deployment of data access and analysis tools
  • Finalized requirements document
  • Business metadata definitions and access methods
  • End user training sessions
  • Documentation of process, including configuration and security
  • Timely change management documentation

 

Job Location

New York, NY, US.

Position Type

Full-Time/Regular