Data Engineer

Homesite Insurance was founded in 1997 and was one of the first companies to enable customers to purchase home insurance directly online, during a single visit. Since then, we've continued to innovate rapidly to meet the needs of our customers and their changing expectations.

One thing that's stayed the same since our founding: our commitment to our customers, partners and employees.

Join us on our journey as we continue to grow into a powerful contender in the field of insurance.

Compensation may vary based on the job level and your geographic work location.

Compensation Minimum:$74,500

Compensation Maximum:$124,000

We seek an independent contributor to streamline the access to data by developing new automated data structures that empower non-engineers to rapidly leverage the wealth of Homesite data. The data consolidation and simplification will include leveraging API to access data, cross system communication, data governance and resilient automation.

Responsibilities

• Lead efforts to design, develop and implement databases enhancement to improve efficiency and streamline the use for analytics, business analysis and data governance.
• Develop a mastery of the corporate data structure to be able to perform ETL operations from data tables existing in the company.
• Test, design, and implement process automation techniques to support efficiencies.
• Clearly communicate complex findings to colleagues influencing outcomes and communicating the value add of the data engineering work being completed.
• Foster relationships with colleagues to identify and explore new sources of data.

Knowledge, Skills and Competencies

• A mastery of best practices in coding, code organization, data transformation, ETL, process automation, and APIs.
• Expertise in relational databases (such as MS SQL Server, MySQL and Aurora) concepts.
• Ability to comprehensively understand data sources, elements and relationships in both business and technical terms.
• Expertise with Microsoft SQL Server (including SSIS, SSRS) including 2-5 years of experience.
• Knowledge of one version control system, preferably Git is required.
• Bachelor’s degree in Computer Science, Computer Engineering, Information Technology/Systems, related field, or equivalent experience.
• Motivated individual with strong analytic, problem solving, and troubleshooting skills.

Other Job Experiences Desired

• Insurance industry experience a plus, but not required.
• Experience with cloud computing APIs (Amazon Web Services preferred).
• Experience with cloud computing services (Amazon Web Services like Lambda, S3, CloudWatch, ECS, and RDS preferred)

When you work at Homesite you can expect benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, and a paid-time off program. In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns at Homesite are eligible for the paid time off program. Contingent workers are not eligible for American Family Enterprise benefits.

Stay connected: Join Our Enterprise Talent Community !