to design the database structure that will power the core of our FP&A application. This role is critical for ensuring scalability, performance, and financial accuracy across multi-tenant and enterprise environments.
Responsibilities:
Design and implement scalable, normalized, and high-performing
PostgreSQL database schemas
Model complex FP&A workflows: budgets, forecasts, actuals, scenario planning, and variance analysis
Architect multi-tenant structures with role-based access and data security
Define and enforce data integrity, auditing, and versioning mechanisms
Collaborate with product, engineering, and finance domain experts to align data structure with business needs
Optimize query performance using indexing, partitioning, and materialized views
Prepare ERDs, documentation, and schema versioning strategies (e.g., Flyway/Liquibase)
Requirements:
5+ years of experience in
PostgreSQL database design and development
Proven experience designing
financial or ERP systems
Deep understanding of relational data modeling, normalization, and financial workflows
Strong SQL optimization and performance tuning skills
Hands-on with PostgreSQL features: JSONB, CTEs, window functions, partitioning, etc.
Experience with tools like pgAdmin, DBeaver, dbdiagram.io or pgModeler
Excellent communication and documentation skills
Nice to Have:
Prior experience in
FP&A, Accounting, or Financial SaaS platforms
Exposure to ETL pipelines, data warehousing, and BI tools (Power BI, Tableau)
Knowledge of SaaS multi-tenant architecture
Familiarity with financial standards (GAAP, IFRS)
Contract Details:
Duration:
2 to 3 months
Time Commitment:
Full-time preferred
Mode of Work:
On-site
Possibility of Extension:
Yes
How to Apply:
Please share your
resume
,
portfolio (if any)
, and
GitHub profile
(if applicable) at venkatesh@mavengroup.in. Include your