Sr. Data Engineer - Hybrid - Des Moines, IA

Bachelor's degree plus 6+ years related work experience or a Master's in related field. Proven experience as an IT professional. Basic leadership and presentation skills required. Knowledge of financial services products and processes preferred. Ability to work directly with data and datastores through programming language such as SQL, Python, Java, etc. Experience with a variety of data modeling techniques and data structures. Ability to optimize data for analytics and data science. Experience building/operating systems for data extraction, ingestion and processing of large data sets. Knowledge and direct experience using business intelligence reporting tools. Experience building data products incrementally and integrating and managing datasets from multiple sources. Excellent planning, organizational, problem-solving, analytical, decision-making and communication skills required. Excellent time management skills preferred. Ability to collaborate with others required. Must be able to effectively communicate strategies and designs to all levels of the company. Must be able to maintain a high degree of accuracy and confidentiality. May be required to provide on-call support.

Responsibilities:

Conduct data engineering and analysis expertise to meet business requirements and maximize effectiveness. Oversee technical aspects of data management functions including creating, loading, transforming, cleansing, processing, analyzing, and visualizing data. Works directly or in support of data science/analytics to design, develop, test and integrate data from various sources into large-scale processing systems and databases to use in providing insights that solve business needs. Demonstrate independence working in more than one software development layer of the solution.

1. Why is this position open? How is it impacting the business? We are participating in a special pop-up effort shifting one of our resources to support that need, this contractor will help backfill the need.

2. Please describe the project work, and what do day-to-day responsibilities look like: They will be working closely with our product manager and analytics consultant to help develop solutions to be implemented in our D&A space. The work involved will be taking source data, doing the necessary ETL (extract, transform, load) to help build curated data products for our analysts to use in their insights. There will be both independent as well as pairing opportunities based on feature size and existing skillsets. Often times we are also consulting with our analysts as they also explore AWS services. They will do most work in python, AWS and Snowflake.

3. What technologies or systems will this contingent worker be utilizing? Python, AWS, Snowflake, SQL, GitHub, may have some legacy needs with Informatica but that is not a core technology we leverage.

1. If a candidate does not have all the technologies listed, would there be technologies you would consider similar and/or transferable for this position?

4. (For IT roles as applicable) Please provide background information on the application(s) this worker will be involved with:

5. What skills are you looking for in the ideal candidate?

(Please feel free to add more bullet points!)

1. Preferred

i. 1. Python

ii. 2. GitHub

iii. 3. AWS

1. Nice to Have

i. 1. Data extraction through API experience

ii. 2. Snowflake experience

iii. 3. Erwin, data modeling