Data Analyst, Execution Marketing

Ocean Network Express • Richmond, VA

1d • $50,000 - $65,000 • Hybrid

About The Position

The Data Analyst - Execution Marketing position transforms complex, raw business data into clear, actionable insights through intuitive dashboards and self-service analytics models. The role uses SQL and Looker to design dynamic dashboards that help cross-functional teams make faster, data-driven decisions.

The position builds and maintains Looker dashboards, LookML models, and BigQuery queries; works with stakeholders to translate business questions into technical requirements; and analyzes business performance, operational trends, and key metrics. It also monitors dashboard performance and data accuracy, optimizes query efficiency and cost, and creates lightweight automated workflows using Google Apps Script.

This position follows a hybrid work schedule, with at least three days in the office and two days remote each week.

Requirements

• Advanced proficiency in SQL, including joins, CTEs, window functions, and aggregation, with direct experience using Google BigQuery.
• Hands-on experience incorporating AI tools into daily workflows.
• Extensive knowledge of data investigation and analysis, data extraction, and report and visualization creation.
• Advanced knowledge of Google Sheets, Microsoft Excel, or similar tools for data manipulation using functions.
• Experience with analysis tools such as Google Workspace and/or Looker or Looker Studio.
• Ability to data model and create new data sets.
• Self-starting and highly motivated, with a creative, strongly analytical, and curious mindset.
• Ability to evaluate data, analyze, and solve problems.
• Innovative and change-oriented, with the ability to drive and influence change.
• Ability to collaborate effectively, multitask, and prioritize.
• Ability to learn software and systems within a short period of time.
• Ability to communicate and interact effectively with individuals across departments and all levels, from staff to senior management.
• Strong written, verbal, interpersonal, and presentation skills.
• A minimum of three years in the shipping/logistics industry is preferred but not required.

Nice To Haves

• Exposure to or knowledge of programming languages such as Python, JavaScript, or SQL.
• A minimum of three years in the shipping/logistics industry.
• Bachelor’s degree.

Responsibilities

• Build, deploy, and maintain automated, user-friendly Looker dashboards and reports tailored to business stakeholders.
• Develop and maintain scalable LookML models, explores, and measures to enable self-service analytics across the organization.
• Write, optimize, and maintain complex SQL queries in Google BigQuery to aggregate, clean, and model data from multiple business sources.
• Partner with cross-functional teams to gather requirements and translate business questions into technical data requirements.
• Monitor dashboard performance, audit data accuracy, and ensure queries run efficiently in BigQuery to manage costs and response times.
• Conduct deep-dive analyses of business performance, operational trends, and key metrics to support strategic initiatives.
• Create lightweight automated workflows using Google Apps Script to reduce manual reporting tasks.

What This Job Offers

• Job Type: Full-time