Intermediate Data Engineer

Transamerica•Cedar Rapids, IA

2d•$77,000 - $95,000•Hybrid

About The Position

The Intermediate Data Engineer develops and supports the systems, services, and applications used to collect, store, process, and analyze data, enabling data-driven decisions and outcomes across the enterprise. The role works collaboratively with engineers, data scientists, analytics teams, and business product owners in an agile environment. The position builds and supports cloud and on-premises enterprise data infrastructure and tools; designs reusable, scalable data solutions and pipeline frameworks for structured and unstructured batch and real-time streaming data; and builds data APIs and delivery services for operational processes, analytics, and machine learning. The engineer also helps select and integrate data tools and applies enterprise data management practices covering master data, reference data, metadata, data quality, and lineage. This is a hybrid role requiring three days per week in the office, on Tuesdays, Wednesdays, and Thursdays, at a hub location in Cedar Rapids, Iowa, or Denver, Colorado. Occasional travel of less than 10% may be required. Relocation assistance is not provided.

Requirements

Bachelor’s degree in computer science, math, engineering, or a relevant technical field.
Two years of collective experience applying data engineering, data analytics, data warehousing, business intelligence, database administration, and data integration concepts and methodologies.
One year of experience developing and supporting modern data architectures.
One year of experience developing and supporting large-scale distributed applications.
One year of experience with Linux operations and development, including basic commands and shell scripting.
One year of experience executing DevOps methodologies and continuous integration/continuous delivery.
Knowledge of SQL for data profiling, analysis, and extraction.
Results-oriented with a strong customer focus.
Ability to work within a team environment.
Ability to prioritize and meet tight deadlines.
Ability to learn and keep pace with technology advances and quickly grasp new technologies to support the environment and contribute to project deliverables.
Authorization to work for any employer in the United States; the company is unable to sponsor or take over sponsorship of an employment visa.

Nice To Haves

Master’s degree in a technical field such as computer science, math, or engineering.
Two years of experience developing and integrating REST APIs with backend data processing workflows using AWS services.
Experience with the Snowflake cloud data platform, including data integration and ETL development.
Understanding of big data and real-time streaming analytics processing architectures and ecosystems.
Understanding of data warehousing architecture and implementation, including source-to-target mappings and ETL.
Experience with advanced analytics and machine learning concepts and technology implementations.
Experience with data analysis and data visualization tools.
Relevant technology or platform certification, such as AWS or Microsoft.
Software development experience in relevant programming languages such as Java, Python, Scala, or Node.js.

Responsibilities

Collaborate with engineers, data scientists, analytics teams, and business product owners in an agile environment.
Build and support cloud and on-premises enterprise data infrastructure and tools.
Design robust, reusable, and scalable data solutions and pipeline frameworks to automate ingestion, processing, and delivery of structured and unstructured batch and real-time streaming data.
Build data APIs and data delivery services supporting critical operational processes, analytical models, and machine learning applications.
Assist in selecting and integrating data-related tools, frameworks, and applications to expand platform capabilities.
Apply enterprise data management best practices, including master data, reference data, metadata, data quality, and lineage.

Benefits

Competitive pay
Annual bonus for eligible employees, based on the Company Bonus Plan and individual performance, at the company’s discretion
Pension plan
401(k) match
Employee stock purchase plan
Tuition reimbursement
Disability insurance
Medical insurance
Dental insurance
Vision insurance
Employee discounts
Career training and development opportunities
Paid time off starting at 160 hours annually for employees in their first year of service
Ten paid holidays per year
Be Well Company holistic wellness program, including wellness coaching and reward dollars
Paid parental leave of 15 days per calendar year for eligible employees with at least one year of service
Adoption assistance
Employee assistance program
Back-up care program
PTO for volunteer hours
Employee matching gifts program
Employee resource groups
Inclusion and diversity programs
Employee recognition program
Referral bonus programs