Database Architect

Impact Analytics

13 - 18 years

35 - 40 Lacs

bengaluru

Posted:1 day ago| Platform:

Apply

Skills Required

database design postgresql consulting agile application development stored procedures microsoft virtualization monitoring sql

Work Mode

Work from Office

Job Type

Full Time

Job Description

The role would require you to work on Next-gen data platforms, in-memory engines, distributed systems at terabyte scale, even quantum computing explorations.

What You ll Work On

Own the data architecture
: define entity models, keys, and grains; establish modeling standards and guardrails for reliable querying at scale.
Design efficient access patterns
across heterogeneous data sources: choose when to virtualize/federate vs. materialize; favor pushdown and late binding to minimize data movement.
Establish governance & security by design:
implement RBAC, row/column-level security, masking, and retention; ensure policies are consistently enforced and auditable.
Enable lineage, quality, and trust:
integrate schema/lineage capture, freshness/SLA monitoring, and reproducibility artifacts so answers can be explained and re-run
Analyze database design and architecture requirements for the distributed applications
Design the databases for the microservices with well defined bounded context and interaction
Develop, construct, test and maintain existing and new data-driven architectures
Align architecture with business requirements and provide solutions which fits best to solve the business problems
Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources on the Cloud (AWS / GCP). Using well defined ETL tools like PySpark, Data Flow.

What We re Looking For

13+ years as a hands-on technologist with a good mix of application development and database development. Expert Level Sql, Postgresql, including stored procedures, functions, triggers, and views .Experience BigQuery or oracle SQL or any database would be a plus.
Experience in designing
canonical data models
and high-performance SQL in modern cloud warehouses (Snowflake, BigQuery, Redshift, Databricks SQL, Postgres).
Deep knowledge of
dimensional modeling
(facts/dims, grains),
SCD1/SCD2
,
point-in-time
joins.
Hands-on with
query federation/virtualization
patterns and tradeoffs (pushdown, partial aggregation, cross-source joins, late binding).
Experience with
query engines
(Trino/Presto),
dbt
,
OpenLineage
,
Great Expectations/Monte Carlo
, and
catalogs
(data.world, Collibra, Alation).
Exposure to
semantic layers
(LookML / Transform / MetricFlow / AtScale) and
metrics catalogs
.
Familiarity with
knowledge graphs/ontology
basics (classes / relationships / synonyms) for terminology alignment.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics, partitioning and isolation levels
Good understanding of Postgresql replication, high availability and clustering across availability zones and regions
Good understanding of Database backup and restore to align with data laws
Participate in an agile software development life cycle including providing testing guidelines for database related changes.

What we offer

An opportunity to be part of some of the best enterprise SaaS products to be built out of India.
Opportunities to quench your thirst for problem-solving, experimenting, learning, and implementing innovative solutions.
A flat, collegial work environment, with a work hard, play hard attitude.
A platform for rapid growth if you are willing to try new things without fear of failure.
Remuneration with best-in-class industry standards with generous health insurance cover

Some of our accolades include:

Ranked as one of Americas Fastest-Growing Companies by Financial Times for five consecutive years: 2020-2024.
Ranked as one of Americas Fastest-Growing Private Companies by Inc. 5000 for seven consecutive years: 2018-2024.
Voted #1 by more than 300 retailers worldwide in the RIS Software LeaderBoard 2024 report.
Ranked #72 in America s Most Innovative Companies list in 2023 by Fortune alongside companies like Microsoft, Tesla, Apple, IBM, etc.
Forged a strategic partnership with Google to equip retailers with cutting-edge generative AI tools.
Recognized in multiple Gartner reports, including Market Guides and Hype Cycle, spanning assortments, merchandising, forecasting, algorithmic retailing, and Unified Price, Promotion, and Markdown Optimization Applications.

More Jobs at Impact Analytics

Senior Engineering Manager / Director

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru

18 - 20 yrs

INR 20 - 25 Lacs

Talent Acquisition Specialist

Bengaluru, Karnataka, India

Experience: Not specified

Salary: Not disclosed

Senior Software Engineer - Frontend (Angular)

Kolkata, Mumbai, New Delhi, Hyderabad, Pune, Chennai, Bengaluru

4.0 - 9.0 yrs

INR 30 - 35 Lacs

SQL Developer

Bengaluru, Karnataka, India

1.0 - 3.0 yrs

Salary: Not disclosed

Senior Software Engineer - Backend ( Rust )

Bengaluru

4.0 - 7.0 yrs

INR 15 - 25 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.