Database Architect

Impact Analytics TM Series D Funded delivers AI-native SaaS solutions and consulting services that help companies maximize profitability and customer satisfaction through deeper data insights and predictive analytics With a fully integrated end-to-end platform for planning forecasting merchandising pricing and promotions Impact Analytics empowers companies to make smarter decisions based on real-time insights rather than relying on last year s inputs to forecast and plan this year s business Powered by over one million machine learning models Impact Analytics has been leading AI innovation for a decade setting new benchmarks in forecasting planning and operational excellence across the retail grocery manufacturing and CPG sectors In 2025 Impact Analytics is at the forefront of the Agentic AI revolution delivering autonomous solutions that enable businesses to adapt in real time optimize operations and drive profitability without manual intervention Here s a link to our website What s this role about 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 America s Fastest-Growing Companies by Financial Times for five consecutive years 2020-2024 Ranked as one of America s 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