apache-airflow

Data Engineer

DENVER, CO OR REMOTEENGINEERINGFULL-TIME PIE-ONEER We are an insurtech company where smart people can see the impact of their work as we tackle meaningful problems together. We think it’s fun to disrupt an industry that has been slow to change. But we aren’t shaking things up for the sake of change, we’re here to solve big problems using technology and an innovative approach to improve how small business owners access insurance. Like our small business clients, we are a diverse team of builders, dreamers, and entrepreneurs, so at the heart of every decision we make is the idea that if it doesn’t serve our clients, it doesn’t serve us. We hire passionate people who like to work hard, yet we also know that life exists outside the office. Small businesses are the backbone of the economy; talented team members are the backbone of Pie. We are pie-oneering a whole new approach to insurance. As a Data Engineer at Pie Insurance, you’ll be a member of the team responsible for transforming the commercial insurance market by delivering best-in-class data architecture solutions and driving more accurate data-driven decision making. Our team is looking for an experienced data engineer. We expect you’ll have spent at least 3 years in the data warehouse and/or data analytics space. Of course, you’ll also need certain skills and abilities to do the work. Today, all Pie-oneers are working remotely and will continue to do so until it is safe to return to the office. As a remote team member, you will be expected to be available for meetings with team members in other time zones and have access to reliable, high-speed internet. This role will work in our Denver office once our office re-opens. We will consider this role for continued remote work within the United States once our offices reopen with some travel. How You'll Do It As a data engineer with Pie, you will work with our data architect to Pie-oneer our data environment. This individual will be a key member that will work directly with our data architect to define the future state of our data architecture. This role will work in data architecture, data analytics, ETL development, and data reporting. Success in this position will be establishing how data comes into and flows through the Pie insurance platform. This data will be used to help our organization quote customers based on data on best policy and prices for their workers compensation insurance.

The Right Stuff

• 3-5 years working in data as an engineer. Building data solutions for a company who uses data as a primary part of their business.
• Experience in data warehouse and/or data analytics. Qualified candidates may also come from a strong database skill-set involved in analytics architecture.
• Strong experience in writing complex SQL queries.
• Strong experience in ETL/ELT platforms is strongly preferred.
• Exposure to one major SQL RDBMS or analytics database. (Snowflake, Redshift, MySQL, Postgres, Oracle, SQL Server, etc.)
• Big Data and Business Intelligence exposure would help in the success of this role.

Our goal is to make all aspects of working with us as easy as Pie! That includes our offer process. When we have identified talent that is a good fit for Pie, we work hard to present an equitable and fair offer. We look at your knowledge, skills and experience that you bring, along with your compensation expectations and align that with our company equity processes to determine our offer ranges. We value and want to support our team members, and are proud to offer a comprehensive compensation package which includes the following: Compensation Range for position: $113,000 - $145,000 Other Benefits: Each year Pie reviews Company performance and may grant discretionary bonuses to eligible team members. Pie Insurance is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristic. Pie Insurance participates in the E-Verify program. Please click here , here and here for more information. Our Achievements Pie Insurance raises an additional $118M in funding Pie Insurance Named a Top Colorado Company 2020 Pie is rated Excellent by our customers on Trustpilot Check out our great reviews from current and former employees on Glassdoor Pie raises an additional $127M in funding