Associate Data Engineer, Advanced Analytics (Hybrid) at Amerisure Insurance Company in Farmington Hills, Michigan

Job Description:

Amerisure creates exceptional value for its partners, policyholders and employees. As a property and casualty insurance company, Amerisure’s promise to our partner agencies and policyholders begins with a comprehensive line of insurance products designed to protect businesses, as well as the health and safety of every employee. Amerisure is an A.M. Best “A” (excellent) rated company and services mid-sized commercial enterprises focused in construction, manufacturing and healthcare. We are ranked as one of the top 100 Property & Casualty companies in the United States, and have nearly $1 Billion of Direct Written Premium ​and $1.15 billion in surplus.

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.

#LI-CR1

Just as we are committed to creating exceptional value for our Partners For Success® agencies and policyholders, Amerisure also remains committed to being an employer of choice. We reinforce this commitment by adhering to an Employee Value Proposition that, in part, is provided through a competitive total rewards package. Amerisure offers a Compensation & Benefits Package that includes competitive base pay, performance-based incentive pay, comprehensive health & welfare benefits, 401(k) savings plan and profit sharing. In addition to generous paid time off programs, we allow our employees flexible and remote work arrangements.  If you strive for excellence and are committed to personal and professional growth, Amerisure is looking for you.

Amerisure Insurance provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Amerisure Insurance complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Amerisure Insurance expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Amerisure’s employees to perform their job duties may result in discipline up to and including discharge.