The Data Engineer is responsible for the development, maintenance, improvement, cleaning, and manipulation of data in data pipelines.

The remarkable rise in social media usage has ushered in a growing accumulation of both structured and unstructured data from various formats, such as pictures, videos, sounds, text and geolocations.

 

Social media has progressed to become a critical driver for collecting and spreading information across sectors like entertainment and media, journalism, business, politics, and science. This growth opens up new potential for analysis and pattern discovery that provide insights into key challenges, trends, influences, and market and social changes. 

 

Edelman Digital Advisory is on a journey to create a unique yet advanced marketing analytics tool/platform that harness these huge amounts of data from external sources, syndicated third party databases, client’s platforms.

 

To be an integral part of this journey, we are looking to onboard an analytics professional as an Analyst-Data Engineer who will work to understand and aid in the implementation of database requirements, tease out analytics challenges and work in close collaboration with all business stakeholders to ideate, develop, implement and maintain Edelman Digital Advisory offerings.

What will you do?

The Data Engineer has to be an expert in SQL development further providing support to the Data and Analytics in database design, data flow and analysis activities. You will play a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing.You will define and build the data pipelines that will enable faster, better, data-informed decision-making within the business.Management: You will work closely with other data professionals with specific roles in the data pipeline by focusing on creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across platforms.In this capacity, you will be responsible for enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to MySQL. 

Analytics: As part of Edelman Digital Advisory, you inherently have an analytical role where you have to perform ad-hoc analyses of data stored in the business’s MySQL/MS SQL databases and write SQL scripts, stored procedures, functions, and views. Utilize various Application Programming Interface (API) services to collect data from different social media sources such as but not limited to YouTube, Twitter, Instagram, Meta.

Who we are looking for?

Experience: At least 2 years of working experience as a database engineering support personnel or a database engineering administrator within a fast-paced a complex business setting. The candidate will also have had experience working with MySQL databases and Microsoft SQL.

Technical expertise: The candidate must demonstrate experience working with large and complex data sets as well as experience analyzing volumes of data through basic Microsoft Excel functions, for example, macros and pivot tables.The Data Engineer must also have exceptional analytical skills, showing fluency in the use of tools such as MySQL and strong Python, Shell, Java, PHP, and T-SQL programming skills.The candidate must additionally be capable of developing databases using SSIS packages, T-SQL, MSSQL, and MySQL scripts.The candidate will also have the ability to design, build, and maintain the business’s ETL pipeline and data warehouse.The candidate will also demonstrate expertise in data modelling and query performance tuning on SQL Server, MySQL, Redshift, Postgres or similar platforms.Communication

Skills: You must convey messages and instructions clearly to the supporting personnel in order to ensure efficient execution of duties.

Edelman is a global communications firm that partners with businesses and organizations to evolve, promote and protect their brands and reputations. Our 6,000 people in more than 60 offices deliver communications strategies that give our clients the confidence to lead and act with certainty, earning the trust of their stakeholders. Our honors include the Cannes Lions Grand Prix for PR; Advertising Age’s 2019 A-List; the Holmes Report’s 2018 Global Digital Agency of the Year; and, five times, Glassdoor’s Best Places to Work. Since our founding in 1952, we have remained an independent, family-run business. Edelman owns specialty companies Edelman Data & Intelligence (DxI) and United Entertainment Group (entertainment, sports, lifestyle).

For more information please visit: www.edelman.com

 

Click here to view a short video about life at Edelman.