Database Architect

About Impact Analytics Impact Analytics™ (Series C Funded) offers the only complete, fully integrated, AI-powered suite of planning and merchandising products focused on retail, CPG, and supply chain. A growing roster of top brands relies on our SaaS solutions—all of which are built on native AI—to maximize profitability through data-driven decision-making across full-lifecycle categories, including demand forecasting, pricing optimization, assortment, inventory management, and financial planning. Founded in 2015 as an AI company for the retail industry, our 600-strong crew remains a startup at heart, relentlessly committed to technology innovation and ensuring customer success through AI-powered insights. Here’s a link to our website: The impact that you will be making The role would require you to develop sophisticated products that add value to the client and result in new projects and revenue streams. What this role entails: 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 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 similar tool What lands you in this role 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 in database design and modelling. 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 What we offer An opportunity to develop 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. Our accolades include: Ranked #72 in America’s Most innovative Companies list in 2023 alongside companies like Microsoft, Tesla, Apple, IBM, etc. Ranked as one of America' s fastest growing companies by Financial Times for four consecutive years: 2020-2023. Ranked as one of America' s fastest-growing private companies by Inc 5000 for Six consecutive years: 2018-2023. Recognized in multiple Gartner reports, including Market Guides and Hype Cycle , spanning assortment, merchandising, forecasting, algorithmic retailing, and Unified Price, Promotion, and Markdown Optimization Applications. Featured as one of top 25 ML startups to watch by Forbes in 2019. Ranked as one of North Americas' fastest-growing technology companies by Deloitte for two consecutive years 2019 & 2020 Kindly share your updated resume to geetu.mishra@impactanalytics.co along with below details: Total Experience: Current location: Current and Expected CTC: Notice period: