Associate Data Engineer
Amerisure is recruiting for an Associate Data Engineer, Advanced Analytics to join our team in our Farmington Hills, MI. This is a hybrid position working Tuesday’s and Wednesday’s, in the office, and remote the remainder of the week.
Position Summary:
Provides data management to support advanced analytics and related functions in the organization. This position will plan, analyze, design, develop, implement, and maintain data infrastructures that ensure the timeliness, availability, and integrity of data for department and company initiatives.
Responsibilities:
- Collaborate with cross-functional teams to understand data structures and requirements, including analytics team, actuarial, IT, and relevant stakeholders.
- Collect and cleanse data including extracting and combining data from multiple sources using languages such as SQL, SAS, and Python.
- Design data pipelines for efficient data extraction, transformation, and loading (ETL).
- Develop and maintain database schemas, tables, and queries to support analytics projects.
- Contribute to the development of data models that align with business needs and facilitate effective data analysis.
- Design improvements to existing data capture to assimilate new data elements as needed.
- Build use cases and execute test plans that encompass unit testing and analysis of results.
- Maintain and promote a high standard for data management industry best practices.
- Document new and existing systems, develop workflows, and create other supporting documents in adherence to all departmental and corporate standards.
Requirements:
- Bachelor’s degree in computer science, data analytics, or related field.
- Experience in data management or related field.
- Knowledge of insurance industry processes and data preferred.
- Strong understanding of databases, data warehousing, and ETL processes.
- Proficiency in SQL
- AWS Cloud experience preferred.
- Basic programming skills with Python.
- Intermediate proficiency with Microsoft Office Suite.
- Familiarity with agile methodologies.
- Ability to build positive partnerships and work collaboratively with cross-functional business teams.
- Excellent problem solving, critical thinking and decision-making skills.
- Excellent interpersonal and communication skills with the ability to interact with all levels of the organization.