Senior Data Engineer
United States
Applications have closed
Pie Insurance
Pie Insurance provides workers compensation insurance exclusively to small businesses, making buying workers' comp as easy as pie.As a Senior Data Engineer with Pie, you will be a key member that will work directly with our data architect team to define the future state of our data architecture. This role will work in data architecture, analytics engineering and reporting, and platform and ETL development.
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 best policy and prices for their workers compensation insurance.
How You’ll Do It
- Develop complex and efficient data pipelines to transform raw data sources into powerful, reliable components of our data models
- Design, build and maintain data pipelines ensuring data quality, efficient processing, and timely delivery of accurate and trusted data
- Work closely with the analytics engineering team to grow Pie’s analytics capabilities with faster, more reliable data pipelines, and better tools
- Collaborate with the data architecture team to design data models for optimal storage and retrieval, to meet critical business requirements
- Work with stakeholders including the Executive, Product, and Engineering teams to assist with data-related technical issues and support their data infrastructure needs
- Maintain high standards of engineering excellence through code reviews, unit tests, and robust alerting
- Mentor and provide technical excellence for other members of the data team
- Drive cross-team initiatives showing leadership and influencing others to achieve a common goal
- Work with our analytics engineers, analysts and scientists to ensure we have optimal, documented and adequately tested dimensional data models
- Drive best practices for data governance, privacy and security
- Take an active part in the operational responsibilities for running our data infrastructure while improving the cost efficiency, monitoring and observability of our data stack
The Right Stuff
- Minimum 5 years experience as a software engineer or data engineer with focus on data systems
- Demonstrable experience designing and implementing modern data warehouse/data lake solutions with an understanding of best practices
- Previous work experience in a cloud-based environment (AWS preferred)
- Advanced proficiency in writing complex SQL statements and manipulating large structured and semi-structured datasets.
- Proficiency in Python or other programmatic languages is preferred
- Strong demonstrated knowledge with industry standard ETL/ELT and data orchestration tools such as Airflow, Stitch, or Fivetran
- Experience modeling data in a data warehouses such as Snowflake, Redshift, and or BigQuery
- Experience with Airflow or another type of DAG scheduler
- Working knowledge of visualization tools such as Looker or Tableau
- Hands-on experience working with technologies in Pie’s tech stack: AWS, Airflow, Snowflake, Looker, and Monte Carlo
- Working knowledge of Data Observability Platforms such as Monte Carlo or Atlan is a bonus
Compensation Range for position: $150,000 - $205,000
Compensation & Benefits
- Competitive cash compensation
- A piece of the pie (in the form of equity)
- Comprehensive health plans
- Generous PTO, including paid sick leave
- Future focused 401k match
- Generous parental and caregiver leave
- Our core values are more than just a poster on the wall; they’re tangibly reflected in our work
Our goal is to make all aspects of working with us as easy as pie. That includes our offer process. When we’ve identified a talented individual who we’d like to be a Pie-oneer , we work hard to present an equitable and fair offer. We look at the candidate’s knowledge, skills, and experience, along with their compensation expectations and align that with our company equity processes to determine our offer ranges.
Each year Pie reviews company performance and may grant discretionary bonuses to eligible team members.
Location Information
Unless otherwise specified, this role has the option to be hybrid or remote. Hybrid work locations provide team members with the flexibility of working partially from our Denver or DC office and from home. Remote team members must live and work in the United States* (*territories excluded), and have access to reliable, high-speed internet.
Additional Information
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.
Pie Insurance is committed to protecting your personal data. Please review our Privacy Policy.
Pie Insurance Announces $315 Million Series D Round of Funding
Built In Colorado honors Pie in its 2022 Best Places to Work Awards
Pie Insurance Named a Leading Place to Work in Colorado Check out our great reviews from current and former employees on Glassdoor #LI-REMOTE #BI-REMOTETags: Airflow Architecture AWS BigQuery Data governance Data pipelines Data quality Data warehouse ELT Engineering ETL FiveTran Looker Monte Carlo Pipelines Privacy Python Redshift Security Snowflake SQL Tableau
Perks/benefits: 401(k) matching Career development Competitive pay Equity Health care Insurance Parental leave Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Data Scientist II jobs
- Open Product Data Analyst jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Business Data Analyst jobs
- Open Big Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Principal Data Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open GCP-related jobs
- Open Data management-related jobs
- Open Java-related jobs
- Open Privacy-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open TensorFlow-related jobs
- Open PhD-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open LLMs-related jobs
- Open Airflow-related jobs
- Open Hadoop-related jobs
- Open Data warehouse-related jobs
- Open Databricks-related jobs