Paid Media Analyst

TruGreen Limited Partnership; Franklin (TN); Hybrid; USD 54,000 - 92,000; Full time

Benefits offered by this job

Medical/Dental/Vision

401(k) with company match

Job summary

TruGreen is seeking a Marketing Analyst in Franklin, Tennessee to research market trends, analyze campaigns, and provide insights that guide direct marketing programs.

You will build dashboards using SQL and Access, develop attribution models, and collaborate with the digital marketing team to support data-driven decisions.

Qualifications

• Bachelor’s degree in related field and 1–2 years marketing analysis experience or equivalent
• Strong analytical and data interpretation skills
• Experience using SQL and Access for reporting

Responsibilities

• Gathers, interprets, integrates and manages large-scale internal data for reporting needs using SQL and Access
• Develops daily and weekly dashboards to track performance and growth of all direct marketing programs
• Creates sales attribution model for direct marketing campaigns and interpret the results
• Analyzes and verifies data to ensure accuracy of direct mail/email campaigns
• Collaborates with digital marketing team and other internal stakeholders for ad hoc analyses
• Analyses website and sales data to identify market and product trends
• Develops tactics and analyzes metrics to assess the effectiveness of existing marketing programs

Skills

SQL

Data analysis

Dashboard reporting

Marketing analytics

Excel

SAS programming

Communication

Team collaboration

Education

Bachelor’s degree in Business/Marketing/Math/Stats/Economics/IT

Tools

SQL

Access

Excel

PowerPoint

SAS

Job description

101954701 Cool Springs Blvd, Franklin, Tennessee 37067

TruGreen accepts applications on an ongoing basis.

Job Description

TruGreen is committed to providing personalized attention for our associates. We focus on developing our people by building proud, dynamic teams while helping associates reach their personal and professional goals. We continuously strive to make TruGreen an employer of choice and "a great place to work!"

Position Overview

Responsible for the research, analysis and insights regarding the market trends and competitors, potential and existing customers, and current campaign performance.

Responsibilities

• Gathers, interprets, integrates and manages large-scale internal data for reporting needs using SQL and Access
• Develops daily and weekly dashboards to track performance and growth of all direct marketing programs
• Creates sales attribution model for direct marketing campaigns and interpret the results
• Analyzes and verifies data to ensure accuracy of direct mail/or email campaigns
• Collaborates with digital marketing team and other internal stakeholders for ad hoc analyses to help make informative business decisions
• Analyses website and sales data to identify market and product trends
• Develops tactics and analyzes metrics to assess the effectiveness of existing marketing, advertising, and communications programs

Education and Experience Requirements

• Bachelor’s degree in Business, Marketing, Math, Statistics, Economics, IT or related field required, and 1-2 years for marketing analysis experience required or an equivalent combination of education and experience

Knowledge, Skills, and Abilities

• Negotiation and influencing skills
• Business and financial acumen
• Organizational, project and process management and leadership skills
• Written and verbal communication skills, including delivering presentations
• Business process analysis skills
• Attention to detail and quantitative analytical skills
• Ability to operate independently and collaboratively within a team
• Computer skills with Microsoft Office applications (Word, Excel, Outlook, PowerPoint)
• SAS Programming knowledge and data analytic support abilities including data extraction, cleansing, match/merging and loading processes.
• Deep knowledge and hands-on experience with at least one database, ideally SQL server

Physical Demands & Working Conditions

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Regularly required to:

• Sit, stand and walk
• Use hands and arms to handle, feel or reach
• Speak and hear
• Use close vision abilities

Occasionally required to:

• Lift or move up to 25 lbs
• Stoop, kneel, crouch or crawl

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job.

Noise level

• Low to moderate

Adverse Conditions

• Minimal

TruGreen is committed to Diversity and Inclusion. We encourage diverse candidates to apply to this position.

We are an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities.

To learn more copy and paste this URL into your browser: www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf

TruGreen performs pre-employment testing.

Ability to speak, read and write fluently in English is required.

You MUST BE physically located in the United States while performing this job.

TruGreen is proud to affirm our commitment to hiring veterans. We recognize and appreciate the exceptional skills, dedication, and leadership that veterans bring to the workforce. By fostering an inclusive and diverse environment, we aim to leverage the unique experiences of veterans, creating a richer, more dynamic workplace.

Pay Ranges

$54,983.00 - $91,638.00

This range is based on the qualifications necessary for the position, including experience, training, and other considerations permitted by law. Factors that may be used when making an offer may include a candidate’s skills, experience, and geographic location, the expected quality and quantity of work, and internal pay alignment, as needed. Most candidates will start in the bottom half of the pay range. The upper end of the range will generally be reserved for candidates with extensive experience. An employee’s pay history will not be a contributing factor where prohibited by local law. In addition to monetary compensation, we offer benefits, including

• Medical/Dental/Vision
• insurance and Company-matching 401(k) in addition to other programs and perks.

TruGreen is committed to Diversity and Inclusion. We encourage diverse candidates to apply to this position.

We are an Equal Opportunity/Affirmative Action Employer - Minorities/Females/Protected Veterans/Individuals with Disabilities. To learn more, please visit EEOC/EEO | TruGreen (trugreenjobs.com).

California Residents: When you express interest in or apply for a job with TruGreen Limited Partnership, we collect personal information about you, potentially including personal identifiers, contact information, protected classifications, pre‑hire information, professional or employment‑related information, education history, and/or medical information, for the following business purposes: to comply with state and federal law and regulations requiring employers to maintain certain records; to evaluate your job application and candidacy for employment; and to obtain and verify background checks (including criminal and motor vehicle records), pre‑employment drug testing, and references.

Massachusetts Residents: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

TruGreen performs pre‑employment testing.

To view our disclaimer, https://trugreenjobs.com/us/en/disclaimer