Senior Python Backend Engineer

Softeq; Región Centro; Vor Ort; MXN 446.000 - 781.000; Vollzeit

Zusammenfassung

Softeq in Mexico is seeking a backend engineer focused on Python and FastAPI to build scalable APIs and services. You will design API contracts, enable secure data access, and optimize analytical data flows via Databricks with Unity Catalog, OAuth2, and JWT-based security.

You will handle ingestion, scheduling, and robust testing, contributing to CI/CD and reviews to ensure reliable releases. Candidate should be comfortable with Oracle/SQL Server drivers and cloud hosting, as part of a globally

Qualifikationen

• 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: connecting through the connector or the statement execution interface, auth and grants scoping.
• Unity Catalog grants and row-level rules in application code.
• API security: OAuth2 / OIDC, JWT validation, role-based access, audit logging.
• Relational databases: Oracle and SQL Server drivers and clients.
• Docker and cloud hosting, with a secrets store.

Aufgaben

• 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: audited service layer, permission checks on every route, and grants discipline at warehouse level.
• Works on data ingestion: extraction from relational sources, intermediate formats, loading into the raw layer.
• Makes background jobs and scheduling reliable: idempotency, no duplicates, failure handling and retries.
• Writes tests, handles errors, participates in review and release.
• Writes and tunes heavy queries for performance and scalability.

Kenntnisse

Python

FastAPI

SQL

CI/CD

OAuth2

JWT

Docker

Tools

Databricks

Unity Catalog

OpenAPI

Oracle

SQL Server

Jobbeschreibung

30+ days ago Requisition ID: 1094

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

• 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: 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;
• 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.

Softeq communicates only from @ softeq.com email addresses. We never request payments or fees for any reason during hiring - including trainings or courses to be completed, equipment, onboarding, or background checks - and we will not ask for banking information, cryptocurrency or gift cards. If you receive a message from any other domain or requesting payment, do not respond and report it to [e-mail]