PostgreSQL Data Architect

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 [email protected]. 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