Redshift Data Engineer

JOB DETAILS:

Job Role: Assistant Manager / Manager - Retention Marketing

Industry: FMCG

Function: Marketing

Working Day: 5

Work Mode: ONSITE

Salary: Best in Industry

Experience: 3-6 years

Location: Gurgaon

Required Skills: Email Marketing, Retention Marketing

Criteria:

1.The candidate must be currently working in or have previously worked with a D2C startup only

2. The candidate must have 3–6 years of experience only in retention, lifecycle, or CRM marketing.

3. The candidate must have hands-on experience executing CRM campaigns across Email, WhatsApp, SMS, and Push Notifications.

4. The candidate must have built and optimized customer journeys, cohorts, and segmentation within a CRM or marketing automation platform.

5. The candidate must be available for a face-to-face (in-person) interview.

6. The candidate must be currently based in Delhi/NCR only.

7. Only Female candidates are applicable for this role. 

Description

Role Overview: -

We are looking for a Retention Marketing professional who will own the customer lifecycle post-acquisition. The role focuses on improving repeat purchase rate, customer lifetime value (LTV), and reducing churn through data-driven retention strategies across multiple owned channels.

Key Responsibilities: -

• Own end-to-end retention and lifecycle marketing for D2C / e-commerce customers
• Design and execute email, WhatsApp, SMS, push notification campaigns
• Build and optimize customer journeys, cohorts, and segmentation
• Improve repeat rate, LTV, frequency, and retention KPIs
• Plan and execute loyalty programs, referrals, and win-back campaigns
• Collaborate with performance, product, and tech teams for funnel optimization
• Analyze customer behavior and run A/B tests for messaging, offers, and timing
• Own CRM dashboards and reporting on retention metrics

Role & Responsibilities

Lead and mentor a team of data engineers, ensuring high performance and career growth.

Architect and optimize scalable data infrastructure, ensuring high availability and reliability.

Drive the development and implementation of data governance frameworks and best practices.

Work closely with cross-functional teams to define and execute a data roadmap.

Optimize data processing workflows for performance and cost efficiency.

Ensure data security, compliance, and quality across all data platforms.

Foster a culture of innovation and technical excellence within the data team.

Responsibilities:

• Order Generation / Sales in their respective territory and Collection of Outstandings with STUs
• Attending to customer's urgent requirements & Resolving customer complaints
• To ensure segment wise secondary sales growth and maintain dicipline of SPARK reviews across all distributors
• Growth of retail sales revenue by ensuring target achievement for the Area
• Growth of workshop sales revenue by ensuring target achievement for the Area
• Growth of STU sales revenue by ensuring target achievement for the Area
• Ensure SPARK Review Adherence
• Execute activities towards workshop revenue growth and accomplish process adherence
• Growth of Workshop Paid Revenue
• Establish Parts Maturity Index across assigned workshops
• Planning and assisting Workshop Branches in Southern Kerala to establish MSL in co-ordination with Service (incl New Models)
• STU Sales
• Follow up for GRNs & price amendments from STU & Project sectors, Bill preparation, payment follow up and collection, depositing of payments, Money Receipt preparation on time and thereby ensuring outstanding below the committed DSO level
• Purchase Requests generation, RC prices collection, price tabulation, offers submission, order generation etc from STU & project sectors
• MRP updation, Materials follow up, Leyparts Business development through new model parts/kits/aggregates, dissemination of information on Part no. changes & other data, answering all the enquires and coordination among all the depots and branches/Chief OIffice/Central stores in STU & Project sectors
• Update on STU Tenders and loss of sales analysis

MIS & Reports:

• Monthly branch reviews
• AOR & VOR reductions review
• TOC recommendation review with attached dealer outlets and ASCs
• Sales tracker, Stock tracker and dealer profititability review
• MIS of monthly outlook numbers, Sales Coordination activities

Feet on Street Management (DWE):

• Follow up on DWEs along with Service MICs for fleet customers
• BS3 Engine Sale improvements
• Focus on sale improvements in DEF and BSVI filters
• Resolving issues & queries through whatsapp & phone call of all DWEs.

http://getsimpl.com/">Simpl partners with popular online brands and offers their customers the ability to make purchases without paying for them at that very moment.

Over the years, additionally, it has also developed a range of offerings including a one-time checkout feature; Bill Box, which allows customers to automate their recurring expense payouts, and splitting a bill in three parts, to build a “full-stack solution,” said Nitya Sharma, co-founder and chief executive of Simpl, in an interview with TechCrunch.

Some of Simpl’s partners include telecom network Jio Platforms, food delivery service Zomato, pharmacy 1MG, grocer BigBasket and ticketing platform MakeMyTrip.

Know More About Simpl

[ https://techcrunch.com/2021/11/30/india-fintech-simpl-raises-40-million">https://techcrunch.com/2021/11/30/india-fintech-simpl-raises-40-million ]

[ https://getsimpl.com/about-us/">https://getsimpl.com/about-us/ ]

Java 1.8 or later/Golang/Ruby on Rails,
Spring, Spring Boot, Microservices, SQL / NoSLQ , REST APIs , Redis , Kafka, Rabbit MQ, Docker, AWS

B2B / B2C / Cloud (AWS/ GCP) / SAAS Products ,  Software Best Practices , REST / GRPC , Domain Driven Design, Event and Message Driven Systems , Data Structures , Algorithms, OOPS, System Design, JUnit, Mockito, Fitnesse, Cucumber, HTML/ CSS / Javascript, Git , Bitbucket, Maven, Asynchronous / Functional / Reactive Programming in Java

• An Engineering Degree - B.E/B.Tech/MS/PhD in any stream – Computer Science preferred.
• 7-12 years of relevant experience in building highly resilient, highly scalable systems
• Understand the product management space with Agile methodologies.
• Demonstrated end-to-end ownership for development and design of least one cloud-based product - Experience in building microservices / platforms is desirable.
• Strong desire to drive change, and ability to adapt to change quickly. Proficient in new and emerging technologies.
• Ability to balance the long-term “big picture” and short-term implications of design decisions.
• Exceptional communication and interpersonal skills - including negotiation, facilitation, and consensus building skills; ability to influence and persuade, without direct control.
• Mentoring / coaching Junior and Senior Engineers.
• Focus on reusability, frameworks, patterns and configuration tools for faster development.
• Excellent in Engineering excellence – code quality, performance tuning / chaos engineering, operational excellence etc.
• DevOps and TechFinOps mindset to problem solving and product development.

BRIEF DESCRIPTION:

At-least 1 year of Python, Spark, SQL, data engineering experience

Primary Skillset: PySpark, Scala/Python/Spark, Azure Synapse, S3, RedShift/Snowflake

Relevant Experience: Legacy ETL job Migration to AWS Glue / Python & Spark combination

ROLE SCOPE:

Reverse engineer the existing/legacy ETL jobs

Create the workflow diagrams and review the logic diagrams with Tech Leads

Write equivalent logic in Python & Spark

Unit test the Glue jobs and certify the data loads before passing to system testing

Follow the best practices, enable appropriate audit & control mechanism

Analytically skillful, identify the root causes quickly and efficiently debug issues

Take ownership of the deliverables and support the deployments

REQUIREMENTS:

Create data pipelines for data integration into Cloud stacks eg. Azure Synapse

Code data processing jobs in Azure Synapse Analytics, Python, and Spark

Experience in dealing with structured, semi-structured, and unstructured data in batch and real-time environments.

Should be able to process .json, .parquet and .avro files

PREFERRED BACKGROUND:

Tier1/2 candidates from IIT/NIT/IIITs

However, relevant experience, learning attitude takes precedence

Desired Candidate Profile

• Bachelor’s degree in human-computer interaction or Design or Fine Art or Architecture or Engineering or IT technical discipline or in place of 2+ years of internship or 1+ years of industry design experience
• Excellent communication, presentation and organizational skills
• Superlative visual design skills, excellent problem solving skills, and the ability to work well in a collaborative team environment
• Understanding of technical constraints, user goals and business requirements that shape a product
• Ability to work confidently with Program Management, Development, Product Planning, Brand, Marketing and Usability
• Proficiency with Figma or Sketch with an understanding of rapid prototyping platforms such as Invision or Principle
• Experience working within and contributing to a structured design system
• Strong organizational skills and an attention to detail
• Additional proficiency and experience in any of the following skills: information visualization, illustration, motion graphics and animation, video, are not a requirement, but a plus
• Expertise in modern research tools such as Dscout, Qualtrics, UserTesting and/or UserZoom
• User Research experience in a complex space such as enterprise, education or other business/consumer tools and applications    

Oversee the sales process to attract new clients.

Work with senior team members to identify and manage risks.

Maintain fruitful relationships with clients and address their needs effectively.

Research and identify new market opportunities.

Prepare and deliver pitches to potential investors.

Foster a collaborative environment within the organization.

A minimum of 5 years of experience in ASP.Net, MVC, Web Api, AngularJS, C# and SQL Server.

To contribute in the development of all Projects and Modules i.e. Project Documentation, web application development and business implementation.

To work with the internal teams to design, develop and maintain software.

Improve existing software.

• We are looking for an enthusiastic TeleCaller Representative to contribute in generating sales for our company.
• You will be responsible for closing sales deals over the phone and maintaining good customer relationships.
• An effective telesales representative must be an excellent communicator and have superior people skills.
• They must be comfortable presenting products or services over the phone as well as dealing with complaints and doubts.

• The goal is to help the company grow by bringing in customers and developing business.