Data Analyst Job Descriptions, Average Salary, Interview Questions

We are looking for an energetic, detail-oriented Data Analyst to support our growing client base. The ideal candidate will have excellent organizational skills, work independently, learn multiple software programs, and be skilled in Microsoft Excel.

Responsibilities

• Update and maintain pricing on client websites
• Understand sales trends
• Ability to analyze marketing data
• Create templates to automate recurring tasks
• Help develop reports and analysis
• Build, maintain, and deliver professional customer service and maintain positive working relationships with our clients

Skills and qualifications

• Adept at both written and verbal communication
• Solution-oriented
• Excellent attention to detail
• Excellent time management and prioritizing skills
• Exceptional knowledge of computers and word processing software
• Must be proficient in Excel, including Excel’s data analytics tool

This is an exciting fast-growing marketing and development agency focused on our clients and our employee’s success. Our leadership prides itself on developing people in their careers to help them provide top-tier service to its clients and grow the company in a way that gives hard-working employees upward mobility in their career.

The Data Analyst position is focused on improving company-wide effectiveness specifically in marketing effectiveness. The Data Analyst will collaborate with team members to interpret data and find opportunities for improvement in strategy and campaigns. As a Data Analyst, you will provide insight and recommendations to help us solve the complex problems that come with a fast-growing company!

Abilities and skills

• 2+ years of experience as a data analyst
• High proficiency in data extraction, manipulation, and analysis in SQL
• Ability to find correlations across various marketing channels and disparate data sets
• Strong understanding of relational database principles
• Skilled at identifying anomalies and patterns in business data
• Solid understanding of mathematical and statistical concepts
• Excellent attention to detail
• Experience in other programming languages for data manipulation such as Python is a plus

Duties

• Analyze the data flowing through the existing database and other workflow systems
• Structure and redesign the data that flows with the aim of maintaining a single source of truth for all master data and consistent reporting
• Acquire, ingest, and process data from multiple sources and systems into a data warehouse
• Collaborate with marketing teams to map data fields to hypotheses and curate, wrangle, and prepare data for use in reporting

Provide a wide variety of administrative and staff support services to a manager or group of managers within an assigned functional area. May assist in training others. Follows established procedures to perform routine tasks and receives general guidance and direction to perform a variety of non-routine tasks with limited decision-making responsibility.

Responsibilities

• Enter/process client-specific data and portfolio holdings into firm propriety software
• Assist with an initial analysis of prospective client statements
• Create and prepare customized presentations for specific advisor and client meetings
• Print and bind client presentations
• Develop relationships with sales investment consultants
• Perform clerical and support tasks
• Maintain defined quality standards and expectations
• Some judgment is required to adapt procedures, processes, and techniques to apply to more complex assignments
• Resolves most questions and problems and refers new or unusual issues to a higher level
• Routine contact with internal and external customers is required to obtain, clarify, or provide facts and information
• May communicate information to internal or external customers to sell or service products

Qualification:

• 1-3 Years Experience – Intermediate level concepts, principles, and practices of providing administrative support
• Fundamental investment concepts, practices, and procedures used in the securities industry. Basic principles of banking, finance, and securities industry operations
• Intermediate-level terminology of financial markets and products
• Performing a range of staff and/or operational support activities for a manager or group of managers
• Answering telephones and assisting visitors. Prepare, transcribe, compose, type, editing correspondence, agendas and minutes, and other documents
• Scheduling and coordinating meetings, events, interviews, and appointments
• Preparing reports
• Gathering and analyzing basic information. Establishing and maintaining files, databases, and other records
• Performing routine analysis and calculations involved in preparing reports
• Sorting, screening, and distributing mail
• Operating standard office equipment and using required software applications
• Maintain currency in modern office management methods and techniques
• Read, comprehend, and apply business-related information
• Organize, manage, and track multiple detailed tasks and assignments with frequently changing priorities in a fast-paced work environment
• Communicate effectively, both orally and in writing
• Work collaboratively within a team environment
• Provide a high level of customer service
• Establish and maintain effective working relationships