Sales and Marketing Intern

* Python (3 to 6 years): Strong expertise in data workflows and automation

* Spark (PySpark): Hands-on experience with large-scale data processing

* Pandas: For detailed data analysis and validation

* Delta Lake: Managing structured and semi-structured datasets at scale

* SQL: Querying and performing operations on Delta tables

* Azure Cloud: Compute and storage services

* Orchestrator: Good experience with either ADF or Airflow

Role Description

We are seeking an experienced and strategic Project Head – Marketing to lead the marketing and

launch activities of real estate projects in Pune. This role demands a strong network of media

vendors, sharp media planning capabilities, excellent vendor management skills, and an innovative

approach to promotions, budget optimization, and brand visibility. The role will involve collaborating

with cross-functional teams to ensure marketing efforts align with business objectives.

Key Responsibilities:

 Project Launches:

Drive end-to-end marketing strategies for new real estate project launches, ensuring

maximum visibility and lead generation.

 Media Planning & Vendor Management:

Plan, negotiate, and execute 360° media campaigns (offline & online) through a strong

network of media vendors in Pune. Drive 360-degree marketing campaigns including digital,

ATL, BTL, and influencer marketing.

 Network Development:

Build and maintain strong relationships with media houses, influencers, celebrity management

agencies, and promotional partners.

 Budget Planning & Cost Management:

Prepare, allocate, and manage marketing budgets efficiently, ensuring optimum returns on

investment.

 Creative Oversight:

Provide creative direction in advertising, branding, and campaign design; ensure design

aesthetics align with brand guidelines and market expectations.

 Negotiation & Procurement:

Lead negotiations with vendors, media partners, and promotional agencies to secure

competitive pricing and service excellence.

 Cross-functional Coordination:

Collaborate with sales, design, digital, and external agencies to ensure seamless execution of

marketing initiatives.

 Performance Tracking:

Monitor and report on campaign performance, visibility metrics, and lead generation

outcomes.

Key Skills & Competencies:

 Proven experience in real estate project launches.

 Strong network of media vendors in Pune (essential requirement).

 Knowledge of media houses, influencer marketing, and celebrity engagement strategies.

 Expertise in budget planning, media buying, and cost optimization.

 Strong creative sensibility for ad layouts, creatives, and media placements.

 Excellent negotiation, communication, and project management skills.

 Ability to multitask and handle multiple projects simultaneously under tight deadlines.

Candidate Profile:

 Experience: 4+ years in real estate marketing or large-scale event/media management

(Pune market experience preferred).

 Education: Bachelor’s degree in marketing, Mass Communication, Business Administration,

or related field. MBA preferred.

 Location Flexibility: Based in Pune with local market expertise.

 Personal Traits: Dynamic, detail-oriented, proactive, strong leadership and interpersonal

skills.

•      Job Responsibilities:
  • Handling inbound and outbound call
  • Ability to assess customer needs and respond to them.
  • Match customer needs with vendor availabilty
  • payment assistance to cutomer
  • Proficient with Microsoft Office. Word, excel
  • Key Skills:
    • Great command over English and Hindi
    • Comfort with medical and fitness terminology
    • Ability to work in tight schedules
    • Ability to work independently
    • Experience in customer service or call centre background preferrred

• Developing new user-facing features using React.js.
• Build reusable components and front-end libraries for future use.
• Translate designs and wireframes into high-quality code.
• Optimize components for maximum performance across a vast array of web-capable devices and browsers.
• Design a modern highly responsive web-based user interface.

Skills and Competencies;

• Bachelor's degree in computer science preferred.
• 3-5 years of demonstrated experience.
• Good knowledge of HTML5, CSS3.
• Strong proficiency in Javascript.
• Strong working knowledge of React JS and web apps.
• Good working experience using API in UI development.
• Should be able to do responsive design and cross-browser compatibility.
• Willingness to experiment and take complete responsibility for projects.
• Work independently and remote, with excellent follow-up, time management, and organization skills.
• Any additional knowledge of/familiarity with programming, in general, would be a great added bonus.
• Knowledge of Jira/confluence.
• Familiarity with code versioning tools such as Git.
• A team player with a problem-solving aptitude.
• Fluent in a second language preferred, good level of verbal English required.

• Expertise in designing and implementing enterprise scale database (OLTP) and Data warehouse solutions.
• Hands on experience in implementing Azure SQL Database, Azure SQL Date warehouse (Azure Synapse Analytics) and big data processing using Azure Databricks and Azure HD Insight.
• Expert in writing T-SQL programming for complex stored procedures, functions, views and query optimization.
• Should be aware of Database development for both on-premise and SAAS Applications using SQL Server and PostgreSQL.
• Experience in ETL and ELT implementations using Azure Data Factory V2 and SSIS.
• Experience and expertise in building machine learning models using Logistic and linear regression, Decision tree  and Random forest Algorithms.
• PolyBase queries for exporting and importing data into Azure Data Lake.
• Building data models both tabular and multidimensional using SQL Server data tools.
• Writing data preparation, cleaning and processing steps using Python, SCALA, and R.
• Programming experience using python libraries NumPy, Pandas and Matplotlib.
• Implementing NOSQL databases and writing queries using cypher.
• Designing end user visualizations using Power BI, QlikView and Tableau.
• Experience working with all versions of SQL Server 2005/2008/2008R2/2012/2014/2016/2017/2019
• Experience using the expression languages MDX and DAX.
• Experience in migrating on-premise SQL server database to Microsoft Azure.
• Hands on experience in using Azure blob storage, Azure Data Lake Storage Gen1 and Azure Data Lake Storage Gen2.
• Performance tuning complex SQL queries, hands on experience using SQL Extended events.
• Data modeling using Power BI for Adhoc reporting.
• Raw data load automation using T-SQL and SSIS
• Expert in migrating existing on-premise database to SQL Azure.
• Experience in using U-SQL for Azure Data Lake Analytics.
• Hands on experience in generating SSRS reports using MDX.
• Experience in designing predictive models using Python and SQL Server.
• Developing machine learning models using Azure Databricks and SQL Server

Responsibility:

• Building user friendly Android and iOS Apps on React Native platform.
• Designing state-less components in React Native. State management with any of Redux, mobX or Flux.
• Writing modular, reusable, maintainable, well documented and fully tested code.
• Converting designs to mobile applications.
• Integrating with Rest APIs, while collaborating with Backend deve.
• Take complete ownership of the apps and change various elements/ technologies as per business need.
• Ensure optimum speed, performance, quality and responsiveness of application