What this role entail
- Analyse database design and architecture requirements for the distributed applications
- 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
- 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
- Design and implement scalable data models and schemas in BigQuery
- Demonstrate a solid understanding of BigQuery architecture, including the organization of projects, datasets, tables, and workflows.
- Handle large-scale datasets (1+ TB) with a focus on performance optimization and cost efficiency using techniques like partitioning, clustering, and materialized views.
What lands you in this role
Four 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.Monitor BigQuery usage and costs, implementing optimization strategiesImplement data lifecycle management and archival policiesOptimize slot usage and query scheduling for cost efficiencySet up and maintain dataset-level and table-level security controlsStrong 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 levelsParticipate in an agile software development life cycle including providing testing guidelines for database related changes.Good understanding of Programming language, preferably Python for custom scriptsUnderstanding No SQL and In memory databases is a value addAbout 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 .
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.Skills Required
BigQuery, Database Design, Postgresql, Query Optimization, Sql, Python