Analytics Engineer

**JOB DESCRIPTION ** **Analytics Engineer ** 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. **YOUR SPECIFIC TASKS INCLUDE: ** * 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 **WE LOOK FOR TEAMMATES WHO HAVE: ** * 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 **WHO YOU WILL WORK WITH: ** * **Stanley Wang, Director, Pricing Analytics:** Before joining Counterpart, Stanley worked as an actuary within the pricing solutions and methods team at USAA to combine actuarial pricing with data science models. Before that, he was a leading data scientist for Digital Partners, a Munich Re Company where he specialized in building data science models and insights for leading insurtech companies. He has had many other relevant roles such as capital modeling, risk management etc. He lives in New York with his growing family. * **Tobias Schuler, Head of Data & Analytics Advisor:** Tobias was previously the Head of Data and Analytics at Digital Partners, a Munich Re company. Tobias led a team that built out data integrations, business intelligence and advanced analytics across all insurtech partners spanning various P&C lines of businesses. Tobias is also a FCAS and has built systems to enable leading class insights for underwriting, actuarial, claims and finance experts while focusing on democratizing data. He enjoys traveling internationally and spending time with his 2 young daughters. * **Chris Shafer, Special Projects** : Chris is a published scientific author, having studied the neural correlates of gratitude at the lauded Brain and Creativity Institute. He has since helped to launch numerous businesses in which he held a variety of critical roles from product management to business operations to strategic partnerships. Chris received his bachelor's degree in Biological Sciences from the University of Southern California. * **Elizabeth Barsalou, Data Scientist:** Before joining Counterpart, Elizabeth worked as a full stack data scientist in small business lending for Kabbage and BHG. She specialized in building data science models, infrastructure and strategies to extend credit to small businesses. She lives in San Francisco and spends her free time singing opera and playing with her dogs. **WHAT WE OFFER ** * **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 ** **COUNTERPART'S VALUES ** * **Conjoin Expectations** \- it is the cornerstone of autonomy. Ensure you are aware of what is expected of you and clearly articulate what you expect of others. * **Speak Boldly & Honestly** \- the only failure is not learning from mistakes. Don't cheat yourself and your colleagues of the feedback needed when expectations aren't being met. * **Be Entrepreneurial** \- control your own destiny. Embrace action over perfection while navigating any obstacles that stand in the way of your ultimate goal. * **Practice Omotenashi** ("selfless hospitality") - trust will follow. Consider every interaction with internal and external partners an opportunity to develop trust by going above and beyond what is expected. * **Hold Nothing As Sacred** \- create routines but modify them routinely. Take the time to reflect on where the business is today, where it needs to go, and what you have to change in order to get there. * **Prioritize Wellness** \- some things should never be sacrificed. We create an environment that stretches everyone to grow and improve, which is fulfilling, but is only one part of a meaningful life. Our estimated pay range for this role is $110,000 to $150,000. Base salary is determined by a variety of factors, including but not limited to, market data, location, internal equitability, and experience. We are committed to being a welcoming and inclusive workplace for everyone, and we are intentional about making sure people feel respected, supported and connected at work—regardless of who you are or where you come from. We value and celebrate our differences and we believe being open about who we are allows us to do the best work of our lives. We are an Equal Opportunity Employer. We do not discriminate against qualified applicants or employees on the basis of race, color, religion, gender identity, sex, sexual preference, sexual identity, pregnancy, national origin, ancestry, citizenship, age, marital status, physical disability, mental disability, medical condition, military status, or any other characteristic protected by federal, state, or local law, rule, or regulation.

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.