Data Engineer I

Responsibilities

• Assist in building and maintaining data pipelines and data management solutions using Snowflake, Coalesce, SQL, and Python
• Assist in managing and monitoring data pipelines and workflows using Airflow and other orchestration technologies
• Develop and support data transformation processes used to extract, transform, and load data between systems
• Assist with data integrations, conversions, imports, and exports involving Workday and other internal and external systems
• Assist in troubleshooting and resolving programming, pipeline, and production support issues while developing root-cause analysis skills
• Learn and use modern data preparation, integration, automation, cloud, and AI-enabled tools and techniques
• Assist in implementing processes that support data integrity, standardization, and quality
• Contribute to data reliability, efficiency, quality, and automation improvements
• Assist in maintaining data dictionaries, metadata, data mappings, technical specifications, test cases, and production support documentation
• Work closely with product teams, engineers, analysts, and business partners to understand data requirements and contribute to the development of technical solutions
• Participate in Agile Team activities and contribute to regularly producing product increments
• Perform other duties as assigned

Preferred

• Experience in an agile environment strongly preferred
• Relevant certification is preferred
• Experience in an Agile environment
• Experience or exposure to Snowflake, Coalesce, Workday, or Airflow
• Relevant technical certification

Benefits

• Health, Dental and Vision Insurance
• Generous 401(k) with company match
• Paid Time Off (PTO) with Paid Holidays
• Flexible/Hybrid Work Schedule
• Paid Volunteer Program
• Pekin Insurance provide peace of mind and long-term security for policyholders, shareholders, agents, and employees.
• Pekin, Illinois, USA
• http://www.pekininsurance.com
• Late Stage
• Leadership Team
• Ryan Hanson
• Chief Financial Officer
• Joel Jackson
• SVP & COO
• Recent News
• Business Wire
• AM Best Revises Outlooks to Stable for Members of Pekin Insurance Group and Pekin Life Insurance Company
• 2025-10-25
• Coverager - Insurance news and insights
• Pekin Insurance promotes Charlie Norder to VP of P&C Claims
• 2025-01-27
• Pekin Insurance Implements Guidewire Cloud for Expense Management and Improved Platform Support
• 2024-04-07
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter
• Make your application stand out
• Analyze How Well You Fit

Qualifications

• Bachelor's degree in IT Engineering, Computer Science, Business Management, Mathematics, Information Technology, Computer Engineering, or Information Sciences preferred, or equivalent experience
• Typically requires 0-2 years of experience in the desired field or may have entry level technical or business work experience, including internships
• SQL experience
• Python experience
• Ability to troubleshoot programming and technical issues
• Basic understanding of data engineering concepts
• Basic understanding of data integration, data quality, and data transformation
• Problem-solving skills
• Ability to collaborate with business and IT stakeholders
• Ability and willingness to learn new technologies
• ETL/ELT and data pipeline development
• REST APIs
• Agile methodologies
• DevOps concepts
• Data modeling
• Metadata management
• Learn and use advanced analytics tools for object-oriented/object function scripting
• Work across multiple deployment environments including cloud and on-premises, and multiple operating systems
• Work with popular data discovery, analytics, and business intelligence (BI) software tools for semantic-layer-based data discovery
• Collaborate with both business and IT stakeholders
• Use judgment to form conclusions that may challenge conventional wisdom
• Apply original thinking to produce new ideas and innovate
• Data management disciplines including data integration, modeling, optimization, and data quality, and/or other areas directly relevant to data engineering responsibilities and tasks
• Popular database programming languages for relational and non-relational databases
• Representational state transfer (RESTful) API design
• Agile methodologies and capable of applying DevOps principles to data pipelines to improve the communication, integration, reuse, and automation of data flows
• Applicants must be authorized to work in the U.S. without sponsorship now or in the future
• Experience in an agile environment strongly preferred
• Relevant certification is preferred
• Experience in an Agile environment
• Experience or exposure to Snowflake, Coalesce, Workday, or Airflow
• Relevant technical certification

Required skills

• Agile Methodologies, Airflow, Coalesce, Data Modeling, Data Pipeline Development, DevOps, ETL/ELT, Metadata Management, Python, REST APIs, SQL, Snowflake, Workday

Preferred skills

• Experience in an Agile environment, Experience in an agile environment strongly preferred, Relevant certification is preferred, Relevant technical certification

Experience

• Entry level