HomeJob Details
Return To Job List

Database Administrator


Location: Des Moines, Iowa
Job Category:

Seeking an ETL Developer with extensive experience with SQL and SSIS. The ideal candidate will have the ability to troubleshoot and problem-solve with a strong sense of urgency. This person should be a self-starter, able to work both independently and cooperatively as required. The successful developer must be able to understand business requirements, data and concepts. State government experience is a definite plus.

Responsibilities
Refine business requirements into technical requirements and specifications
Design and develop SSIS packages, database objects, tables, stored procedures and views
Performance tuning the stored procedures and T-SQL.
Communicate accurate and useful status updates
Manage and report time spent on all work activities
Data extraction from WSI SQL tables
Mapping of worksheets to import table supplied by BasicGov
Validated imported data
Build cross-reference SQL table to equate WSI data to new SQL data
Execute this process multiple times to verify all pertinent data is exported and imported
Support go-live
Analyze and digest business and technical requirements as provided by multiple sources
Analyze and develop mapping and translations between the data elements in client, carrier and payroll systems, interfacing with the Benefitsolver platform
Manage towards test plans with clients and carriers, testing the data exchange process end-to-end
Build import files from various data sources and execute the data import process end-to-end
Develop XML configuration files from Businessolver to carrier and payroll systems; coordinate and test ETL processes or EDI feeds with external vendors
Manage towards project plans and timelines based on assigned priorities
Communicate with all internal and external partners in a pleasant, professional manner and with an attitude that promotes Business partner’s goals and core objectives
Be a self-starter who has the ability to prioritize and execute.
Critical thinking skills and ability to solve problems; detail-oriented with a high degree of accuracy and follow through
Expertise with Excel; experience with Access, XML, JavaScript, ETL and text files a significant plus
 

Return To Job List

Apply For This Position - Database Administrator

*First Name:
*Last Name:
*Email:
Address:
City:
State:
Zip:
*Phone:
Cover Letter:
*Resume:
 
Please enter characters below and submit:



Return To Job List