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:
Python, especially analytical libraries (e.g,. Pandas)
Visual Studio/Source Control
Cloud Technologies – AWS, Azure, Google
BI Platforms – Tableau, PowerBI
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.