Spark Advisors Logo

Spark Advisors

Analytics Engineer II

Job Posted 9 Days Ago Posted 9 Days Ago
Easy Apply
Remote
Hiring Remotely in United States
125K-145K Annually
Mid level
Easy Apply
Remote
Hiring Remotely in United States
125K-145K Annually
Mid level
The Analytics Engineer II will design and maintain ELT data pipelines, automate data processes, ensure data quality, and mentor junior engineers, collaborating across teams to drive actionable insights.
The summary above was generated by AI
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.

Base Salary

$125,000$145,000 USD

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.

Top Skills

BigQuery
Dataform
Dbt
GCP
Hex
Metabase
Power BI
Python
SQL
Tableau

Similar Jobs at Spark Advisors

2 Hours Ago
Easy Apply
Remote
United States
Easy Apply
85K-100K Annually
Junior
85K-100K Annually
Junior
Healthtech • Insurance • Other • Sales • Software
The Agency Finance Associate will manage financial operations, including commission disbursement, data analysis, and agent inquiries, while enhancing efficiency within the finance team.
Top Skills: ExcelFinancial ToolsQuickbooks
Yesterday
Easy Apply
Remote
United States
Easy Apply
170K-190K Annually
Senior level
170K-190K Annually
Senior level
Healthtech • Insurance • Other • Sales • Software
The Senior Software Engineer will enhance the core platform for brokers, collaborating with teams to develop and maintain web applications using JavaScript and Python, focusing on scalability and user experience.
Top Skills: DjangoDockerGitJavaScriptPythonReactTailwind CssVueWebpack
Yesterday
Easy Apply
Remote
United States
Easy Apply
225K-275K Annually
Senior level
225K-275K Annually
Senior level
Healthtech • Insurance • Other • Sales • Software
The VP of Marketing will develop Spark's marketing strategy, build a high-performing team, manage go-to-market strategies, and refine brand positioning.

What you need to know about the Seattle Tech Scene

Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.

Key Facts About Seattle Tech

  • Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Amazon, Microsoft, Meta, Google
  • Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Madrona, Fuse, Tola, Maveron
  • Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
By clicking Apply you agree to share your profile information with the hiring company.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account