Position: Public Relation Intern

We are seeking a Public Relations Intern, who is full of creative ideas and eager to contribute on a large scale. The intern will gain visibility into the inner workings and aspects of the public relations field, provide concrete deliverables and learn from top to bottom. When the internship is completed you will be ready to enter any fast paced PR firm and/or PR role in any corporate firm.

Responsibilities

• Create company’s PR strategy and execute it in different phases
• Create and curate engaging content
• Communicate and build relationships with current or prospect clients
• Create and distribute press releases
• Build and update media lists and databases
• Schedule, coordinate and attend various events
• Perform research and market analysis activities

Requirements

• Strong desire to learn along with professional drive
• Excellent verbal and written communication skills
• Efficiency at MS Office
• Passion for the PR industry and its best practices
• Current enrolled/graduated in a related BS or Masters university/college

Perks

• Competitive Stipend
• Start-up working culture experience
• 5 Days a week working schedule
• Working with a high energetic & diverse team having great ideas and experience
• Platform to implement theoretical studies ideas and co-ordinate with core founding team

Opportunity to keep abreast with the latest trends in technologies

Experience Required – 3-5 years

Skillset – 

1. Experience in Azure Databricks platform. Delta lake, Time travel design patterns, Lambda Data Architecture
2. Experience in Azure Cloud Platform. (ADLS, Blob , ADF ).
3. Understanding of big data file formats like JSON, Avro, Parquet and other prevalent big data file formats
4. Experience with Python, PySpark, Scala, Spark to write data pipelines and data processing layers
5. Demonstrate expertise in writing complex, highly-optimized SQL queries across large data sets
6. Experience with Data Governance (Data Quality, Metadata Management, Security, etc.)
7. Strong SQL skills and proven experience in working with large datasets and relational databases.
8. Understanding Data Warehouse design principles (Tabular, MD).
9. Experience in working with big data tools/environment to automate production pipelines
10. Familiarity with Azure Synapse and Snowflake
11. Experience with data visual analysis and BI tools (Matplotlib and Power BI)

Responsibilities – 

1. As a Data Engineer in our team, you should have a proven ability to deliver high quality work on time and with minimal supervision.
2. Developing new data pipelines and ETL jobs for processing millions of records and it should be scalable with growth.
3. Pipelines should be optimised to handle both real time data, batch update data and historical data.
4. Establish scalable, efficient, automated processes for complex, large scale data analysis.
5. Write high quality code to gather and manage large data sets (both real time and batch data) from multiple sources, perform ETL and store it in a data warehouse/data lake
6. Manipulate and analyse complex, high-volume, high-dimensional data from varying sources using a variety of tools and data analysis techniques.
7. Participate in data pipelines health monitoring and performance optimisations as well as quality documentation.
8. Adapt best practices and industry standards, ensuring top quality deliverables and playing an integral role in cross-functional system integration.
9. Data integration using enterprise development tool-sets (e.g. ETL, MDM, Quality, CDC, Data Masking, Quality).
10. Design and implement formal data warehouse testing strategies and plans including unit testing, functional testing, integration testing, performance testing, and validation testing.
11. Interact with end users/clients and translate business language into technical requirem