AccessQuint LLC

Company Details

Database Analyst With ETL

Job ID

: 21298

Location

: Des Moines, IA, USA

Salary

: Not Specified

Job Views

: 153

Posted

: 12-07-2018

Job Description

Location: Des Moines, Iowa

Duration: 6 Months

 

LOCALS ONLY

 

 

DHS is looking for a database analyst with MS ETL experience who will work within the Medical Systems and Enterprise Data Warehouse to help transform the Iowa Chip data into data structures that can be utilized by Medicaid systems. **In-Person Only**

The Bureau of Medical Systems & Enterprise Data Warehouse is seeking a motivated, analytic candidate to fulfill the Responsibility of converting the Iowa Chip data into data structures that can be utilized by Medicaid systems. This individual will analyze system data, based upon system requirements and identify missing or unaccounted for items. Essentially, data analysis, mapping, and documenting down to the data dictionary. 

\tExcellent interpersonal, verbal and written communication skills and the ability to interact with a diverse group of team members is required.

We are looking for someone with strong Microsoft ETL experience who will be doing data analysis/mapping/documenting; down to the data dictionary; for the first six months this person will be getting data (MF, SQL Server, text files) from the source systems into the data warehouse. One of the current programs are changing from an outsourced program to an in-house. In the long-term this resource will be doing ETL work; in the short-term, this person will help with the data analysis and data transfer from an outsourced system to an in-house system. This person is going to help map, so they re going to need to have good analysis skills for mapping data. 

\tWorking with SQL Server 
\tWorking with SQL Server Integration Services
\tMapping data flows 
\tNew database development 
\tWritten technical documentation and oral communication
\tStrong analytic, conceptual and problem-solving 
\tWorking on an Agile team

Previous experience with medical, premium or pre-enrollment data is helpful. 

Required/Desired Skills

 

Skill

Required /Desired

Amount

of Experience

Experience working with SQL Server 2012+

Required

5

Years

Experience working with SQL Server Integration Services

Required

5

Years

Strong written, technical documentation and oral communication skills

Required

5

Years

Strong analytical, conceptual and problem-solving abilities

Required

5

Years

Experience working on an Agile team

Required

3

Years

Advanced Search