Data Engineer I

EMC Insurance; Remote; USD 60,000 - 85,000; Full time

Job summary

A leading insurance firm is seeking a Data Engineer I for a remote position based in Des Moines, Iowa. The successful candidate will focus on developing and maintaining ETL/ELT pipelines, collaborating with cross-functional teams to ensure data quality, and optimizing data solutions. A Bachelor’s degree in a computer-related field is preferred, along with skills in SQL, Python, and cloud services. The role offers a competitive salary range of $60,813 - $84,038 or $67,200 - $92,395 depending on experience and location.

Benefits

401(k) plan match

Pension plan

Competitive paid time off

Tuition reimbursement

Qualifications

• Prior experience with unstructured datasets preferred.
• Good analytical and problem-solving skills.
• Ability to manipulate large datasets.

Responsibilities

• Develop and maintain ETL/ELT pipeline architecture.
• Monitor and optimize data pipelines for quality.
• Collaborate on developing new data solutions.

Skills

SQL

Python

ETL/ELT tools

Data modeling

Cloud services

Education

Bachelor’s degree in computer-related field

Tools

S3

RDS

DBT

Informatica

Job description

Data Engineer I page is loaded## Data Engineer Iremote type: Remotelocations: Des Moines- Corporate Officetime type: Full timeposted on: Posted Yesterdayjob requisition id: R6283**At EMC, we’re all about working together to make an impact. As part of our team, you’ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts—always supporting each other to do our best work. Join us, and let’s improve lives together.****\*\*This role can be performed remotely in the Des Moines, Iowa metro area with the ability to work on-site as needed\*\*****Essential Functions:**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 problemsData 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 governanceDocumentation:* 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 documentationData 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**Education & Experience:*** Bachelor’s degree, preferably in a computer related field or equivalent relevant experience* Prior experience working with unstructured datasets preferred**Knowledge, Skills & Abilities:*** Basic knowledge of SQL and relational databases* Knowledge of applicable programming languages such as Python preferred* Knowledge of cloud services such as S3, RDS, SNS, CloudWatch and Lambda preferred* Knowledge of DBT/Informatica or other ETL/ELT tools preferred* Knowledge of data modeling preferred* Good analytical and problem-solving skills* Ability to manipulate, process and extract value from large, disconnected datasets* Knowledge of DevOps and/or DataOps practices, CI/CD pipelines, and containerization technologies preferred* 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**The hiring salary range for this position will vary based on geographic location, falling within either of the following:**$60,813 - $84,038 or $67,200 - $92,395**A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, including relevant education, skills, and experience of an applicant, geographic location, and business needs.****For information relating to the benefits EMC Team Members receive as part of a comprehensive rewards package, please visit** **.***Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.****All of our locations are tobacco free including in company vehicles.***EMC complies with labor law requirements. View the .California Residents - California Consumer Privacy Notice:* (EMCC) –* (EMCNL) -* More than 105 years of financial strength and stability* Named a five-star insurance carrier by *Insurance Business America** Two-time recipient of the Best Practices Award of Excellence from the Independent Agents & Brokers of America* Multiple locations recognized as Top Workplaces based solely on team member feedback* Corporate culture that engages and empowers team members to achieve their best* Outstanding benefits with life, medical, dental, vision and prescription drug coverage* Competitive paid time off plan and a full day of volunteer time off annually* Financial incentives, including a 401(k) plan match, pension plan, OneEMC bonus plan and recognition and anniversary awards* Professional development and growth opportunities, including tuition reimbursement* Wellness initiatives to improve team member well-being and reduce health insurance costs* Flexibility to dress for your day and opportunities for alternative work arrangements