Senior Data Analyst (Marketing)

Stations in Oregon include network affiliates and independent stations. Corporate functions, including digital product and ad operations, are based in Portland. Breaking news means staying late, and comp time makes up for it.

Role overview:

The Finance team needs someone who can write SQL, build dashboards and explain what changed and why. Trestleflow Media is hiring for the Senior Data Analyst (Marketing) role to answer business questions with data and turn the answers into reports people actually use. Remote within the US. The team meets in Portland once a quarter, travel covered. Monday to Friday, regular working hours, flexible start and finish. Strong written English is important, since much of our work is async.

Job duties:

• Field ad hoc requests through a ticket queue and prioritize them with your manager
• Present results to managers and answer follow-up questions
• Automate recurring Excel reports with Power Query, Python or scheduled SQL
• Define metric logic with stakeholders and document it
• Create forecasts and simple models in Excel or Google Sheets
• Investigate data quality issues and work with data engineering to fix them at the source
• Prepare weekly and monthly KPI reports for department leads
• Track sales, inventory or service levels against targets and flag misses early

What you need:

• 6+ years of experience in a data or reporting analyst role
• Able to juggle several requests and say when a deadline isn't realistic
• Habit of checking your own numbers before anyone else sees them
• Bachelor's degree in statistics, economics, business, math or a related field
• Clear written and verbal communication with non-technical stakeholders
• Advanced Excel: pivot tables, XLOOKUP, Power Query

Nice to have:

• Tableau Desktop Specialist or Microsoft PL-300 certification
• Python (pandas) or R for analysis
• Google Analytics 4 or Adobe Analytics

$59.00 - $65.00 an hour

Compensation and benefits:

• Home office stipend

Trestleflow Media provides equal employment opportunities to all employees and applicants.

We review applications on a rolling basis.

Interview process: a phone call, a meeting with the hiring manager, and a final conversation with the team.

Duration: 6 months. Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Trestleflow Media.