Database Architect

About Impact Analytics

Impact Analytics (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:

Some of our accolades include:

• Ranked as one of
  America's Fastest-Growing Companies
  by
  Financial Times
  for
  five
  consecutive years:
• Ranked as one of
  America's Fastest-Growing Private Companies
  by
  Inc. 5000
  for
  seven
  consecutive years:
• Ranked
  #72
  in
  America's Most Innovative Companies
  list in
  2023
  —by
  Fortune
  — alongside companies like Microsoft, Tesla, Apple, IBM, etc.
• 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.

About the Role

• 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 that 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
• Data acquisition and clean-up from multiple sources across the organization
• Design custom tools to collate the data
• Identify ways to improve data reliability, efficiency, and quality
• Develop automated tasks for data operations
• Deliver updates to stakeholders based on analytics
• Set up practices on data reporting and continuous monitoring using Prometheus, ELK or a similar tool

What lands you in this role

• Seven or more 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.
• Strong understanding of database design and modeling.
• Ability to efficiently write database code without compromising data quality, privacy, or security.
• 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.
• Good understanding of Programming language, preferably Python for custom scripts
• Understanding No SQL and in-memory databases is a value add