Postgresql Data Architect

Year    TS, IN, India

Job Description

About the Role:



We are seeking a highly skilled and experienced

PostgreSQL Data Architect

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

availability

and

expected rate

.

Job Types: Part-time, Contractual / Temporary, Freelance

Pay: ?30,000.00 - ?40,000.00 per month

Schedule:

Morning shift
Location:

HITEC City, Hyderabad, Telangana (Preferred)
Work Location: In person

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD3826816
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Part Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    TS, IN, India
  • Education
    Not mentioned
  • Experience
    Year