AI-Powered Data Analysts / AI Research Associates

FirstCry.com (BrainBees Solutions Ltd.) is actively seeking a highly skilled and motivated PostgreSQL Data Analyst to join our dynamic team in Pune. As a PostgreSQL Data Analyst, you will play a pivotal role in extracting, analyzing, and preparing critical data from various databases, directly supporting crucial business and operational decision-making across the organization. This position offers an exciting opportunity to leverage your advanced SQL expertise to generate actionable insights and drive efficiency in our data processes.

The ideal candidate will be proficient in designing and optimizing complex SQL queries, developing robust stored procedures, and automating comprehensive reports. You will be responsible for ensuring data accuracy, investigating discrepancies, and collaborating closely with stakeholders to translate business needs into effective data-driven solutions. If you possess a passion for data, a keen eye for detail, and a strong analytical mindset, we encourage you to apply and contribute to FirstCry.com's continued success.

Key Responsibilities

• Write, optimize, and maintain complex SQL queries using advanced features of PostgreSQL and Google BigQuery to support various analytical requirements.
• Develop and manage stored procedures, functions, CTEs, joins, window functions, and aggregations for efficient data analysis and reporting.
• Execute comprehensive data extraction, transformation, validation, and analysis from diverse database sources to ensure data integrity.
• Design and automate daily, weekly, and monthly Management Information System (MIS) and operational reports, significantly reducing manual reporting efforts.
• Prepare and deliver accurate, timely, and insightful analytical reports to business stakeholders and management for informed decision-making.
• Proactively validate data accuracy, investigate any discrepancies, and address data-quality issues to maintain high standards of data reliability.
• Create and maintain reusable SQL scripts and procedures, enhancing reporting efficiency and standardization across the organization.
• Collaborate effectively with cross-functional stakeholders to thoroughly understand their data requirements and translate them into robust SQL-based solutions.
• Monitor automated reporting systems to ensure reports are delivered precisely and punctually, upholding critical business timelines.
• Continuously identify opportunities to optimize existing queries and reporting processes, striving for improved performance and overall efficiency.

Requirements

• Proven expertise in PostgreSQL and Google BigQuery, demonstrating the ability to write and optimize complex SQL queries.
• Strong understanding and practical experience with advanced SQL concepts, including Window Functions, Stored Procedures, Functions, CTEs, Joins, Subqueries, and Aggregations.
• Solid experience in data validation, reconciliation, and troubleshooting data quality issues.
• Proficiency in report automation, MIS reporting, and developing operational reports.
• Excellent stakeholder management and communication skills, with the ability to gather requirements and translate them into technical solutions.
• Familiarity with data visualization tools such as Excel, Power BI, or Tableau is highly preferred.
• Experience working with large datasets and a foundational understanding of ETL/data pipelines is a significant advantage.

What We Offer

• A stimulating and collaborative work environment where innovation is encouraged.
• Opportunity to work with a leading e-commerce platform and make a significant impact on business decisions.
• Continuous learning and professional development opportunities in cutting-edge data technologies.
• Competitive compensation package and comprehensive benefits.
• A chance to be part of a high-growth company with a strong commitment to data-driven strategies.