EMC Insurance Companies · 13 hours ago
Data Engineer I
Des Moines, IA
Full-time
Hybrid
New Grad, Entry Level
$61K/yr - $84K/yrEMC Insurance Companies is focused on teamwork and making an impact, and they are seeking a Data Engineer I to contribute to their data analytics product pipeline. The role involves collaborating on the development, testing, and maintenance of ETL/ELT pipeline architecture, as well as ensuring data quality and reliability for business customers.
FinanceProperty & Casualty InsuranceFinancial ServicesInsurance
Responsibilities
Collaborates with the team to develop, test, and maintain prioritized engineering (design/build/test) work as a member of a data analytics product pipeline architecture and infrastructure team:
Pairs with senior team members to develop and maintain ETL/ELT pipeline architecture that cleans, transforms, and aggregates data from disparate sources using architecturally approved tools, programming languages, and services to deliver a data mesh approach
Assists in development and maintenance of automated ETL/ELT monitoring and alarming solutions using architecturally approved languages and services
Monitors, troubleshoots, and optimizes data pipelines for quality, performance, and reliability creating a single source of truth providing business customers with highly reliable and quality data
Collaborates with senior team members to build unit tests to enable test driven development and automation to drive code reliability Develops, maintains, tests, and deploys code with architecturally approved toolsets using Dev Ops practices, ETL/ELT pipelines, data catalogs and data queries
Maintains data solutions in a divest state to ensure business functionality until replaced with new technology
Helps business customers develop, troubleshoot, and optimize SQL and ETL/ELT solutions to solve reporting, metrics, and analytics problems
Data analysis: Collaborates with cross-functional teams to understand data requirements for data analytics products and translate them into scalable and efficient data solutions:
Participates in small projects and supports larger initiatives as part of a team
Partners with team to understand data needs and business requirements
Collaborates with team on conceptualizing and developing new data solutions to meet the business requirements
Researches, performs analysis and proposes effective solutions related to systems development and enhancements through collaboration with Data Architecture
Collaborates with team on potential adjustments or modifications for impacts on other programs
Utilizes understanding of data governance, data security, and privacy principles to support data lineage and reference data needs
Collaborates with cross-functional teams to understand business and downstream application (BI reporting, Data Science, Data Governance, other System integrations) and consumer requirements to deliver data-driven solutions that implement best practices for data management, security, and governance
Documentation
Participates in creating and maintaining documentation related to the design of applications and interfaces to enterprise and third-party systems in accordance with departmental and team standards
Collaborates with data governance on ensuring what is being produced in data analytics products enables data governance to publish a data asset
Collaborate with data governance to develop and maintain data analytic product artifacts and user documentation for business customers
Maintains systems documentation
Data Modeling
Partners with team members to develop data objects for data analytics products using data modeling techniques
Partners with team members to model front-end and back-end data sources to help draw a more comprehensive picture of user flows throughout the system and to enable powerful data analysis
Partners with team members to understand business needs and translate them into a conceptual data model, defining entities, attributes, and relationships
Collaborates with team members to build assigned detailed logical model based on the conceptual model, specifying data types, constraints, and keys to ensure data integrity
Partners with team members to implement logical models into appropriate database management system, considering database features, storage optimization, and performance considerations
Designs assigned data pipelines to extract data from source systems, transform as needed based on the data model, and load into the target database
Qualification
Required
Bachelor's degree, preferably in a computer related field or equivalent relevant experience
Basic knowledge of SQL and relational databases
Good analytical and problem-solving skills
Ability to manipulate, process and extract value from large, disconnected datasets
Good verbal and written communication skills
Strong attention to detail, organizational and multi-tasking skills, with the ability to adapt to changing priorities
Ability to maintain confidentiality
Preferred
Prior experience working with unstructured datasets
Knowledge of applicable programming languages such as Python
Knowledge of cloud services such as S3, RDS, SNS, CloudWatch and Lambda
Knowledge of DBT/Informatica or other ETL/ELT tools
Knowledge of data modeling
Knowledge of DevOps and/or DataOps practices, CI/CD pipelines, and containerization technologies
Company
EMC Insurance Companies
EMC Insurance is a top insurer based on net written premium, and we have more than 2,200 employees.
Founded in 1911
1001-5000 employees
Funding
Current Stage
Public CompanyTotal Funding
unknown1982-02-12IPO
Leadership Team
Matthew Spackman
SVP-Chief Human Resources Officer
P
Philip Lucca
Retired
Recent News
Corridor Business Journal
2025-06-28
2024-04-11
Company data provided by crunchbase