[Remote] Data Engineer I (Remote)

Note: The job is a remote job and is open to candidates in USA. MEM Insurance is seeking a Data Engineer to join their dynamic team, where you will design and optimize data pipelines, integrate systems, and ensure data quality to support analytics and software delivery. Your work will directly impact how the company delivers insights and solutions to its customers and internal teams.ResponsibilitiesWork with the data engineering team to design, build, and optimize scalable data pipelines that extract, transform, and load (ETL) data from various sources into the company’s data infrastructure, ensuring data is accurate, accessible, and ready for downstream processes. This includes working with both batch and real-time (streaming) data flowsWith guidance from senior members of the Data Engineering team, periodically assess existing data workflows, pipelines, and infrastructure to identify bottlenecks, inefficiencies, or areas where performance can be improved. This may involve tuning queries, optimizing ETL processes, refactoring code, or implementing new tools and technologies to enhance overall data performanceParticipate in an on-call rotation to monitor, troubleshoot, and resolve issues related to overnight data processing jobs. This includes ensuring nightly ETL processes, batch jobs, and other critical data workflows are running smoothly and addressing any failures or delays in a timely manner to minimize business disruptionImplement APIs and other integration tools to support data ingestion from multiple systems, enabling seamless data movement across platforms, applications, and third-party servicesWork closely with other Data Engineers, software engineers, and product development teams to ensure the necessary data pipelines, APIs, and databases are available and integrated into the company’s applications and products. Provide guidance and troubleshooting assistance related to data needs during the software development lifecycle, including testing and deployment stagesCollaborate with cross-functional and delivery team members, including analysts, data scientists, and business units, to create well-structured, accurate, and efficient data sets that meet reporting, dashboarding, and analytical needs. Ensure the data sets are tailored for ease of use and optimized for performance in reporting toolsEnsure data integrity by designing and enforcing rigorous quality control measures at the point of data entry. This includes implementing validation checks, error handling, and monitoring solutions to detect and prevent data anomalies, ensuring that only accurate and complete data is ingested into the systemsContribute to a culture of continuous learning and improvement by engaging in regular code reviews and peer feedback sessions. Review the work of team members to ensure adherence to best practices, coding standards, and data governance principles, while also offering constructive feedback to help improve the overall quality of the team’s outputsSkillsDegree in Computer Science or related fieldValid driver's license required1+ years in data or software engineering rolesHands-on experience with CI/CD tools, cloud platforms, and data warehouses/lakesFamiliarity with ETL processes and API developmentPreferred certifications in cloud technologies (Azure, AWS) or data engineeringInsurance industry experience preferredBenefitsHealth Plans: Medical, Dental, and VisionFertility benefits and fully paid preventative careAdult orthodontia and comprehensive dental coverageFully Employer-Paid Life and Disability Benefits:Life Insurance (3x base salary)Accidental Death and DismembermentShort and Long-term DisabilityWellness and Recognition:Employer-paid incentives for employees and spousesFinancial Benefits:Flexible Spending Account and Dependent Care optionsHealth Savings Account with generous employer contribution401k Retirement Plan with employer match and profit sharingTime Away from Work:Generous PTO accruals11 Holidays and 4 Early releases16 Hours of Volunteer Time Off20 days of paid parental leaveMarriage, Bereavement, and Jury Duty leaveAdditional Benefits:Employee Assistance ProgramsAdoption AssistanceTuition AssistanceCompany OverviewMEM (formerly Missouri Employers Mutual and Previsor) is your Midwest regional workers compensation insurance partner. It was founded in 1995, and is headquartered in Columbia, Missouri, USA, with a workforce of 201-500 employees. Its website is https://www.mem-ins.com/.



Apply Now