Data Engineer I

American Equity-posted 12 months ago

Full-time • Entry Level

West Des Moines, IA

501-1,000 employees

Insurance Carriers and Related Activities

Resume

Match Score

Upload and Match ResumeTrack Jobs with Teal

The Data Engineer I designs, develops, tests, implements, troubleshoots, optimizes and maintains enterprise level data pipelines that implement complex processes, which reference a targeted centralized data warehouse and source systems. The incumbent analyzes data transformation requirements leveraged to build, refine, deploy and/or configure data pipeline architecture patterns that maximize reuse and minimize change impact. The data engineer I utilizes SQL, tools, and/or technology to implement robust, maintainable solutions that meet business and technical requirements.

Obtains knowledge around the Amazon Web Service (AWS) tooling, mapping design, architectural design, coding, implementation, performance tuning and debugging.
Develops data extracts, applications and ad-hoc queries using tools/languages deemed necessary.
Obtains a strong understanding of data pipeline design principles required in building an enterprise data warehouse environment and/or app-to-app pipelining.
Creates SQL queries required to access tabular structures in a Relational Database Management Systems (RDBMS).
Transforms functional specifications into data pipeline technical specifications and source to target mappings.
Communicates effectively with Business Analysts, Data Modelers and Solution Architects to convert the pipeline design into specific development activities.
Documents data pipeline processes thoroughly, including steps needed to migrate pipeline and/or database objects between various environments including Development, UAT, and Production.
Performs unit and integration testing activities and assists in user acceptance testing as needed.
Works with a mentor to further knowledge of data management and pipelining principles.
Performs other related work as assigned.

Bachelor's degree in Computer Science, MIS, Mathematics, Information Management, or related field of study; or equivalent combination of education and/or experience.
General knowledge of ETL and data movement.
Knowledge of basic data transformations and how to implement them in a hybrid cloud environment.
Basic understanding of SQL Scripting and/or another programming language.
Base knowledge of RDBMS and data warehouse tools including SQL Server and Snowflake.
Strong analytical and problem-solving skills.
Ability to work with various data frameworks.
Strong customer service orientation.
Effective verbal and written communication skills.
Mathematical skills and strong attention to detail.
Ability to work cooperatively and successfully with employees, customers, and other outside third parties.
Strong organizational and planning skills.
Ability to write reports, business correspondence, and procedure manuals.
Ability to effectively present information and respond to questions.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
Ability to successfully handle pressure and meet deadlines in a fast-paced work environment.

Track Jobs with Teal

Job Search Resources

•

AI Resume Builder

•

Data Engineer Resume Examples

•

Data Engineer Cover Letter Examples

Data Engineer I

Job Search Resources

Tools

Career Hubs

Guides

Company