IPG Media Brands
Analyst, Campaign Insights
IPG Media Brands, Boston, Massachusetts, us, 02298
Analyst, Campaign InsightsLocation:
Boston, Massachusetts, United States
Agency:
Mediahub - United States
Ref#:
11362
Job Function:
Data & Analytics
Type of Contract:
RegularBusiness OverviewMediahub is one of the three major global media agencies within IPG Mediabrands with over 1000+ employees worldwide. We are an award-winning agency built for brands who are challenging and disrupting the status quo. Our organization is focused on challenging all facets of media in an environment of rapid change in order to maximize our clients' investments. We are challenging key fundamentals in the areas of audience creation, purpose, creativity and digital platforms.Named Media Agency of the Year by Adweek, Ad Age, and Campaign, Mediahub is powered by the buying and intelligence power of Magna Global and the data backbone of Acxiom.
Position OverviewThe Campaign Insights team partners with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending. The Analyst is responsible for gathering and preparing data and conducting analyses using various tools in support of the delivery of analytic solutions. The Analyst will have a basic understanding of the digital and media ecosystems including primary channels, digital tracking and large media platforms, and privacy requirements in media tracking. The position will develop a basic understanding of a client's industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs.
ResponsibilitiesCollaborate with internal/external stakeholders on data logistics - including data specifications, structures, rules, and transfers from numerous media channels and partners.Access collected data and thoroughly QC and prepare the data to conduct various analysis and reporting leveraging SQL, Excel, or Tableau.Exhibit an ability to interpret/synthesize analysis findings and draw insights pertinent to the client's business.Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables.Answer questions about data sets and analyses and maintain project documentation.Document and articulate steps taken in an analysis to project managers.In addition to the execution of projects, begin to participate in project design and planning.
Qualification - Required SkillsDemonstrated base level of proficiency with at least two of the following tools - SQL, Excel, Tableau
SQL - De-duplicate data in database tables using queries, leverage database functions to calculate metrics, and join tables.Excel - Use functions such as VLOOKUP, XLOOKUP to correct data, use SUMIFS, SUMPRODUCT, etc. to create reports, and create pivot tables to summarize data.Tableau - Create basic calculated fields and basic visualizations such as tables and bar charts and create dashboards that convey basic information and publish to a Tableau Server.
Working knowledge of MS Office; including PowerPoint, Word and Excel.Acute attention to detail (QA/QC).Strong analytic thought process.Good verbal and written communication skills.Motivated and collaborative team player with strong interpersonal skills.Familiarity with various online and offline media channels.Mediahub does not require candidates to have a college degree.
Qualifications - Desired SkillsUp to 2 years of experience (including internships) in a professional services or corporate environment; prior media analytics experience/knowledge desired.Advanced degree typically in a quantitative discipline desired.Ability to program in other languages such as SAS, SPSS, R and/or Python desired.
Wage and BenefitsWe 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 TransparencyIt 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 accommodation@mbww.com.
Salary Range$70,000 - $80,000 USD
#J-18808-Ljbffr
Boston, Massachusetts, United States
Agency:
Mediahub - United States
Ref#:
11362
Job Function:
Data & Analytics
Type of Contract:
RegularBusiness OverviewMediahub is one of the three major global media agencies within IPG Mediabrands with over 1000+ employees worldwide. We are an award-winning agency built for brands who are challenging and disrupting the status quo. Our organization is focused on challenging all facets of media in an environment of rapid change in order to maximize our clients' investments. We are challenging key fundamentals in the areas of audience creation, purpose, creativity and digital platforms.Named Media Agency of the Year by Adweek, Ad Age, and Campaign, Mediahub is powered by the buying and intelligence power of Magna Global and the data backbone of Acxiom.
Position OverviewThe Campaign Insights team partners with both internal and external stakeholders and data providers, leveraging analytics and measurement to enable optimization of media spending. The Analyst is responsible for gathering and preparing data and conducting analyses using various tools in support of the delivery of analytic solutions. The Analyst will have a basic understanding of the digital and media ecosystems including primary channels, digital tracking and large media platforms, and privacy requirements in media tracking. The position will develop a basic understanding of a client's industry, business objectives and strategy, media plans, and consumer journey to provide context for analysis and reporting needs.
ResponsibilitiesCollaborate with internal/external stakeholders on data logistics - including data specifications, structures, rules, and transfers from numerous media channels and partners.Access collected data and thoroughly QC and prepare the data to conduct various analysis and reporting leveraging SQL, Excel, or Tableau.Exhibit an ability to interpret/synthesize analysis findings and draw insights pertinent to the client's business.Prepare basic report content (Word, Excel, PowerPoint) in support of deliverables.Answer questions about data sets and analyses and maintain project documentation.Document and articulate steps taken in an analysis to project managers.In addition to the execution of projects, begin to participate in project design and planning.
Qualification - Required SkillsDemonstrated base level of proficiency with at least two of the following tools - SQL, Excel, Tableau
SQL - De-duplicate data in database tables using queries, leverage database functions to calculate metrics, and join tables.Excel - Use functions such as VLOOKUP, XLOOKUP to correct data, use SUMIFS, SUMPRODUCT, etc. to create reports, and create pivot tables to summarize data.Tableau - Create basic calculated fields and basic visualizations such as tables and bar charts and create dashboards that convey basic information and publish to a Tableau Server.
Working knowledge of MS Office; including PowerPoint, Word and Excel.Acute attention to detail (QA/QC).Strong analytic thought process.Good verbal and written communication skills.Motivated and collaborative team player with strong interpersonal skills.Familiarity with various online and offline media channels.Mediahub does not require candidates to have a college degree.
Qualifications - Desired SkillsUp to 2 years of experience (including internships) in a professional services or corporate environment; prior media analytics experience/knowledge desired.Advanced degree typically in a quantitative discipline desired.Ability to program in other languages such as SAS, SPSS, R and/or Python desired.
Wage and BenefitsWe 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 TransparencyIt 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 accommodation@mbww.com.
Salary Range$70,000 - $80,000 USD
#J-18808-Ljbffr