BI Developer -SSAS / Big Data

Altorel LLC; Boston (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

Altorel LLC in Boston is looking for a Data Warehouse Developer/Analyst with expertise in Microsoft BI Stack and substantial data warehousing experience. The role involves collaborating across business units to develop and enhance data warehouse ETL processes, automate data requests, and improve analytics capabilities.

The ideal candidate will have over 5 years of experience in reporting design, strong SQL programming skills, and a Bachelor's degree in computer science. Knowledge of Hadoop and experience in insurance is preferred.

Qualifications

• 5+ years of relevant experience in reporting/analytical design.
• Understanding of traditional DW/BI components (ETL, Staging, etc.).
• Intermediate programming skills, preferably with Perl, Python, or Java.
• Knowledge in complex environments, especially with MPP Databases.
• RDBMS product experience strongly preferred.

Responsibilities

• Develop and maintain ETL processes using Microsoft BI Stack.
• Analyze and automate data requests using SQL and SharePoint.
• Document technical requirements for new reports.
• Work with architects to improve ETL processes.
• Collaborate with business users to scope programming efforts.

Skills

Microsoft BI Stack (SSIS, SSAS, SSRS)

Informatica

SQL programming

Hadoop ecosystem

Perl

Python

Java

BASH/Shell Scripting

C/C++

Education

Bachelor's degree in computer science

Tools

SQL Server

Oracle

Postgres

Hive SQL

Spark

Job description

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
• Document technical requirements / modifications for the design of new reports
• Work with guidance from architects to develop an improved ETL process using SSIS or Informatica
• Partner with business users to scope programming efforts and develop time estimates
• Assess potential limitations and risks associated with the solutions
• Provide recommendations on the evolution of the architecture of the overall data warehouse and business intelligence platform/capability
• Perform continual performance tuning and capacity planning for future growth needs
• Collaborate with Client's development team to implement solutions
• Work independently and in groups to solve data-related problems
• Handle intricacies of working with financial data
• Collaborate 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, 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 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
• Experience with ETL Tools such as Informatica is 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 programming skills
• Strong verbal and written presentation skills
• Energetic self-starter who can work with minimal supervision
• Bachelor's degree in computer science

Additional Information

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