Data Engineer II

Amerisure Insurance • Full-time • Farmington Hills, Michigan, United States • $88.21k - $116.17k / year • 9h ago

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. With an A.M. Best “A” (Excellent) rating, Amerisure serves mid-sized commercial enterprises focused in construction, manufacturing and healthcare. Ranked as one of the top 100 Property & Casualty companies in the United States, we proudly manage nearly $1 Billion of Direct Written Premium and maintain $1.21 billion in surplus.

Amerisure is currently recruiting for a Data Engineer II that can do a 2-day hybrid approach onsite in our Farmington Hills office. The ideal candidate will possess the following skill set.

Summary Statement

The Data Engineer II will drive designing, building, and optimizing advanced data pipelines and models, ensuring their scalability and performance. This role includes managing and supporting complex production environments, identifying opportunities for system enhancements, and mentoring junior team members. The Data Engineer II will work with tools such as Databricks, AzureGit, and others, driving innovation and efficiency in a collaborative, Agile environment.

Essential Tasks/Major Duties

Create and maintain scalable, efficient, and high-performing data pipelines to meet business needs.
Analyze complex datasets to uncover data quality issues, patterns, and potential improvements.
Develop and maintain robust data models that align with business and technical requirements.
Implement monitoring, logging, and alerting systems to ensure pipeline reliability and identify performance bottlenecks.
Ensure the metadata repository is accurate and supports data governance and traceability efforts.
Manage the deployment and testing of pipeline updates and improvements using CI/CD practices.
Engage in Agile ceremonies, such as stand-ups, sprint planning, and retrospectives, to support iterative development.
Resolve operational issues for data pipelines and participate in an on-call rotation to maintain system reliability.

Knowledge, Skills & Abilities

Bachelor’s degree in computer science, Data Engineering, or a related field (or equivalent experience).
2 years of data engineering experience delivering high-quality solutions.
Proficiency with tools like Databricks, AzureGit, AWS, Jira, ER/Studio, and VS Code.
2 years in data pipeline development, modeling, and transformation.
3 years of SQL, at least one programming language (e.g., Python), and big data technologies (e.g., Spark, Hadoop).
1 year experience with cloud platforms (Azure, AWS), CI/CD processes, DevOps practices, and real-time data streaming.
Experience with data governance frameworks, metadata management, and pipeline automation.
Data querying, filtering, and joining using performant languages like SQL or Python.
Application of data quality concepts, including master and reference data for survivorship.
Data security principles, such as classification, roles, and privileges across data stacks.
Data ingestion and storage design, optimizing pipelines, file structures, and partitioning for performance and cost efficiency.
Data modeling, including creating data dictionaries and conceptual models.
Strong understanding of Agile and DevOps methodologies.
Ability to mentor junior colleagues, collaborate effectively in teams, and foster a positive work environment.
Skilled in capturing client needs and delivering value through Agile practices.
Strong analytical and problem-solving skills, with the ability to manage complex tasks independently.
Excellent communication skills to convey technical concepts to non-technical stakeholders.
Familiarity with insurance terminology and practices, applied to data organization and communication, preferred.
Experience supporting and troubleshooting platform systems and environments.

#LI-BR1

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. This package includes competitive base pay, performance-based incentive pay, comprehensive health and welfare benefits, a 401(k) savings plan with profit sharing, and generous paid time off programs. We also offer flexible work arrangements to promote work-life balance. Recognized as one of the Best and Brightest® Companies to Work For in the Nation and one of Business Insurance magazine’s Best Places to Work in Insurance, we provide a workplace that fosters excellence and professional growth. If you are looking for a collaborative and rewarding career, 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.