Avenue7Media is a fast-growing, premier resource for product brand businesses, helping them succeed on Amazon, Walmart, and other eCommerce platforms. We work across teams to make our clients as successful and profitable as possible, and data plays a central role in driving that mission forward.
The Data Analyst plays a vital role in maintaining and enhancing business-critical and client-facing reporting systems. This role supports data-driven decision-making, improves operational efficiencies, and helps build new reports and automations using both internal and external tools. The Data Analyst ensures the accuracy, consistency, and confidentiality of data and enables leadership and operational teams to make informed decisions through timely insights and analysis. The Data Analyst plays a vital role in maintaining and enhancing business-critical and client-facing reporting systems. This role supports data-driven decision-making, improves operational efficiencies, and helps build new reports and automations using both internal and external tools. It requires a strong understanding of data relationships, data modeling, and the ability to write SQL and JSON of varying complexity. The analyst will work across teams to translate business needs into structured queries and build insightful, scalable reports using BI tools such as Looker Studio. Experience with BigQuery and Looker Studio (or similar platforms) is preferred. Familiarity with Amazon’s ecosystem is a significant plus.
Job Responsibilities:
- Data Preparation and Analysis: Collect, organize, and analyze complex datasets; develop dashboards and reports to support internal teams and client needs. Interpret and model data relationships across multiple sources to enable accurate and efficient reporting.
- Trend Identification and Reporting: Generate visualizations (e.g., charts, graphs) to monitor performance indicators, identify trends, and provide actionable insights.
- Process Improvement: Analyze existing workflows and recommend data-driven improvements to enhance operational efficiency.
- Report Building and Automation: Design, build, and automate recurring reports using appropriate tools and platforms to ensure data is accessible, consistent, and efficient. Write complex SQL queries and use JSON where applicable to configure and customize reporting elements.
- Collaboration and Support: Work closely with department managers and stakeholders to understand analytical needs and translate data into meaningful recommendations.
- Data Security and Integrity: Ensure data is accurate, secure, and managed in line with privacy and compliance standards.
Job Requirements and Key Competencies:
- Bachelor’s degree in Data Science, Statistics, Business Analytics, or a related field.
- 2+ years of experience in a data analyst or similar role.
- Proficiency in data visualization tools such as Tableau, Power BI, Looker or similar.
- Experience with Excel, Google Sheets, SQL, and scripting languages (e.g., Python or R) is a plus.
- Strong analytical thinking and attention to detail.
- Excellent communication and collaboration skills.
- Ability to manage multiple tasks and deadlines in a fast-paced environment.
- Commitment to data confidentiality and compliance.
- Experience with SQL (including complex query writing), data modeling, and JSON.
- Experience working with BigQuery or similar cloud-based data platforms.
- Bonus: Experience with Amazon’s reporting and eCommerce data is highly desirable.
