Benchmark IT Published: August 23, 2017

SQL Server Developer - Contractor

Job ID:


Position Title: Data Warehouse Developer (SQL)
Position Summary / Primary Duty:
Our direct client's IT department seeks an experienced Management Information professional to provide support for its strategic MI initiatives. The role will involve gaining a comprehensive understanding of our current transactional systems and the data held therein as well as involvement in the ongoing maintenance of warehouse technology. Key to our initiatives is the transformation and consolidation of data from disparate US and UK systems into a common model.
Functional Responsibility:
: Work to maintain and improve the design of data warehouse / data marts in order to meet the data requirements of business departments within their (underwriting, actuarial, finance, claims etc), keeping scalability, performance and extensibility in mind.
: Enhancement of data sources, data movement and reconciliation with the dual goals of ensuring data quality & consistency and the ability to satisfy relevant business requirements.
: Maintain data transformation and data movement components of Global Data Warehouse in-line with the existing approach and architecture.
: Understanding of current US and European data sources and reporting / MI capabilities.
: Collaboration with business analysts and business stakeholders to ensure a thorough understanding of strategic data requirements.
: Data analysis / data profiling to understand gaps, inconsistencies and other quality issues in existing source system data, and develop data sourcing solutions, as well as collaborating with stakeholders to identify, document and implement corrections / business rules / work-arounds.
: Collaboration with business analysts and IT development staff, in US and UK, to foster their complete understanding of their universe of data.
: Proactively propose new ideas and approaches.
: Design and develop presentation vehicles including reports, queries and analytics as specified.
: Experience of working in IT organization of property / casualty insurer - desirable
: Experience with support of data warehouse / data mart solutions for large, complex datasets using ETL tools - essential
: Experience in implementation of controls and reconciliation reports - essential
: Experience in reporting toolsets, OLAP tools, job scheduling, publishing and distribution of reports - desirable
: Experience with multi-location, global team - desirable
Skills and Knowledge:
: T-SQL development including the use of views, stored procedures and indexing techniques - essential
: SQL Server database (versions 2012, 2014) - essential
: SQL Server Integration Services - essential
: Strong investigative/troubleshooting skills - essential
: Knowledge of property / casualty insurance in US and/or Lloyd's/London Markets - desirable
: Experience with Subscribe and/or Genius insurance systems - desirable
: Minimum Education: Degree level or equivalent
Characteristics of the successful candidate:
: Pragmatic and collaborative approach to problem-solving
: Self starter, able to manage own workload and juggle tasks appropriately
: Proactive with suggestions for improvements; thinks laterally; receptive to new ideas
: Takes ownership of a piece of work and sees it through to completion
  • Drop files here or
    Accepted file types: docx, doc, pdf, rtf, wps, txt, html.
Refer a Friend

Related Jobs

August 23, 2017
JOID:4656 Systems Support Analyst   Greenwich, CT new
August 23, 2017
JOID:4672 Developer   Wilton, CT new
August 23, 2017
August 23, 2017
JOID:4619 Mechanical Engineer   Wilton, CT new
August 23, 2017