Skip to content

Altorel LLC

BI Developer

Posted Updated

Description

Title : BI Developer

Duration : Full time

Location : Boston, MA

Salary : Depands on experience


As the BI Developer, 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

Face to Face is must. Outstation candidates must be willing to attend interview at their own expense.

Skills

What Senior Data Analytics jobs ask for — and how much of it you have →
Apply

Apply to BI Developer at Altorel LLC

Create a free account first, or go straight to the employer.

Free RoleWatch account

  • Get an email when new jobs match your search
  • Save jobs and track every application
  • See how well your CV matches each job

Already have one?

No account needed. Opens the employer's own site in a new tab.

See also

Data Analytics jobs by country — openings, pay and top skills →