The UK's Leading Data & Analytics Jobs Board

Senior Data Warehouse Developer

Advertiser
Harnham
Company
Harnham
Date Posted
6th October 2016
Reference
1000
Category
Developer
Location
New York
Salary
$5,000 Per Annum
Contract Type
Full Time

Senior Data Warehouse Engineer

Harnham is looking for a data warehouse and ETL architect with a good command of SQL experience with data warehouse and business intelligence tools.

Responsibilities:

  • Lead a small team of technical resources to design, develop (hands-on), and maintain a robust enterprise data warehouse, SSIS-based ETL process, and business intelligence and reporting solution.
  • Participate in thought leadership and ongoing decisions regarding information architecture, data collection, data analysis methodology, and information distribution.
  • Work with business users, management, and executives to analyze, define, and document business requirements for PURE's data needs.
  • Use domain knowledge and business requirements to model subject areas and data attributes.
  • Create complex SSIS packages to support ETL processing.

Requirements:

  • 5+ years related work experience, preferably in a consulting-type environment.
  • In-depth experience with Microsoft's data warehousing, business intelligence, and reporting tools - SQL Server and complex SQL Server Integration Services (SSIS) packages, including knowledge of best practices and techniques for logging, auditing, error handling, and performance tuning.
  • Understanding of P&C business processes and related data (product and pricing development, underwriting process and workflow, claims processing, reinsurance, etc.).
  • Experience implementing one or more "mainstream" business intelligence platform (e.g., Cognos, Business Objects, Tableau, Information Builders, Qlikview, SSRS, etc).
  • Extensive experience with design and implementation of enterprise data warehouses (design considerations, star schemas, logical/physical design of relational and dimensional databases, Kimball and Inmon methodologies)
  • Experience developing KPIs, executive dashboards, scorecards (financial and non-financial metrics), and ad-hoc reporting (from relational, dimensional, and OLAP data sources).

Preferred Skills

  • Expert in SDLC for data warehouse and reporting projects (Agile Scrum, waterfall, etc.)
  • Experience with SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS).
  • Experience with tools for predictive analytics (e.g., SAS, SPSS, R).

HOW TO APPLY? :

Please register your interest by sending your CV via the apply link on this page.

Register and Apply

Login and Apply

Profile Options

Category(s) you would like to work in*:
Location(s) you would like to work in*:
Contract Type*:
Most Recent Position*:
Education/Qualification*:
Minimum Salary required*:
Willing to Relocate*:
By submitting this form you agree to our terms of use

Copyright © 2017 Big Data Jobs Board. SEO by SEMtelligence