Job Description

Company Description

Both Performance Collective and PHM sit under the Publicis Media pillar, which is a collective group of agencies that specifically focus on Media advertising under the Publicis Groupe network. Within this collection of agencies as well as the broader network, we are uniquely positioned to not only deliver innovation to our clients as we partner together but also deliver the best-in-class opportunities and benefits to our employees. We deliver the atmosphere of a startup company, with the stability of having a parenting company in Publicis Groupe. As you can see, we are growing; in the past year alone, we have hired 1/3 of our current workforce. Currently, we operate out of four locations across the US which are New York, Chicago, Detroit, Philadelphia, and Los Angeles. LifeSpeed in particular will be based out of our New York office.



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.

Publicis Groupe