Senior II Software Engineer

Softeq; Warszawa; On-site; PLN 180,000 - 240,000; Full time

Job summary

Softeq is seeking a skilled developer to build services and APIs using FastAPI, focusing on data access, business logic, and automation. You will design API contracts, implement analytics data access, and ensure secure, scalable access control across a centralized warehouse layer.

You will work on data ingestion, background jobs, and performance tuning for heavy queries, while writing tests and collaborating in CI/CD-driven releases.

Qualifications

• Production Python 3 and FastAPI with async and pydantic.
• Testing with pytest and CI/CD practices.
• Strong SQL and API data serving from an analytical store.
• Databricks consumer side: connectors, SQL warehouses, service principal authentication, grants.
• Unity Catalog grants and row-level rules understanding.
• API security: OAuth2 / OIDC, JWT, RBAC, audit logging.
• Relational DBs: Oracle and SQL Server with drivers.
• Docker and cloud hosting with secrets store.

Responsibilities

• Builds services and APIs in FastAPI: data access, business logic, integrations, automation.
• Designs API contracts and OpenAPI specifications.
• Access layer to analytical store: parameterized queries, pooling, caching.
• Implements access control using per-route checks and warehouse grants.
• Data ingestion: extraction, intermediate formats, loading into raw layer.
• Background jobs and scheduling with idempotency and retries.
• Owns performance on heavy queries with server-side pagination and profiling.
• Writes tests and participates in review and release.

Skills

Python

FastAPI

pytest

SQL

Databricks

OAuth2

OIDC

JWT

API security

Docker

CI/CD

Cloud

Unit testing

Tools

OpenAPI

CI/CD pipelines

Oracle

SQL Server

Unix/Linux

JWT libraries

Job description

Established in 1997, Softeq was built from the ground up to specialize in new product development and R&D, tackling the most difficult problems in the tech sphere. Now we've expanded to offer early-stage innovation and ideation plus digital transformation business consulting. Our superpower is to deliver all of this under one roof on a global scale. So let's get started and build a better future together!

What the role does here

• Builds services and APIs in FastAPI: data access, business logic, integrations, automation;
• Designs API contracts for the customer portal and internal modules, and produces OpenAPI specifications;
• Builds the access layer to the analytical store: parameterized queries, connection pooling, timeouts, retries, caching of permitted results;
• Implements access control and data isolation: a single audited service layer, permission checks on every route, selection of permitted fields only, and reliance on warehouse-level grants rather than application code alone;
• Works on data ingestion: extraction from relational sources, intermediate formats, loading into the raw layer;
• Makes background jobs and scheduling reliable: idempotency, no duplicate runs, failure handling and retries;
• Owns performance on heavy queries: server-side pagination, progressive loading, reading the query execution profile;
• Writes tests, handles errors, takes part in review and release.

Must have

1. Production Python 3 and FastAPI: async, pydantic, service structure;
2. Testing with pytest and working CI/CD practice;
3. Strong SQL and experience serving data from an analytical store through APIs;
4. Databricks from the consumer side: connecting through the connector or the statement execution interface, working with SQL warehouses, service principal authentication, scoping the grants of that identity, and understanding how interactive versus serverless compute affects latency and cost;
5. Understanding of how Unity Catalog grants and row-level rules relate to permission checks in application code;
6. API security: OAuth2 / OIDC, JWT validation, role-based access, audit logging, least privilege;
7. Relational databases at extraction depth: Oracle and SQL Server, their drivers and clients;
8. 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.