Job Description
JOB DESCRIPTION
The Data Analyst will support the organization by focusing on: Report Development, Data Quality Control, Product Data Analysis, Data Process Improvement, and automation for Ecommerce. They will also be responsible for enhancing and maintaining Power BI and Data Visualization tools. This highly visible position will have the opportunity to work across the organization, with multiple layers of employees and management. This role turns objectives into reporting requirements, reporting requirements into information, and information into insight.
PRIMARY RESPONSIBILITIES
- Create reports and visualizations to guide our business.
- Acquire data from primary and secondary data sources via APIs, web hooks, NetSuite, .csv exports, and third-party sources, etc.
- Develop, analyze, and interpret trends/patterns in data.
- Analyze reporting requirements, study existing reports for layout, formula and calculations, derived values, restrictions, attributes, and variants.
- Develop SQL queries to manipulate, analyze and report on large data sets.
- Ensures data accessibility and distribution by supporting ad-hoc data requests, creating and automating reporting and managing routine distribution of regular reports to leadership.
- Locate and define new process improvement opportunities.
- Support informed decision-making throughout the company by ensuring high data quality & integrity, building reports & dashboards, and conducting analyses on historical data.
- Perform exploratory data analysis to identify new insights and potential data connections.
- Define, set up and analyze A/B tests on promotions, landing page elements, and product upsells.
QUALIFICATIONS
- 5+ years of relevant experience in data analytics, Business Intelligence, data science or a related field.
- Proficient with Power BI. Proficiency in Tableau is a plus.
- Knowledge of DAX calculations in PowerBI.
- SQL experience, including the ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, indexes, sub queries, conditional joins, case statements, etc.)
- Advanced Microsoft Excel Skills. Macro/VBA Scripting is a plus.
- 1+ Year Experience with Microsoft Excel Power Query.
- 1+ Year Experience in Python.
- Excellent writing and verbal communication skills.
- Excellent problem-solving skills.
- Experience with analyzing Ecommerce data
NICE TO HAVES:
- BS or MS in Mathematics, Statistics, Computer Science, or related field.
- Experience with Salesforce Commerce Cloud and Shopify.
- Experience with marketing platforms like Google Analytics, and FB Ads
- Statistical modeling. (linear regression, ML/AI etc.)
- Experience designing KPI’s
- Experience with Workflow Automation tools like Microsoft Power Automate (Desktop)
- Coding proficiency with source code
WEBSITE URLS
- https://www.legendarywhitetails.com/
- https://dealermerch.ford.com/
- https://shop.thorogoodusa.com/ (to be launched in June 2024)
Entertainment Retail Enterprises offers competitive pay, generous benefits, and the opportunity to gain experience in your career. If you have a positive attitude and want to become part of our dedicated team, come join us!