Previous Job
Previous
IT Data Modeler
Ref No.: 17-08052
Location: Des Moines, Iowa
Work with Corporation Information Security (CIS) and Technology staff to implement automation services and data analytics techniques. Solid knowledge of data models, comfortable writing SQL queries and generating reports. Parsing raw text into a structured system for analysis. Develop and apply industry best practice technology, design and methodology approaches for physical data modeling to implement system solutions to support CIS processes. Implement code to establish permanent data feeds and ETL functions from various sources of data into a warehouse. Establish and maintain strong working relationships within CIS and Technology groups.

This position will help improve the data analytics and automation capabilities of CIS.

Required:
· Minimum four years database administration experience; four years of data modeling experience
· Minimum three years database security experience
· Demonstrated experience in programming and scripting languages to automate processes
· Systems administration experience, including knowledge of network technologies and protocols.
· Advanced experience troubleshooting database connectivity issues
· Ability to express complex technical concepts effectively, both verbally and in writing
· Ability to work well with people from many different disciplines with varying degrees of technical experience
Preferred:
· 4+ years of programing or scripting experience
· 4+ years of data warehouse experience
· Experience in developing and implementing machine learning algorithms
· Experience working in a cloud environment
· Prior security and/or risk experience
· R and/or Python experience
· Markdown experience
· Writing Excel Macros