Analytics Engineer

About the position

Counterpart is a modern management & professional liability insurance platform for the 21st century workplace. We offer products and services to help companies align the risks and incentives of creating great organizations. Our platform is designed to measure risk more efficiently using the most advanced rating system in the industry, while also proactively mitigating the risks of our insureds. Ultimately, we provide businesses with the framework to be the best versions of themselves. That’s where you come in. As an Analytics Engineer, you will be a prolific individual contributor to our pipelines, tables, and data models that enable analytics and reporting to the rest of the organization. You will help bridge the gap between Data Engineering, the broader Data & Analytics team, and the rest of the business by leveraging both your technical expertise and understanding of business goals.

Responsibilities

• Building and managing reporting data models and infrastructure in Snowflake and related ETL / data engineering tools
• Building basic reports for all major stakeholders (underwriting, data entry/operations, claims) in Looker
• Training team members on how to leverage and/ update data models as necessary
• Building automation related to reporting, such as monthly bordereaux (monthly reports sent to carriers)
• Supporting the integration and production of new data sources in a manner that minimizes development cycles while maximizing potential business applications
• Building and maintaining relevant documentation and data dictionaries for the organization to ensure scalable knowledge

Requirements

• Bachelor/Master in a quantitative discipline (computer science, actuarial science, mathematics, statistics, economics, physics, engineering, or related field)
• Experience with a modern (JSON-heavy) data warehouse and version control (e.g. Git)
• Experience building and maintaining scalable data models, including relevant documentation and training
• Experience with various business intelligence tools (Looker, Tableau, PowerBI)
• Excellent communication skills and ability to translate messages depending on the stakeholder
• Python + SQL need to have some projects using both
• Attention to detail and curiosity related to data
• Strong theoretical knowledge but pragmatic focus on action

Benefits

• Unlimited Vacation: We offer flexible time off, allowing you to take time when you need it.
• Work from Anywhere: Counterpart is a fully distributed company, meaning there is no office. We allow employees to work from wherever they do their best work, and invite the team to meet in person a couple times per year.
• Stock Options
• Health, Dental, and Vision Coverage
• 401(k) Retirement Plan
• Parental Leave
• Home Office Allowance: to set up your home office with the necessary equipment and accessories.
• Book stipend
• Professional Development Reimbursement
• No working birthdays: Take your birthday off, giving you the opportunity to relax, enjoy your special day, and spend time with loved ones.
• Charitable Contribution Matching