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
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
Experience with software source control tools, preferably Team Foundation Server (TFS)