View Our Website View All Jobs

Business Intelligence Engineer

The BI / Analytics Team integrates information from multiple transactional systems to the EDW, subject area data marts and cubes to facilitate reporting and data analysis.  The goal is to provide our business partners with visibility into the data / information needed to make key business decisions.

This position will be responsible for the hands-on development and implementation of BI solutions.  The role will entail business requirements analysis, design and development of the data warehouse as well as the user facing analysis and reporting solutions.  There will be a mix of BI project and maintenance level work.

This key role is for a small team collaborating on solutions using Microsoft BI tools on a SQL Server platform.  It will also intentionally blur the lines between a more traditional IT developer role and that of a business data analyst.

Essential Duties and Responsibilities

Requirements analysis and solution design for reporting and data delivery to end users

Data analysis and mapping

ETL and reporting solution development

Adherence to IMG standards and development best practices

Review & revise queries for performance issues

Shared support responsibilities for the Production BI Reporting Environment

Represent the BI development team at change control meetings & ensure that all scheduled releases have gone through an adequate test process and deployment instructions are clear and accurate

Communicate regularly with team members to escalate issues, report status of requests, & identify opportunities for improvements

Help create ad-hoc queries and provide data as requested, with a goal of transitioning to self-serve

Assist the team with the development of a Data Dictionary

Work with business partners on data analytics to help identify key opportunities

Key Requirements

A minimum of 4 years working in information technology with at least 2 years of experience working specifically to deliver BI / data warehousing solutions

Experience developing reporting and analysis solutions using MS tools such as SSRS, SSAS, PowerPivot, PerformancePoint, Power BI, and Excel

Experience with ETL design, development and support using SSIS

Exposure to the designing and building enterprise data and BI solutions with a some understanding of dimensional data marts/star schema data modeling and design

Very strong written and verbal communication skills.

 

Beneficial Skills and Experience

Experience with insurance or health care industries

Data Quality and Data Governance

Predictive Analytics

Experience with software source control tools, preferably Team Foundation Server (TFS)

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150