Data Engineer - Mid

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

The Position 

Have you ever wondered how insurance companies calculate the price of insurance policies? 

The Actuarial Operations is a dynamic, growing team at Arch. This team implements innovative insurance pricing models and analytical tools to improve profitability and growth across a wide range of Property & Casualty insurance products. 

The Data Engineer will implement complex databases and data pipelines that put analytics at the heart of real-time decision-making. They will work closely with leaders across the company on high-profile analytics projects that drive business strategies. They provide technical guidance and ensure the use of sound engineering practices and effective use of resources.  As a key member of the Actuarial Operations team, they will advance our implementation capabilities and help our team deliver solutions faster. 

Job Responsibilities 

• Work with strategic partners to solve business problems by developing best-in-class data solutions 

• Perform data manipulation using SQL and Python to develop data assets

• Leverage technology to automate data ingestion, transformation and integration

• Provide the appropriate level of documentation of sources and technical solutions

• Evaluate data quality and completeness

• Build strong partnerships with peers across the organization to support data-related goals 

• Explore new technologies and data sources with curiosity and creativity

• Identify, design, and implement internal process improvements: automating manual processes and optimizing data pipelines

• Discover and explore new sources of data with curiosity and creativity

• Create and maintain optimal data pipeline architecture

Required Skills/Experience 

• SQL, Python, Python, Git, Microsoft Excel, Data Modeling (Dimensional modeling)

• The ideal candidate has 1-2+ years of data/software engineering experience working with SQL, Python, and relational databases.

• Understanding and experience with dimensional data modeling (star schema)

• Familiarity with the MLOps framework 

• Strong data manipulation skills for analytics 

• Familiarity designing and operating data pipelines using Apache Airflow or equivalent orchestration tools

• Excellent critical thinking skills to tackle complex data challenges

• Strong organizational skills and very detail oriented

• Exceptional collaboration and relationship building skills

• Comfortable working in a fast paced, highly collaborative environment

• Ability to effectively communicate to different target audiences

• Resilient problem solving and critical thinking skills 

• Flexibility - able to meet changing requirements and priorities

Education

• BS in Computer Science, Information Technology degree, Data Analytics, Management Information Systems or equivalent

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.