Analytics Engineer II
125k - 145k USD
Remote
Full Time
#Insurance
#Data
#SQL
#DBT
#Python
#BigQuery
#dataform
#Data Visualization
About Spark Advisors
We’re Spark, a mission-driven company helping independent Medicare brokers build the insurance business of their dreams. The vast majority of beneficiaries select benefits with the help of an independent broker, but technology and support for brokers is woefully antiquated. We provide workflows and services to help brokers achieve transformative growth.
In just five years, we’ve partnered with over 6,000 brokers and enrolled over 140,000 beneficiaries, making us the fastest-growing Medicare brokerage in the country. Brokers love us: during this period of intense growth, we’ve maintained an NPS of 91 and a client retention rate of 93%, and we’ve helped brokers grow on average >100% since partnering with us.
It’s an exciting time to be at Spark. Our diverse, remote-first team comes from leading technology, healthcare, and insurance companies, and has grown from 70 to 90 in the last year. Most recently, we’ve raised a Series B from leading investors who share our ambition.
Join us: we’re always on the lookout for sharp, talented, empathetic teammates.
Summary
Spark is seeking an Analytics Engineer II to join our data team. Historically, the medicare distribution industry has had a lack of transparency, but Spark is on a mission to change that. You can be a key part of the change by helping Spark and our customers wrangle, structure and draw valuable insights from a variety of data sources.
In this role, you will be responsible for improving core datasets and building the pipelines that power our business. This work will enable Spark to create data-driven products for our customers and gain actionable insights into our business. As a key member of the Spark Data team, you'll collaborate closely with product, engineering, carrier relations, and other teams to deliver high-quality datasets.
What you’ll do
- Design, optimize, and maintain scalable ELT data pipelines using GCP tools, focusing on BigQuery and Dataform/dbt.
- Automate and standardize data processes to improve efficiency, reduce manual effort, and ensure consistent data flow.
- Partner with cross-functional teams to understand business needs and translate them into technical data solutions that support data-driven insights.
- Mentor and upskill junior engineers, fostering a collaborative and growth-oriented environment.
- Ensure data quality through rigorous testing, analysis, and continuous improvement of data processes.
- Own and deliver medium-scale data projects, managing end-to-end execution and stakeholder communication.
What we’re looking for
- 4+ years of experience in data or analytics engineering.
- Advanced proficiency in SQL and experience with DBT/Dataform for building scalable pipelines
- Some exposure to Python and data visualization tools (e.g. Metabase, Hex, Tableau, PowerBI)
- Detail-oriented with the ability to analyze complex data and draw conclusions even when faced with messy/incomplete data
- Proven ability to automate data workflows using modern tools
- Comfortable giving and receiving feedback on standardized processes to ensure quality and consistency
- Strong communication skills for working cross-functionally with various teams
Nice to Haves
- Additional Python experience for data manipulation or automation
- Familiarity with managing transformation tools and cloud resources in AWS/GCP
- Background in analytics or business intelligence to drive insights from data
- Experience with data warehousing, performance tuning, and large datasets
Compensation
Our salary ranges are based on paying competitively for our company’s size and industry, and are one part of the total compensation package that also includes equity, benefits, and other opportunities at Spark. In accordance with New York City, Colorado, California, and other applicable laws, Spark is required to provide a reasonable estimate of the compensation range for this role. Individual pay decisions are ultimately based on a number of factors, including qualifications for the role, experience level, skillset, geography, and balancing internal equity. A reasonable estimate of the current salary range is listed below. We expect most candidates to fall in the middle of the range. We also believe that your personal needs and preferences should be taken into consideration, so we allow some choice between equity and cash.
Why you should join our team
By joining Spark, you will get in on the ground floor of a fast-moving, well-funded, and mission-driven startup where you will have a profound impact on the brokers and beneficiaries we serve. And you'll learn, grow, be challenged, and have fun with your team while doing it.
We strive to help you and your family thrive. We're committed to supporting your happiness, healthiness, and overall well-being by providing a comprehensive benefits program. In addition to your base salary, we also offer:
- Equity compensation
- Health care, including dental and vision through our PEO Sequoia
- Flexible work location; co-working available
- 401k
- Paid Time Off
- Monthly Remote Work Stipend (help cover costs of home-office needs)
- Paid Parental Leave
- Up to 12 weeks for birthing parents
- Up to 8 weeks for non-birth parents
- 11 paid holidays
- 2 week sabbatical at 5 years of employment
- Wellbeing Perks through SpringHealth, OneMedical, PerkSpot, and SoFi
Compliance
Spark is a proud participant in E-Verify. As part of our commitment to compliance, we use the E-Verify program to confirm the employment eligibility of all employees working in the United States. For more information about E-Verify, please visit www.e-verify.gov.
Furthermore, for security and compliance requirements, we’re unable to accommodate international remote work. While we fully support travel and time off, all work must be conducted from an approved location within the U.S.
At Spark, we are committed to hiring the best team to serve our clients regardless of their background. We need diverse perspectives to reflect the diversity of our problems and the population we serve. We look to hire people from a variety of backgrounds, including, but not limited to, race, age, sexual orientation, gender identity and expression, national origin, religion, disability, and veteran status.
