Business Overview 

We are IPG Mediabrands, a client-first, consulting-led, community-driven group of media and marketing specialists around the world on a mission to ensure our clients win in the marketplace. Through our portfolio of brands, and culture of collaboration, we offer the media and marketing capabilities it takes to invest smarter and grow our client’s businesses now and in the future. Through our diverse community of people and leaders, we offer teams of experts who thrive in a culture of excellence and equity. Through our commitment to brand values and media responsibility, we offer leadership to help our clients always act in the best interests of the communities they serve.  

Position Summary:

We are looking for a Senior Analyst to join our Data and Technology team with the Client Solutions, Analytics group at BPN- Part of Initiative. A successful candidate should be a self-motivated curious learner, with strong skills across key cloud database buildout and reporting technologies including SQL, Snowflake, Tableau as well as coding with Python and or R.

You will be critical in helping establish a suite of automation tools & products for a large pharmaceutical client. Curiosity and passion for automation, data management, digital data, and new technologies, is a must!

Primary day to day tasks will include working with teams across Mediabrands to gather requirements and articulate schematics to represent the logical and physical structure of a data warehouse including tables, field specifications and data relationships.

A successful candidate will have a wide variety of skills in media, technology, data, and cross team management.

Key Responsibilities:

Essential Functions:

• Collaborate with other company teams to identify existing procedures and identify areas for automation / improvement
• Collaborate with stakeholders and users to define and prioritize needs across the company
• Contribute to designing major programming & buildout blueprints and executing development work on said requirements
• Assist translating high-level requirements into detailed user stories and use cases that design, and development teams can easily implement.
• Contribute to certain strategic planning activities and operational improvement initiatives.
• Assist developing standard operating procedures and training materials, and be the subject matter expert to provide demos, education and training to drive adoption of the product.

Required Skills & Experience:

• Strong verbal and communications skills
• Superior analytical, evaluative, and problem-solving abilities.
• 1-2+ Years experience in data hygiene and quality assurance processes
• 1+ years of programming and/or automation development work
• 1-3+ years’ experience with Snowflake, SQL Server, Jupyter Notebook or other database querying interface
• Fundamentals of database structure: Able to articulate the logical and physical structure of a data warehouse and create schematics across tables to link and represent data relationships
• Comfortable contributing to design and execution data modeling
• Intermediate level SQL experience
• Excellent organizational skills; capacity to manage multiple priorities and tasks simultaneously and communicate with all levels of management

Desired Skills & Experience:

• 1-2+ Years experience in Life Science, Media or regulated markets (Financial, Insurance, Pharmaceuticals, Biotech)
• Experience with advertising technologies or operations (media planning, buying, reporting) is a plus
• Experience working with data from digital channels (Google DCM, Meta platforms, Adwords, SA360, Adobe Analytics, Google Analytics is a plus

What to Expect (Day to day)

• Fun environment with lots of professionals in a major metropolitan environment including team building events, company celebrations and Pizza Wednesdays
• In NYC office 3 days per week
• Lots of data wrangling, inspecting for quality, anomalies, investigations and contributing to standard operating procedures to prevent data quality issues
• Learning new applications including AI to automate and improve efficiency of QC
• Answering questions from colleagues and clients about data anomalies
• Requests for cuts of data from large datasets
• Collaborative environment where you sit with and work in close proximity to your colleagues

We See You  

At IPG Mediabrands, we are unified behind a commitment to fostering a culture of inclusion and belonging. Together, we shine through a set of shared values and behaviors. We take pride in our responsibility to our clients, communities, and to each other. We embrace differences and recognize the unique value that each of us brings to our community.  

We encourage you to apply, as unique backgrounds, perspectives, and lived experiences are welcomed.   

We See You at IPG Mediabrands. 

Wage and Benefits

We offer a Total Rewards package that includes medical and dental coverage, 401(k) plans, flex spending, life insurance, disability, employee discount program, employee stock purchase program and paid family benefits to support you and your family. To give you the ability to better meet your personal needs, and in support of your physical and emotional well-being, you will receive discretionary time off days and company-wide Appreciation Weeks and Wellness Days. 

We also offer a competitive Total Compensation package, including a competitive salary and eligibility for an annual discretionary incentive award or a relevant incentive award. 

The salary range for this position is posted below.  Where an employee or prospective employee is paid within this range will depend on, among other factors, actual ranges for current/former employees in the subject position, market considerations, budgetary considerations, tenure and standing with the Company (applicable to current employees), as well as the employee’s/applicant’s skill set, level of experience, and qualifications.   

Employment Transparency

It is the policy of Mediabrands, division of the Interpublic group, to provide equal employment opportunities to all employees and applicants for employment without regard to race, color, ethnicity, gender, age, religion, creed, national origin, sexual orientation, gender identity, marital status, citizenship, genetic information, veteran status, disability, or any other basis prohibited by applicable federal, state, or local law. 

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. 

The employer will make reasonable accommodations in compliance with the American with Disabilities Act of 1990. The job description will be reviewed periodically as duties and responsibilities change with business necessity. Essential and other job functions are subject to modification. Reasonable accommodations may be provided to enable individuals with disabilities to perform the essential functions.  

For applicants to jobs in the United States: In compliance with the current Americans with Disabilities Act and state and local laws, if you have a disability and would like to request an accommodation to apply for a position with Mediabrands, please email [email protected].

About IPG Mediabrands 

IPG Mediabrands is the media and marketing solutions division of Interpublic Group (NYSE: IPG). IPG Mediabrands manages over $47 billion in marketing investment globally on behalf of its clients across its full-service agency networks UM, Initiative and Mediahub and through its award-winning specialty business units Healix, Kinesso, MAGNA, Mediabrands Content Studio, Orion Holdings, Rapport, and the IPG Media Lab. IPG Mediabrands clients include many of the world’s most recognizable and iconic brands from a broad portfolio of industry sectors including automotive, personal finance, consumer product goods (CPG), pharma, health and wellness, entertainment, financial services, energy, toys and gaming, direct to consumer and e-commerce, retail, hospitality, food and beverage, fashion and beauty. The company employs more than 18,000 diverse marketing communication professionals in more than 130 countries. Learn more at www.ipgmediabrands.com.