Analytics Associate

View full description

Requirements:

• 5-8+ years of experience in business intelligence, data analytics, or related field
• 2+ years of experience in a consulting or investment banking environment preferred
• Master-level expertise in Excel, including complex formulas, pivot tables, and VBA
• Advanced proficiency in SQL, particularly with Amazon Athena
• Strong experience with Tableau, including dashboard development and data visualization best practices is preferred
• Exceptional attention to detail and ability to manage interconnected numerical datasets
• Strong organizational skills with ability to manage multiple projects simultaneously
• Bachelor's degree in Business, Analytics, Statistics, or related field

Responsibilities:

• Develop and maintain complex analytical models and dashboards using Tableau to visualize key business metrics and trends
• Create sophisticated Excel models to support financial analysis and business planning
• Conduct in-depth data analysis to identify patterns, trends, and areas for improvement
• Write and optimize SQL queries in Athena to extract, transform, and analyze large datasets
• Collaborate with stakeholders to understand business requirements and translate them into analytical solutions
• Ensure data accuracy and integrity through rigorous validation processes
• Document technical processes and maintain data dictionaries