BUSINESS DEVELOPMENT ASSOCIATE

Job description:

Role Overview

We are seeking a Senior SQL Developer & ETL Engineer with 5+ years of experience for a 100% remote opportunity.

Please note: This is not a standard Big Data / Infra-heavy Data Engineering role. We are specifically looking for a SQL Specialist. Your core strength must lie in relational database development, schema design, and writing high-performance database logic. Python will be your primary tool for moving and orchestrating data, but SQL and database architecture are the heart of this role.

Key Responsibilities

• Database Architecture & Schema Design: Design, implement, and maintain robust relational database schemas, ensuring optimal data modeling (OLTP and OLAP/Data Warehousing).
• Advanced Database Programmability: Write, debug, and optimize complex Stored Procedures, Functions, Triggers, and Views to handle core business logic at the database level.
• Performance Tuning & Indexing: Analyze query execution plans, identify bottlenecks, and implement advanced indexing strategies, partitioning, and query refactoring to ensure sub-second response times.
• Python ETL/ELT Pipelines: Develop, schedule, and maintain scalable data ingestion and transformation pipelines using Python to connect disparate data sources.
• Data Integrity & Governance: Establish constraints, data validation routines, and automated quality checks to guarantee absolute data accuracy.

Required Technical Skills

• Expert-Level SQL & DB Programmability (5+ Years): Mastery of writing complex queries (CTEs, Window Functions, Analytical queries) and server-side logic (Stored Procedures/Functions) in platforms like PostgreSQL, SQL Server, Oracle, or MySQL.
• Advanced Database Optimization: Deep understanding of how databases work under the hood—specifically indexing (B-Tree, Hash, Clustered/Non-Clustered), execution plans, statistics, and locking/concurrency mechanisms.
• Python for Data Ingestion (3+ Years): Proficient in writing clean, modular Python scripts for data manipulation, API integration, and ETL processing (using libraries like Pandas, SQLAlchemy, or custom database connectors).
• Data Modeling Methodologies: Practical experience designing Star/Snowflake schemas, Normalization (3NF), and handling Slowly Changing Dimensions (SCD).

Remote & Soft Skills

• Autonomous Execution: Proven ability to manage your own time, architecture tasks, and deliverables without micromanagement.
• Asynchronous Communication: Exceptional written and verbal English communication skills to collaborate seamlessly across time zones.
• Legacy Refactoring Mindset: You enjoy opening up a massive, poorly optimized 500-line stored procedure and refactoring it for 10x performance.

Nice-to-Haves

• Experience migrating legacy on-premise stored procedures to modern cloud data warehouses (Snowflake, BigQuery, Redshift).
• Familiarity with workflow orchestration tools like Apache Airflow or Prefect.
• Experience with dbt (data build tool).

Work Location: Remote

Position: Talent Acquisition Head – Retail Brand (Non-IT Hiring)

Location: Gurgaon

Experience: 10+ years in retail brand

Industry: Retail (Fashion, Apparel, FMCG, Luxury, or related)

Department: Human Resources (HR)

Job Summary:

We are looking for a dynamic and strategic Talent Acquisition Head to lead the recruitment function for our retail brand. The ideal candidate will have extensive experience in Non-IT hiring, particularly in retail, FMCG, or related industries. This role involves managing end-to-end recruitment, building talent pipelines, and ensuring the right talent acquisition strategies to support business growth.

Key Responsibilities:1. Talent Acquisition Strategy & Execution:

• Develop and execute talent acquisition strategies aligned with business objectives.
• Oversee bulk hiring and leadership hiring for retail stores, corporate functions, and supply chain roles.
• Optimize sourcing channels (job portals, employee referrals, social media, and recruitment agencies).

2. Recruitment Operations & Stakeholder Management:

• Lead end-to-end recruitment for store-level, regional, and corporate roles.
• Partner with business heads and HRBPs to identify hiring needs and workforce planning.
• Manage vendor relationships and negotiate contracts with recruitment agencies.

3. Employer Branding & Talent Pipeline Development:

• Drive employer branding initiatives to attract top talent.
• Build a strong talent pipeline for future hiring needs.
• Engage in campus hiring and lateral hiring strategies.

4. Recruitment Analytics & Compliance:

• Track recruitment metrics (TAT, cost-per-hire, quality-of-hire, etc.) for continuous improvement.
• Ensure compliance with labor laws and company policies in hiring practices.
• Implement and manage Applicant Tracking Systems (ATS) for seamless recruitment.

Key Requirements:

·         10+ years of experience in Non-IT hiring, preferably in Retail, FMCG, Apparel, Luxury, or QSR sectors.

·         Proven expertise in bulk hiring, corporate hiring, and leadership hiring.

·         Strong experience in headhunting, passive talent search, and market mapping.

·         Excellent communication, negotiation, and stakeholder management skills.

·         Hands-on experience with ATS, LinkedIn Talent Solutions, and recruitment tools.

·         Ability to thrive in a fast-paced, high-growth retail environment.

mail updated resume with current ctc and notice period-

email: jobs[at}glansolutions[dot]com

website: www.glansolutions.com

Python Developer 

Location: Hyderabad (Apple Office)

Experience: 8+ years (Retail / E-commerce preferred)

Budget- 1.9 lpm + GST

Contract: 1 Year + Extendable

Job Responsibilities / Requirements:

• 8+ years of proven experience, preferably in retail or e-commerce environments.
• Strong expertise in Python development.
• Excellent communication skills with the ability to collaborate across multiple teams.
• Hands-on experience with Container & Orchestration: Kubernetes, Docker.
• Expertise in Infrastructure Automation via Kubernetes YAML configurations.
• Strong skills in Scripting & Automation: Python, Shell Scripts (Bash).
• Familiarity with CI/CD Pipelines: GitHub Actions, Jenkins.
• Experience with Monitoring & Logging: Splunk, Grafana.
• Immediate Joiners Preferred – Urgent Support Required.

Job Title: Data Engineer

Cargill’s size and scale allows us to make a positive impact in the world. Our purpose is to nourish the world in a safe, responsible and sustainable way. We are a family company providing food, ingredients, agricultural solutions and industrial products that are vital for living. We connect farmers with markets so they can prosper. We connect customers with ingredients so they can make meals people love. And we connect families with daily essentials — from eggs to edible oils, salt to skincare, feed to alternative fuel. Our 160,000 colleagues, operating in 70 countries, make essential products that touch billions of lives each day. Join us and reach your higher purpose at Cargill.

Job Purpose and Impact

As a Data Engineer at Cargill you work across the full stack to design, develop and operate high performance and data centric solutions using our comprehensive and modern data capabilities and platforms. You will play a critical role in enabling analytical insights and process efficiencies for Cargill’s diverse and complex business environments. You will work in a small team that shares your passion for building innovative, resilient, and high-quality solutions while sharing, learning and growing together.

Key Accountabilities

Collaborate with business stakeholders, product owners and across your team on product or solution designs.

· Develop robust, scalable and sustainable data products or solutions utilizing cloud-based technologies.

· Provide moderately complex technical support through all phases of product or solution life cycle.

· Perform data analysis, handle data modeling, and configure and develop data pipelines to move and optimize data assets.

· Build moderately complex prototypes to test new concepts and provide ideas on reusable frameworks, components and data products or solutions and help promote adoption of new technologies.

· Independently solve moderately complex issues with minimal supervision, while escalating more complex issues to appropriate staff.

· Other duties as assigned

Qualifications

MINIMUM QUALIFICATIONS

· Bachelor’s degree in a related field or equivalent experience

· Minimum of two years of related work experience

· Other minimum qualifications may apply

PREFERRED QUALIFCATIONS

· Experience developing modern data architectures, including data warehouses, data lakes, data meshes, hubs and associated capabilities including ingestion, governance, modeling, observability and more.

· Experience with data collection and ingestion capabilities, including AWS Glue, Kafka Connect and others.

· Experience with data storage and management of large, heterogenous datasets, including formats, structures, and cataloging with such tools as Iceberg, Parquet, Avro, ORC, S3, HFDS, HIVE, Kudu or others.

· Experience with transformation and modeling tools, including SQL based transformation frameworks, orchestration and quality frameworks including dbt, Apache Nifi, Talend, AWS Glue, Airflow, Dagster, Great Expectations, Oozie and others

· Experience working in Big Data environments including tools such as Hadoop and Spark

· Experience working in Cloud Platforms including AWS, GCP or Azure

· Experience of streaming and stream integration or middleware platforms, tools, and architectures such as Kafka, Flink, JMS, or Kinesis.

· Strong programming knowledge of SQL, Python, R, Java, Scala or equivalent

· Proficiency in engineering tooling including docker, git, and container orchestration services

· Strong experience of working in devops models with demonstratable understanding of associated best practices for code management, continuous integration, and deployment strategies.

· Experience and knowledge of data governance considerations including quality, privacy, security associated implications for data product development and consumption.

Equal Opportunity Employer, including Disability/Vet.

Create and maintain database tables, views, indexes, and triggers.

Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.

Develop and maintain high-quality stored procedures.

Write low cost, high-quality database queries and code while maintaining data quality, privacy, and security

Profile databases, measure database performance and troubleshoot complex database issues, and IO bottlenecks.

Optimize database queries and ensure table locking/deadlocks happen in production.

Optimize large, complicated SQL statements & Stored Procedures.

Cost optimization of Amazon instances using databases.

Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels

Knowledge of message queuing, indexing, and high-performance data concept

Knowledge of JSON and PostgreSQL support for JSON.

Good Grasp of ETL concepts

Work with front-end developers to define simple yet powerful APIs

Work with DBAs to ensure the efficiency of database code, integrity of data structures and quality of data content.

Coordinate with product managers and leadership teams to build effective database objects

Excellent verbal and written communication skills

Good attitude towards work and flexibility

Ability and willingness to handle multiple tasks in a fast-paced environment

Ability to evaluate alternative solutions and/or workarounds

• Minimum of 1+ years PHP web development experience
• As a PHP developer your duties would primarily consist of developing new projects built using PHP-based frameworks/platforms, writing custom code, and architect new solutions for prospective clients.
• Expert with PHP object-oriented programming & MVC applications
• Familiarity with automated deployment strategies
• Solutions-oriented thinking; always looking for the smart solution to a problem rather than jumping at the first answer
• Salary is negotiable depending on the experience

SAP HYBRIS

Skill Set:

• SAP Hybris platform with 3 -10  years of IT experience and  min of 4 years of experience in leading SAP Hybris based projects.
• Hands on experience in understanding complex eCommerce challenges / problems and provide innovative solutions & design to solve them.
• Mentors team members and should be able to pass on solutions / design to junior team members while fascinating them in delivering complex deliverables
• Excellent knowledge and experience in building scalable, flexible, robust and efficient ecommerce applications using SAP Hybris ecommerce  platform
• Architecture, design & develop full stack modules and components for eCommerce applications.
• Good working knowledge on integrations such as Data Hub, payment, SAP, web services, y2y sync etc
• Migration experience is desirable
• Deliver code on time and quality expectations
• Experience on code review and unit testing
• Certification in SAP Hybris is a plus
• Knowledge of any additional technologies such as Groovy,  SAP ECC ERP application integrations
• Familiar in estimation techniques and execution plan
• Experience in Agile / Scrum based software development methodology