Senior II Software Engineer

Stack

Responsibilities

• ▹Build services and APIs in FastAPI: data access, business logic, integrations, automation
• ▹Design API contracts for the customer portal and internal modules and produce OpenAPI specifications
• ▹Build the access layer to the analytical store: parameterized queries, connection pooling, timeouts, retries, caching of permitted results
• ▹Implement access control and data isolation: a single audited service layer, permission checks on every route, selection of permitted fields only, reliance on warehouse-level grants
• ▹Work on data ingestion: extraction from relational sources, intermediate formats, loading into the raw layer
• ▹Make background jobs and scheduling reliable: idempotency, no duplicate runs, failure handling and retries
• ▹Own performance on heavy queries: server-side pagination, progressive loading, reading the query execution profile
• ▹Write tests, handle errors, take part in review and release

Requirements

• ▹Production Python 3 and FastAPI: async, pydantic, service structure
• ▹Testing with pytest and working CI/CD practice
• ▹Strong SQL and experience serving data from an analytical store through APIs
• ▹Databricks from the consumer side: connector or statement execution interface, SQL warehouses, service principal authentication, scoping grants, and understanding how interactive versus serverless compute affects latency and cost
• ▹Understanding of how Unity Catalog grants and row-level rules relate to permission checks in application code
• ▹API security: OAuth2 / OIDC, JWT validation, role-based access, audit logging, least privilege
• ▹Relational databases at extraction depth: Oracle and SQL Server, their drivers and clients
• ▹Docker and cloud application hosting, working with a secrets store

Nice to have

• ▹Tuning analytical queries for interactive interface workloads
• ▹Node.js / Express
• ▹Multi-tenant systems where cross-customer leakage is unacceptable
• ▹Integrating external feeds and third-party APIs: weather, navigation, geospatial services, tracking data

About the company

Softeq was founded in 1997 and specialises in new product development and R&D, and also offers early-stage innovation and digital transformation consulting on a global scale.