ANALYTICS ANALYST SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Reviewed under Editorial Standards by Lam Nguyen
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
Editorial Process
Lamwork content is developed through structured review of publicly available job postings and documented hiring trends.
Editorial operations are managed by Thanh Huyen, Managing Editor, with research direction and final oversight by Lam Nguyen, Founder & Editorial Lead. Content is periodically reviewed to reflect observable labor market changes.