ANALYTICS ANALYST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Updated: July 29, 2024 - The Analytics Analyst utilizes statistical analysis and advanced tools to extract valuable insights from data, facilitating informed decision-making within organizations. Their responsibilities include designing data models, conducting predictive analysis, and presenting findings in actionable reports, enabling stakeholders to optimize performance and gain a competitive edge in the market. With a blend of technical expertise and business acumen, they play a crucial role in driving strategic initiatives through data-driven approaches.
Summary of Analytics Analyst Knowledge and Qualifications on Resume
1. BS in Statistics with 4 years of Experience
- Experience working for a retailer supporting the marketing function
- Have strong statistical and econometric modeling skills
- Demonstrate strong technical skills, including proficiency in some of the following areas SAS/R/Python, SQL, and Excel.
- Have working experience with Oracle, MS SQL, Teradata, or other database products.
- Have working experience with Tableau, MicroStrategy, or other business intelligence tools as an asset.
- Have strong verbal communication skills
- Have the ability to communicate with all departments in the division
- Providing accurate, concise and up-to-date information in a timely manner
- Be Self Motivator and Have motivational Skills
- Be resourceful, proactive, takes initiative
- Be Problem Solver and Data Visualization using Tableau
2. BS in Mathematics with 3 years of Experience
- Have excellent interpersonal skills with the ability to build relationships and effectively collaborate with partners across all levels of the company.
- Have strong communication skills (written/verbal) and presentation skills.
- Have strong organizational skills and attention to detail.
- Have the ability to build relationships and effectively manage internal customers.
- Desire to collaborate with the team and build working relationships
- Affinity for working with quantitative data, while appreciating the art form that comes with applying it to customer engagement
- Excellent ability to break down and communicate complex ideas
- High level of ownership, quantitative acumen, and entrepreneurship
- Proficiency with Microsoft Office suite
- Eagerness to learn or demonstrate experience with quantitative tools (e.g., SQL, Python, R, Tableau, statistical modeling)
3. BS in Computer Science with 2 years of Experience
- Have an undergraduate degree in Business, Economics, or English
- Have strong analytical and quantitative problem-solving skills
- Have exceptional PowerPoint and Excel skills
- Have the ability to work collaboratively in a team environment
- Experience presenting analyses to key stakeholders at different organizational levels
- Experience with innovation methods (e.g., human-centered design, design thinking, design sprints)
- Have intellectual curiosity, willingness to learn a new industry and grow
- Experience with scripting languages (VBA, Python, SQL), statistical software (SAS / R) and data visualization software (Tableau)
- Be efficient in office applications (Excel, Word, PowerPoint, Access)
- Experience in optimizing and automating reporting, identifying appropriate opportunities to do so in order to drive capacity benefits
4. BS in Data Science with 4 years of Experience
- Be able to work independently and in a team environment, on multiple tasks
- Possess excellent communication skills, both written and oral
- Be able to work in a fast-paced environment, meet multiple deadlines and prioritize activities
- Exhibit particularly strong attention to detail along with exceptional time management and organizational skills
- Have strong interpersonal skills
- ability to build relationships across teams and other areas of the firm
- Must be results-oriented and dedicated to high standards
- Have the ability to take initiative and employ critical thinking
- Have a university degree and the Canadian Securities Course (CSC) or other relevant financial industry courses/industry experience
- Exhibit a keen interest in and knowledge of the Canadian investment management industry
5. BA in Economics with 2 years of Experience
- Have excellent oral and written communication skills
- Have the ability to simultaneously manage projects and/or tasks
- Be detail-oriented with outstanding analytical abilities
- Have a strong background in Microsoft Word, Excel, Access and PowerPoint
- Have previous experience in market research
- Know Power BI ideal, but not necessary
- Experience with various survey tools
- Have knowledge of the Canadian pension industry and/or institutional asset management is preferred.
- Have a desire to continuously learn and improve, particularly related to industry and investment knowledge.
- Be an advanced user in MS Office Suite, principally with manipulating data in Excel including pivot tables and macros.
- UNIX and Perl Scripting and SQL and PL/SQL
6. BA in Business Analytics with 5 years of Experience
- Collaborating with cross-functional partners on strategic projects to build Business Intelligence solutions that enable tracking of key performance indicators of the organization
- Building and maintaining a central data warehouse as well as reporting and analytics systems to enable senior management to make informed and intelligent decisions
- Analyzing massive amounts of data and extracting impactful insights that influence the strategy of business partners such as Operations, Finance, Sales Operations, etc.
- Ability to analyze raw data, identify trend drivers, draw conclusions, and summarize actionable recommendations and forecasted outcomes/implications.
- Exposure to mobile, social, and tablet measurement approaches as well as an understanding of the role of attribution and paths to conversions
- Expertise in Microsoft Excel and PowerPoint and Data Warehousing and Business Intelligence.
- Creative/curious approach to ramping up understanding aspects of digital advertising, digital media strategy, and standard media measurement
- Strong organizational skills, with the ability to aggregate information and data from multiple sources
- Experience managing and coordinating efforts across various teams/offices
- Excellent verbal and written communication skills, with ability to convey and package technical findings in layman’s terms