Job Title: Data Platform Engineer (Postgres, Permissions & Data Ingestion)
Location: Remote
Type: Full-time
About Us
Oraion is your single source of truth for enterprise data. Oraion uses agentic AI to turn structured and unstructured enterprise data into non-obvious insights, instantly.
Oraion helps you make faster, more informed decisions and even automate complex tasks, all through a self-serve, chat-based AI agent embedded in your existing workflow such as Slack, Teams or via our Enterprise Intelligence Platform.
We're looking for a hands-on, detail-oriented Data Engineer to join our team and help empower businesses to unlock the full potential of their data.
About the Role
We're looking for a Data Platform Engineer with strong Python & PostgreSQL experience to help us build and evolve two core parts of our platform:
* A secure, scalable permissions and access control layer
* Backend features that automate and manage data ingestion pipelines within our SaaS
This role is hands-on and pragmatic, sitting close to the database and core backend services. You'll work primarily with PostgreSQL and Python, building systems that need to be correct, understandable, and easy to operate.
What you'll be working on
Permissions & Access Control
1. Designing and maintaining PostgreSQL schemas to support roles, permissions, and attribute-based access control (ABAC)
2. Implementing and evolving row-level security (RLS) policies in PostgreSQL
3. Writing and optimising complex SQL queries, views, and functions with security and performance in mind
4. Building and maintaining a Python backend service responsible for:
5. Managing roles, permissions, and policies
6. Validating and enforcing access rules
* Exposing clean APIs for the rest of the application
Data Ingestion Automation
7. Building backend features that automate data ingestion workflows within the SaaS
8. Implementing logic to configure, trigger, and monitor ingestion pipelines (e.g. API-based imports, scheduled syncs, file-based ingestion)
9. Designing database models to track ingestion state, metadata, and failures
10. Working with existing ingestion tools and services rather than reinventing core infrastructure
* Improving reliability, observability, and debuggability of ingestion processes
Collaboration & Improvement
11. Working closely with product, frontend, and data teams to translate requirements into robust backend and database designs
12. Reviewing and improving existing permission and ingestion patterns as the platform evolves
* Writing clear, maintainable code and documentation for security- and data-critical systems
What we're looking for
13. Around 5 years of professional backend engineering experience
14. Strong PostgreSQL knowledge, including:
15. Schema design and migrations
16. Indexing and query optimisation
17. SQL functions and views
18. Row-Level Security (RLS) and role-based permissions
19. Strong SQL skills and a good understanding of how Postgres executes queries
20. Solid experience building backend services in Python (e.g. FastAPI or similar)
21. Experience working with data ingestion or integration workflows (APIs, ETL-style processes, or data sync jobs)
22. Familiarity with authentication and authorisation concepts (RBAC, ABAC, least-privilege access)
* Comfortable working in production systems where data correctness and security matter
Nice to have
23. Experience designing permission systems or multi-tenant SaaS architectures
24. Exposure to Postgres internals such as query planning.
25. Experience working with JSONB and semi-structured data in PostgreSQL
26. Familiarity with orchestration or ingestion tools (e.g. Airflow, Dagster, dbt, dlt, or similar)
* Experience operating backend services in a cloud environment (AWS, GCP, or similar)
What this role is not
27. Not a DevOps or infrastructure-heavy role
28. Not a pure data engineering role
* Not a security architect position
Why join us
29. Work on core platform problems: fine-grained permissions and reliable data ingestion
30. Strong ownership of systems that directly impact customers
31. A pragmatic engineering culture that values clarity, correctness, and maintainability
* Opportunity to deepen expertise in PostgreSQL, backend architecture, and data-intensive systems
What We Offer
32. Ground-floor opportunity to shape data-driven AI solutions at a fast-growing startup
33. Work alongside experienced founders and a driven team
34. Competitive compensation + early equity
* Remote-friendly, flexible work culture