Analyst, Data Engineering

Company Description

At Publicis LifeSpeed, it is both our model and culture to establish fully integrated cross-discipline teams that put our clients wholly at the center and enable us to provide best-in-class services in a fluid and modular way. Publicis LifeSpeed uses living data to create brand movements at the speed of people’s lives. We move faster, create movements, and deploy real time data that connects world class creative to content and media in service of growth and ROI.

As part of Publicis Media, our leadership is defined by experience, commitment, and continuity across our vast network. Helming our agencies and teams are some of the most seasoned experts in the industry, committed to doing the best for our people and our clients every day, and bound together by our inclusive and humane culture. No matter whether we’re recruiting new talent or devising new media campaigns for our clients, we put the humanity and identity of real people at the forefront of everything we do. And our peerless history of continuous learning and innovation means we never stand pat.

Publicis Media is the #1 media network in North America, made of a family of world-class media agencies, solutions, and talent. Together, we comprise more than 23,000 people in more than 60 countries, united to serve the world’s best-known and most successful brands.

Job Description

The Analyst plays a key role in the client data onboarding process by supporting business solutions that accurately stores data over time and allows the Tech and Data team to build and improve the PHM media optimization methodology. The variety of platforms and information available today requires careful planning and discipline to optimize performance at scale.  The agency environment provides a variety of situations that requires weighing multiple options to solve technical problems. 

  

Key Responsibilities:

• Develop technical execution requirements based on specifications 

• Produce quality technical and business process models for enterprise-wide data integration incorporating: 

  • Structured and unstructured data 

  • Real time, on-demand, batch and varying timing schedules 

• Monitor the original requirements throughout quality assurance testing and implementation to ensure that they are effectively delivered 

• Review systems and report inefficiencies and improvement areas to the business process 

  • Ensure issues are identified, tracked, reported on and resolved in a timely manner 

  • Understands how to communicate difficult/sensitive information tactfully and effectively 

  • Comfortable in developing options and present alternatives 

• Data management functions including: 

  • Metadata management 

  • Capacity planning 

  • Query tuning 

  • ETL 

• Tools Utilized: 

  • Excel VBA, Power Query, macro experience 

  • SQL Server/SSIS/Visual Studio/Source Control 

  • Cloud Technologies – AWS, Azure, Google 

Qualifications

 

• Bachelor's Degree in in Computer Information Systems, IT, Business, Marketing, or related field of study   

• Minimum 1 year of work experience in Information Technology Systems Analysis or equivalent combination of education and experience 

• Experience with Data Warehousing technologies, development and management 

• Knowledge of Microsoft SQL and how to write SQL queries 

• Experience working in a Software Development and support environment a plus 

• Flexible/adaptable/approachable and willing to work in rapidly changing, and high delivery environment 

• High attention to detail and ability to audit for data anomalies and trends 

• Ability to independently investigate and resolve issues – critical thinker 

• Experience with Mongo, Hadoop, Hive, Spark, Presto, Pig and NoSQL are a strong plus 

Additional Information

All your information will be kept confidential according to EEO guidelines.

Compensation Range: $52,500 - $80,000 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.