Description
Lead Database Engineer
Location: Bengaluru, India
Department: Database
Experience: 7-11
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: www.impactanalytics.co.
Key Responsibilities
▸ Database Development
• Write production-grade SQL for retail microservices — complex queries, stored procedures, functions, views, triggers — with a focus on correctness and performance.
• Design and implement database schemas (tables, indexes, partitions) for assigned services under the guidance of the Database Architect.
• Tune slow queries using EXPLAIN ANALYZE; fix index misuse, missing partitions, and vacuum issues in PostgreSQL.
• Implement and test schema migrations safely — backward-compatible changes, zero-downtime deployments.
• Maintain database security: basic RBAC, access controls, and encryption standards as defined by the architect.
▸ ETL & Data Pipelines
• Support Airflow pipelines that process retail data (1GB–50GB daily) — ingest, cleanse, and transform across DBs/Lakehouse zones.
• Monitor and operate Airflow/Prefect DAGs; troubleshoot failures, fix dependencies, improve retry logic. • Implement data quality checks — null checks, referential integrity, range validation — within pipeline stages.
• Support schema evolution in Delta Lake / Iceberg datasets; handle partition changes and backfills.
▸ Cloud & Tooling • Work with managed cloud databases on GCP (Cloud SQL, BigQuery) — day-to-day operations and query optimisation.
• Set up basic observability: query duration dashboards, replication health alerts, pipeline SLA monitoring in GCP/DataDog.
• Write Python scripts for data automation, validation pipelines, and ad-hoc data investigations.
▸ Collaboration
• Work with ML/Analytics/Product Engineers to understand data access patterns and support feature extraction queries.
• Participate in sprint planning; estimate DB work accurately and flag risks early.
• Raise design questions to the Database Architect and propose solutions before implementing.
• Document table structures, pipeline logic, and runbooks for systems you build.
Must Have
• 7–11 years of hands-on database development and data engineering.
• Strong SQL and PostgreSQL — stored procedures, triggers, views, indexes, partitioning, query tuning.
• Delta Lake or Apache Iceberg — worked in a Lakehouse environment at least as a contributor.
• Cloud database experience: GCP (BigQuery, Cloud SQL).
• Data modelling basics: 3NF, star schema — understands why patterns matter.
• Python for scripting, data validation, and automation.
• Airflow or Prefect for pipeline orchestration — can operate and debug DAGs.
Good to Have
• ClickHouse or any columnar OLAP database (Redshift, BigQuery) — hands-on queries and table design.
• Retail or e-commerce domain: inventory, pricing, promotions, or demand data familiarity.
• NoSQL: Redis, DynamoDB, or MongoDB for specific access patterns.
• GCP Professional Data Engineer certification (studying counts).
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.
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say