The UK's Leading Data & Analytics Jobs Board

Senior Data Warehouse Developer

Date Posted
6th October 2016
New York
$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.


  • 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.


  • 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).


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*:
Minimum Salary required*:
Willing to Relocate*:
By submitting this form you agree to our terms of use

Copyright © 2018 Big Data Jobs Board. SEO by SEMtelligence