BI Developer -SSAS / Big Data
Apply NowCompany: Altorel LLC
Location: Boston, MA 02115
Description:
Company Description
A Large Insurance Company
Job Description
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
Qualifications
Bachelor's in computer science
Additional Information
This is a very critical role and client is specifically looking for help with improving Product performance.
A Large Insurance Company
Job Description
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
Qualifications
Bachelor's in computer science
Additional Information
This is a very critical role and client is specifically looking for help with improving Product performance.