Senior Software Engineer- Big Data & MCP, Data Foundations

Senior Software Engineer – Big Data & MCP, Data Foundations

Location: Portland, OR

Job : 1250

# of Openings: 1

Job Summary: At Rev Spring, we build secure, outcomes‑driven solutions that turn insight into action — streamlining engagement, simplifying payments, and driving better results. Join a diverse team focused on innovation, impact, and customer success.

• Collaborate and innovate: partner with product managers, data engineers, and business leaders to translate complex product and data requirements into scalable, reliable data pipelines and the search experiences they power.
• Architect data pipelines: design, build, and optimize large‑scale distributed batch and streaming pipelines (using Apache Airflow, Apache Beam/Dataflow, and DBT to Big Query) to ingest, model, and transform high‑volume healthcare data into clean, well‑tested, query‑ready datasets and search indices.
• Build data models & backend services: develop resilient Python services and DBT models that power data delivery and self‑service analytics, including Model Context Protocol (MCP) servers that expose curated data and tooling to downstream and AI consumers, and integrate with external REST/SOAP APIs and third‑party data sources.
• Optimize data & search performance: deeply tune pipeline throughput, data warehouse performance, and search indexing — optimizing Big Query cost and query performance and Elasticsearch index design to ensure data freshness, relevance, and scalability across high‑volume datasets.
• Drive engineering excellence: write clean, maintainable, well‑tested code and lead by example through rigorous code reviews, architectural and data‑modeling design discussions, and mentoring, driving a culture of high‑quality software and trustworthy data.
• Pioneer new technologies: stay at the forefront of modern data engineering, the analytics‑engineering ecosystem (e.g., DBT, Big Query), and information retrieval, proactively applying these advancements to strengthen our data platform and the products it powers.

• Data engineering: proven experience designing and orchestrating large‑scale ETL/ELT pipelines using Apache Beam/Google Cloud Dataflow (or similar), DBT, built on modern cloud data warehouses. Big Query experience is a plus.
• Databases & SQL: 4+ years of experience working with relational databases and analytical data warehouses, with deep, advanced SQL skills and solid data‑modeling fundamentals (e.g., dimensional and normalized modeling).
• Search & Indexing: working experience with search indexing and Elasticsearch, including index management, mappings, and building and maintaining search indices from pipeline output. Familiarity with hybrid (BM25 + semantic/vector) search is a plus.
• Backend & data services: experience building scalable Python services and high‑performance data APIs, including developing Model Context Protocol (MCP) servers that expose data and tooling to downstream and AI consumers.
• Infrastructure & Dev Ops: strong understanding of containerization (Docker), CI/CD methodologies (e.g., Git Hub Actions), Git, infrastructure as code (e.g., Terraform/Pulumi), and managing services within cloud platforms (3+ years of GCP experience preferred).
• Familiarity with healthcare data standards (e.g., NPPES/NPI registries, NUCC Provider Taxonomy, machine‑readable files (MRFs) for cost transparency, and FHIR).
• Experience with data quality and pipeline testing frameworks (e.g., dbt tests, Great Expectations) and streaming/event ingestion (e.g., Pub/Sub, Kafka).
• Experience integrating graph‑based data and healthcare taxonomy ontologies to enrich datasets and search query context.
• Experience with observability and logging platforms (e.g., Data Dog) for monitoring pipeline health and data freshness.

Education: Bachelor’s Degree

Experience: 5+ years of professional experience with Python, with strong software‑engineering fundamentals (testing, code review, design). 3+ years experience with Java or another JVM language is also highly desired, particularly for Beam/Dataflow.

Supervision: N/A

Certifications: N/A

Language

Skills:

Ability to read, analyze and interpret general business periodicals,…