Remote Python Sql Tableau Jobs in Pasadena, CA (NOW HIRING)

We believe that mental health is just as important as physical health. We recognize that mental health issues can be complex and multifaceted, and we are dedicated to treating the whole person, not just the symptoms.

We aim to create a world where mental health is no longer stigmatized or marginalized, but rather is embraced as an integral part of one\'s overall well-being. 

We believe that by providing quality care that is both evidence-based and compassionate, we can empower individuals to take charge of their mental health and achieve their full potential. We are passionate about making a positive impact on the lives of those struggling with mental health issues and we strive to be a force for positive change in the field of mental healthcare.

Rula is a remote-first company. We currently hire in most U.S. states, with the exception of Hawaii.

About the Role

We are hiring a Senior Analytics Engineer to join our unified, high-velocity Analytics Engineering pod. In this role you will partner with a talented team of engineers to co-own, scale, and optimize the "Transform" layer of our data ecosystem across modern data platforms.

This is a core technical engineering role. You will balance deep code execution in SQL and dbt with strong cross-functional stewardship, translating complex business processes into trusted, production-grade data models. The ideal candidate will bring a strategic mindset, excellent code hygiene, and the professional backbone required to manage competing technical priorities while navigating highly regulated data systems.

What You’ll Do

• Data Modeling & Architecture: Design, build, and optimize modular dbt pipelines and performant technical schemas, setting the team standard for version control, unit testing, and velocity.

• Cross-Functional Translation: Act as a critical technical bridge between Analytics, Operations, and Data Engineering to transform ambiguous product requirements into robust data assets.

• Platform Optimization: Diagnose performance bottlenecks to slash query latencies and lower warehouse compute costs across our modern data platforms, specifically aiding our strategic migration toward Snowflake.

• Team Stewardship: Elevate the entire pod’s engineering culture by participating in rigorous peer code reviews, refactoring legacy technical debt, and enforcing strict data security standards up to the point of delivery.

• Culture Multiplier: Actively mentor and pair with junior peers to unblock complex bugs, optimize engineering workflows, and natively adopt AI-assisted development tools to accelerate test generation and legacy code discovery.

Required Qualifications

• 4+ years of professional experience in analytics engineering, data engineering, or highly technical data analytics roles.

• Expert-level SQL proficiency and deep data modeling experience, with a proven ability to write performant queries and understand the architectural trade-offs of database design decisions.

• 2+ years of dedicated, hands-on experience building, deploying, and maintaining modular data pipelines using dbt in a production environment.

• Proven experience designing schemas and optimizing query performance on modern cloud data platforms (such as Snowflake, Redshift, or BigQuery).

• Absolute comfort with production git workflows (branching, merging, pull request reviews) and automated data quality testing practices.

• Experience working in a cross-functional role partnering directly with analytics, operations, or business teams, where strong requirement-gathering and the ability to translate complex data structures into clear documentation are crucial.

Preferred Qualifications

While having the preferred qualifications enhances your candidacy, having all of them is not mandatory. We encourage all interested applicants to apply, even those who may not meet every preferred requirement.

• Prior experience working with HIPAA-compliant data environments, electronic health records (EHR), digital health operations, or similar highly regulated industries.

• Hands-on experience or deep familiarity with Snowflake architectures and running data migrations to Snowflake environments.

• Active experience leveraging AI-assisted development tools (like GitHub Copilot, ChatGPT, Cursor, or Claude Code) to accelerate code generation, decipher legacy warehouse logic, and draft robust dbt test suites.

• Experience with Fivetran or modern ingestion tools to deeply understand upstream data structures and better collaborate with the core data engineering pod.

• A proactive approach to data quality, testing, and alert frameworks (such as dbt test packages) and building practical alerting workflows rather than just waiting for stakeholders to report broken data.

• Experience managing changing business processes or schema drift when underlying logic or systems pivot unexpectedly.

• Basic Python proficiency providing an extra layer of technical agility when collaborating on advanced pipeline orchestration or tooling.

We\'re serious about your well-being! As part of our team, full-time employees receive:

• 100% remote work environment: Working hours to support a healthy work-life balance, ensuring you can meet both professional and personal commitments (must be based in United States, currently not hiring in Hawaii)

• Attractive pay and benefits: Full transparency of pay ranges regardless of where you live in the United States

• Comprehensive health benefits: Medical, dental, vision, life, disability, and FSA/HSA

• 401(k) plan access: Start saving for your future

• Generous time-off policies: Including 2 company-wide shutdown weeks each year for self-care (for most employees)

• Paid parental leave: Available for all parents, including birthing, non-birthing, adopting, and fostering

• Employee Assistance Program (EAP): Supporting your mental and physical health

• Quarterly department stipend: Fun team-building activities or in-person gatherings

• Community and employee resource groups: Participate in groups that celebrate employee identity and lived experiences, fostering a sense of community and belonging for all

• Home office stipend: New hire home office stipend & $50 monthly stipend to help cover internet or cell phone expenses

• Wellness at Rula program: Year-round wellness initiatives and a $50/month wellness stipend

Our team

We believe that diversity, equity, and inclusion are fundamental to our mission of making mental healthcare work for everyone.  We are dedicated to having a culture of inclusion that will support our employees in feeling safe, seen, heard, and valued.