Senior Software Engineer, Query Engine Performance - Mixpanel｜Meet.jobs

About the Role

Mixpanel enables fast self-serve product analytics which in turn helps transform how teams make product decisions. We want to disrupt user event steam analytics. Mixpanel is powered by a custom multi-tenant, distributed, columnar database system that scans quadrillions of user-generated events every month to serve these analytical queries. Speed is a core value prop of Mixpanel that allows to do analytics at interactive speeds. We are trying to innovate and differentiate when it comes to performance and not just make incremental tweaks. We have lofty goals for the next 2 years and you will have the opportunity/responsibility of shaping the vision and roadmap.

What You'll Do At Mixpanel

As a Senior Software Engineer, Performance, you will join the Query Engine Team to reliably evolve our columnar analytics database engine as we add more and more users to our multi-tenant system and ingest and query petabytes of data.

You'll be responsible for:

• Doing performance analysis and implementing better indexing strategies, data partitioning, compression and statistic collection.
• Develop tools to profile performance at runtime e.g. perf, eBPF, kernel tracking, flame graphs.
• Implementing best-in-class cloud serving building blocks such as dynamic resource allocation, load-balancing, auto-scaling and more.
• Ensuring reliability and uptime of the services you're responsible for

We're Looking For Someone Who Has:

• A knack for problem-solving and thinking from first principles. You don't shy away from any problem, no matter the scale or impact
• Experience in performance optimization of cloud based big data systems
• Strong troubleshooting skills and hands on knowledge of linux profiling/debugging tools
• Familiarity with multi-threading, CPU/GPU synchronization

Additional Resources

• Engineering Life Page
• Ensuring Data Consistency Across Replicas
• Strategies For Effective Data Compaction
• Monitoring Apache Kafka with JMX Exporter and Kafka Exporter
• Resharding petabytes of data to improve performance for our largest customers
• How we cut BigQuery costs by 80% by identifying and optimizing costly query patterns

Compensation

The total target cash compensation (TTCC) for this full-time position would fall within the bands below. This amount includes base compensation and variable compensation in the form of either a company bonus or commissions. Variable compensation type is determined by your role and level. In addition to the cash compensation provided below, this position is also eligible for equity consideration and other benefits including medical, vision, and dental insurance coverage. You can view our benefits offerings here.

Senior Software Engineer, IC4 $219,500 - $268,500

Staff Software Engineer, IC5 $255,000 - $345,000

Leveling is determined by factors such as years of relevant work experience, level of responsibility, and knowledge required to be successful in the role.

Our salary ranges are determined by role and level and are benchmarked to the SF Bay Area Technology data cut released by Radford, a global compensation database. The range displayed represents the minimum and maximum TTCC for new hire salaries for the position across all of our US locations. To stay on top of market conditions, we refresh our salary ranges twice a year so these ranges may change in the future. Within the range, individual pay is determined by experience, job-related skills, qualifications, and other factors. If you have questions about the specific range, your recruiter can share this information.