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