A Large Insurance Company

Duration : Full time

Location : Boston, MA

Salary : Depands on experience

Data Warehouse Developer/Programmer/Analyst with Big Data Skills

As the Data Warehouse Developer/Analyst, you will serve as a programmer and Analyst in the development for Client's data warehouse and business intelligence solutions/reports requested by Client Insurance management, statutory entities, and other internal and external customers. This position will be an integral part of the IT Data Warehouse team who are responsible for developing and enhancing the data warehouse ETL, fulfill DOI data calls, internal and external data requests and analytic capabilities of the company.

 Responsibilities

Develop and maintain ETL processes using Microsoft BI Stack (SSAS, SSIS, SSRS), Informatica, AND/OR Big data Stack - Hadoop, Green Plum, AWS, No SQL

Analyze, develop and automate DOI data requests, Internal and external data calls/reports using SQL, SSIS, SSRS, and SharePoint.

Documenting technical requirements / modifications for the design of new reports

Working with guidance from architects to develop an improved ETL process using SSIS or Informatica,

Partnering with business users to scope programming efforts and develop time estimates

Assessing potential limitations and risks associated with the solutions

Providing recommendations on the evolution of the architecture of the overall data warehouse and business intelligence platform/capability

Continual performance tuning, Capacity planning for future growth needs

Work with Client's development team to implement solutions

Ability to work both independently and in groups

Capacity to solve problems related to data

Intricacies of working with financial data

· Works collaboratively across business units and IT to facilitate business requirements gathering for reports

Analyze new and existing business processes utilizing metrics and analytics tools, and make suggestions for change

Evaluate and interpret end user information requirements, and develop and implement appropriate technical solutions

Qualifications:

5+ years of relevant experience in reporting/analytical design and information architecture using Microsoft BI Stack (SSIS, SSAS, SSRS) or Informatica

· Understanding of traditional DW/BI components (ETL, Staging, DW, ODS, Data Marts, BI Tools)

· Intermediate programming and computation skills, preferably with Perl, Python Java, BASH/Shell Scripting and/or C/C++

· Knowledge in complex environments building and deploying MPP Databases, Hadoop ecosystem, in-memory data grids, BI/DW, or equivalent enterprise scenarios

· RDBMS related product experience is strongly preferred (SQL Server, Oracle, Postgres,, etc.)

· Working knowledge of Hive SQL or Spark and UNIX scripting or any interface that sits on Hadoop, Hadoop stack components, NOSQL

· MPP working knowledge such as EMC Greenplum, Paracel, Teradata

· ETL Tools such as Informatica would be preferred.

· Direct experience working on a large scale data warehouse or Hadoop platform is a very strong asset

Insurance experience is preferred

Experience in user experience testing and analysis

SQL programmer

Excellent organization skills

Strong verbal and written presentation skills

Energetic self starter who has the ability to work with minimal supervision

Bachelor's in computer science 

This is a very critical role and client is specifically looking for help with improving Product performance.