Note: The job is a remote job and is open to candidates in USA. Confidential is an analytics SaaS company that provides a real-time source of truth across various systems. As a Software Engineer II, you will build and maintain ETL pipelines, backend services, and AI capabilities while collaborating with senior engineers and product leaders to enhance the platform's analytics functionalities.

Responsibilities

• Build and maintain the ETL that ingests commerce, marketing, financial, and POS data across many sources (Shopify, Toast, QuickBooks, ad platforms, email/SMS, and more) and normalizes it per tenant
• Own and extend the transformation layer that turns raw source data into the analytical models and datasets the dashboards read
• Debug data issues and keep pipelines correct, fresh, and cost-efficient
• Help evolve the platform's data stack toward modern lakehouse and analytics-engineering tooling, with technologies like DuckDB, DuckLake, and dbt
• Build features in our Python services, which we're standardizing on FastAPI and REST
• Design and ship APIs against PostgreSQL with care for multi-tenancy and tenant isolation
• Build and maintain integrations with external data sources and financial systems
• Design and implement RAG over client data, from retrieval to LLM and tool integration to prompt and output handling
• Orchestrate multi-step LLM and agent workflows with frameworks like LangGraph
• Work with vector databases such as Pinecone to power retrieval
• Build and maintain an MCP interface to the platform
• Build the evals and monitoring that keep AI features accurate, reliable, and cost-efficient
• Build and maintain features in our React SPA (React 18, Vite, JavaScript/JSX, TanStack Query, MUI + Tailwind, Mapbox, and a set of charting libraries)
• Partner with product on usability and performance across our data-grid- and chart-heavy surfaces
• Work closely with product, analytics, and finance requirements to turn domain needs into shipped features
• Participate in sprint planning, standups, code review, and engineering decisions
• Document your work and contribute to internal knowledge sharing

Skills

• 2–4 years of software engineering experience
• Solid experience building and maintaining data pipelines and ETL workflows. We care about depth in the space more than any specific stack, so familiarity with the modern analytics-engineering toolset (e.g. dbt, Dagster or Airflow, DuckDB, Cube) is a plus
• Strong backend Python (FastAPI experience a plus)
• Strong relational database design and data modeling, with PostgreSQL experience
• Comfortable working in a React frontend with JavaScript/JSX, including hooks, function components, and React Query / Context-style state management
• Read the job description; to verify you have, please enter one hundred for years of experience with attention to detail on the last step of the application
• Experience with cloud infrastructure, preferably AWS (Lambda, ECS, RDS, SQS, EventBridge, S3)
• Familiarity with REST API design
• Hands-on expertise with agentic coding practices, using coding agents (e.g. Claude, Cursor) to plan, write, review, and refactor code as a core part of how you work
• Hands-on experience building LLM-powered product features, such as RAG, agent and tool-use orchestration, and prompt and evaluation design, including working against the Anthropic, OpenAI, or similar APIs
• Depth in any of the AI stack we use, such as vector databases (e.g. Pinecone) or agent-orchestration frameworks (e.g. LangGraph)
• Experience on SaaS or data-focused applications
• Experience safely evolving or migrating live production systems
• Interest in finance, analytics, or data products

Benefits

• Plus benefits

Company Overview