BI Developer

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

Job summary

Altorel LLC in Boston is looking for a skilled BI Developer to enhance their data warehouse and business intelligence capabilities. The role involves developing ETL processes, analyzing internal and external data requests, and collaborating across business units.

The ideal candidate should have strong analytical skills, proficiency in Microsoft BI Stack, and experience in reporting design and information architecture. A Bachelor's degree in computer science is required, and strong verbal and written presentation skills are essential.

Qualifications

• 5+ years of relevant experience in reporting and information architecture.
• Understanding of ETL, Staging, DW, ODS, Data Marts, and BI Tools.
• Experience with complex environments and deploying MPP Databases.

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.

Skills

Reporting/analytical design

ETL processes with Microsoft BI Stack

Intermediate programming skills (Perl, Python, Java)

Knowledge in Hadoop ecosystem

SQL proficiency

Education

Bachelor's in computer science

Tools

Microsoft BI Stack

Informatica

SQL Server

Job description

Altorel born in 2008 with a vision of providing flexible delivery models at an optimized costs to technology clients, had continuously thrived to achieve the same with innovative techniques, relationship building and integrated approach. Altorel has been dedicated to provide its clients quality professionals with technical and behavioral skill matching to distinct hiring requirements and workplace environment. We collaborate with customers to consistently and cost-effectively plan, execute and deliver high-quality services and results. Our consultants are professionals hand picked to build long-lasting & trusting relationships that bring synergy, integrity & professional value to both employees and employers.

Job Description

Title : BI Developer

Duration : Full time

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
• 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
• Continuously 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
• 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 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
• Strong verbal and written presentation skills
• Energetic self-starter who has the ability to work with minimal supervision
• Bachelor's in computer science

Additional Information

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