A Sr Data Analyst leverages proven technical abilities to synthesize complex analytical tasks into easily understood data-driven stories. Responsible for working collaboratively among other talented analysts to apply established and create new analytical processes on diverse datasets to deduce insights and solve real-world business problems. Also ensures that all reporting and analytical responsibilities are completed competently in a timely manner, continually seeks out opportunities to learn new and hone existing technical skills (e.g. writing SQL/code, statistics, machine learning, etc.) and operates under minimal supervision and mentorship of more experienced managers and data scientists.
This position will serve as one of multiple analytics experts on the Customer Experience team which is responsible for advocating for the customer within the organization. We do that by obsessing over great customer experiences, understanding where we have opportunities to get better, and using data to justify investment in these areas. We also measure the impact of the efforts and track our customers sentiment towards The Home Depot experiences and our competitors.
The position will be responsible for:
- Tracking benefits of actions by the CX team using multiple stitched data sources
- Creating and maintaining advanced SQL queries that power dashboards
- Creating front end dashboards in tools like Tableau
- Helping design the new CX data platform
- Creating base queries and documentation to assist business teams in connecting to this new data source
- Ad hoc analytics requests
The right candidate for this role will be curious, become an expert on customer data, be a quick learner who can understand the business and dig deeply into specific experiences, and have strong logic and attention to detail. They will also have deep experience with SQL and Microsoft Excel and ideally some Python experience.
Key Responsibilities:
- Establish reporting standards and best practices.
- Architect and implement a reporting framework.
- Oversee data mining efforts.
- Develop programs, methodologies, and files for analyzing and presenting data.
- Collaborate with stakeholders, developers, UX designers and end-users to determine requirements.
- Data analysis, development of SQL scripts, stored procedures & triggers, and report generation.
- Develop programs, methodologies, and files for analyzing and presenting data
- Data Cleansing/validation
- Prepare data load scripts for mass data load from various data sources
- Use of varied database applications/analytical tools
- Enhancements/modifications to systems and procedures
- Use of varied database applications/analytical tools
- Enhancements/modifications to systems and procedures
Direct Manager/Direct Reports:
- Position Reports to Manager or Sr. Manager
Travel Requirements:
- Typically requires overnight travel less than 10% of the time.
Physical Requirements:
- Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
Working Conditions:
- Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.