Senior Data Engineer (Project Management)

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 Senior Data Engineer that can do a 2-day hybrid approach onsite in our Farmington Hills office. This role requires experience with mentoring junior developers along with bringing solutions for optimization of systems. The ideal candidate will also possess the following skill set. 

Summary Statement

The Senior Data Engineer is responsible for leading the development, optimization, and scaling of data pipelines and systems. This role requires expertise in designing advanced data solutions, ensuring the stability and reliability of production environments, and implementing best practices across the data engineering team. This position also involves mentoring team members and contributing to the success of projects within a structured, Agile environment.

Essential Tasks/Major Duties

• Architect, implement, and optimize complex, scalable data pipelines to support analytics, machine learning, and operational needs.
• Lead efforts to profile large, diverse datasets, identify patterns, and improve data quality and performance.
• Develop high-performance physical data models, ensuring efficiency, scalability, and alignment with business goals.
• Establish advanced monitoring, logging, and alerting frameworks to ensure robust pipeline observability and proactive issue resolution.
• Ensure metadata is accurate, up-to-date, and supports compliance, traceability, and governance requirements.
• Design, implement, and optimize CI/CD pipelines for seamless deployment and updates across environments.
• Actively participate in and contribute to Agile ceremonies, driving iterative development and collaboration across teams.
• Lead efforts to troubleshoot, resolve, and prevent operational issues in production environments, including participation in an on-call rotation and incident root-cause analysis.
• Mentoring colleagues, sharing best practices, conducting code reviews, and fostering a culture of excellence.

Knowledge, Skills & Abilities

• Bachelor's degree in Computer Science, Data Engineering, or a related field.
• Data certifications (e.g., Databricks, AWS Certified Data Analytics) preferred.
• 5 + years of professional experience in data engineering or a related role, with demonstrated success in delivering large-scale data solutions.
• Expertise in tools such as Databricks, AzureGit, AWS, Jira, ER/Studio, and VS Code.
• 5 years of experience with SQL and Python.
• 3 years experience with cloud platforms (e.g., Azure, AWS) and modern data engineering tools and frameworks.
• Proven track record of building and optimizing data pipelines and data models for scalability and performance.
• Experience establishing CI/CD processes and automated pipelines with DevOps principles.
• Exceptional problem-solving skills, with a strategic mindset and attention to detail.
• Excellent communication and leadership skills, with the ability to influence stakeholders and drive consensus.
• Proven ability to manage and prioritize multiple projects in a dynamic environment.
• Knowledge of insurance terminology and practices with the ability to apply that knowledge in communication and data organization, preferred.

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.