Business Intelligence Analyst

Company: Medix---
Location: Franklin
Posted on: May 13, 2022

Job Description:

Medix is seeking an AS400/ iSeries Developer for a client of ours in the Insurance industry in Franklin, TN.
This will be a contact to hire position.

Responsibilities:
-Work both independently and with team members to deliver high
quality data transformation and reporting solutions to business challenges
that delight our customers. Work must be accomplished efficiently while
adhering to internal processes and meeting the requirements agreed upon
with our business stakeholders. This includes the following:
-Designing/ creating reports with SSRS on data in our existing data
warehouse and other data sources
-Designing/creating reports with SSRS in new warehouse
-Modeling and managing changes in our current data warehouse
structure as well as data transformation (ETL with SQL and SSIS)
between transactional data sources and the data warehouse as well
-Facilitating/performing upgrades of current warehouse tools and
platforms as needed
-Maintain/ monitor existing SSIS jobs that transfer data between web
and AS400 platform as well as between both platforms and the data
warehouse
-Create/ test/ deploy new SSIS processes as needed for data
transformation between platforms

Must haves:
- Min 7 years relevant experience with increasing depth and breadth of
responsibilities/ assignments
- Associates degree, bachelor's preferred unless there is significant (> 10
years) relevant experience with increasing depth and breadth of
responsibilities/assignments
- Administrative, design, and usage of at least one structured reporting
tool such as Cognos, Business Objects, MicroStrategy, Microsoft
/PowerBI, etc.
- Reporting experience with SSRS, including report bursting with SSRS
enterprise edition.
- ETL experience with SSIS
- MS SQL experience with complex queries or significant experience in
writing complex standard SQL queries on other relational database
platforms.
- Dimensional data modeling for analytical processing
- Fast learner who can hit the ground running
- Can handle ambiguity and knows how to solidify the ambiguous
- Strong analytical and problem solving skills
- Process orientation with experience with full SDLC methodologies
- Excellent communication skills, both verbal and written
- Positive, can-do attitude with focus on both quality and efficient
delivery

Pluses:
- Experience with administration and development with Cognos and/or
MS SSRS
- Experience with Jira and agile development methodologies
- Experience with relational data modeling for transactional processing
- Experience with Insurance Industry

Keywords: Medix---, Franklin , Business Intelligence Analyst, Professions , Franklin, Tennessee