Data Analyst Functions:

• Lead and manage analytical projects
• Gather functional requirements from clients and convert them into technical specifications
• Act as liaison between the client and application development team
• Develop analysis plans for proposals and projects 
• Use data analytics to develop research reports and findings for team members and clients
• Manage in-house and cloud-based technology tools and platforms 
• Process and transform data using Excel, SQL, R, or other tools
• Create reports and dashboards in Tableau, Microsoft Power BI, or other reporting tools
• Conduct statistical analyses in SPSS, R, Excel, or other statistical software

Data Analyst Qualifications:

• Bachelor’s degree in Computer Science or similar
• Master’s degree in Data Analysis, Business Intelligence, or similar (not required but a plus)
• Experience in the field of gathering and documenting requirements, data analytics, research, database management, or cloud computing
• Experience analyzing education data or working in the education field (not required but a plus)
• Knowledge of Salesforce, Microsoft Azure Web Services, or other cloud-based development tools (not required but a plus)
• Experience with Excel
• Experience with R, SQL, Python, or other computer languages
• Experience with data processing, modeling, and warehousing
• Experience with BI reporting tools (strong preference for Tableau and Power BI)
• Experience with web and application design (not required but a plus)
• Exceptional attention to detail is a must
• Excellent planning, organizational, and time management skills
• Managing competing resources and priorities.

Data Analyst Roles and Responsibilities:

• Responsible for the analysis of operational data in order to monitor and report on performance and variances associated with the cost of production.
• As an effective communicator you will liaise with operational staff and Senior Managers to drive down production costs.
• Key to your role will be to assist in driving down our costs to ensure we continue to provide our customers with low cost bills.
• Providing data and information for regulatory and reporting purposes and therefore you will have experience of producing management information reports.
• Opportunity within the role to develop and improve systems used to collect and analyse data in order to maintain and improve accuracy of information.
• Demonstrate a proven track record of managing large amounts of data

Data Analyst Skills, Experience, Qualifications:

• Possess a proven analytical background and excellent IT skills, particularly in the use of spreadsheets and databases (experience of OSIsoft-PI or SQL and Excel at an advanced level is desirable).
• HNC or Degree is advantageous but not essential.
• Required to master the bespoke cost planning model using Quantrix software and report presentation software Qlikview used at the Company.
• Experience of SCADA systems and VBA to manipulate data would be an advantage. Training can be provided
• Experience with SQL is preferred
• Advanced knowledge of software applications including Excel, Power BI and Access is required
• Previous inventory experience within a distribution environment is an asset
• Strong analytical and troubleshooting skills to identify and resolve complex problems; creative problem-solving

Data Analyst Functions:

• Building and supporting the management of automated CRM performance reports at market and global level and providing critical evaluation.
• Providing weekly email, SMS and WeChat analysis and reviewing of testing results to drive optimisations and developments
• Deriving insights from the customer data allowing greater understanding of the customer lifecycle supporting the CRM strategy
• Supporting analysis of all CRM campaigns and activations assessing success against ROI and KPIs.
• Cross channel consumer journey analysis to support CX strategy and vision
• Customer lifetime insights and recommendations
• Full funnel CRM, sales and media attribution
• Identify valuable data sources and automate collection processes
• Undertake pre-processing of structured and unstructured data
• Analyze large amounts of information to discover trends and patterns
• Build predictive models using different forms of analytical techniques
• Combine models through ensemble modeling
• Present information using data visualization techniques
• Propose solutions and strategies to business challenges
• Collaborate with engineering and product development teams to improve design systems and practices.
• Work in close collaboration with / support the Consumer & Efficacy team with consistent monitoring of digital marketing ROI

Data Analyst Knowledge, Skills and Abilities:

• Analytical CRM, retail data and customer journey experience
• Experience must include working with very large data sets, from multiple sources and in a variety of formats.
• Good knowledge in excel, Salesforce & Power BI
• Some experience in Retail (not necessarily luxury)
• Fine attention to detail
• Experience generating business analytical reports e.g. Sales, CRM
• Ability to problem solve with information at their disposal
• Ability to manage internal stakeholders to achieve objectives
• Highly commercial with an awareness of how to turn insights into actions
• Demonstrable experience in analysing, conceiving, selling in and delivering insights that have led to business change and growth.
• Very strong numerate skills.
• Ability to use SQL is essential and R/Python an advantage
• Experience in tools such as PowerBI, or Tableau for results presentation/dashboarding.
• Experience with Alteryx is beneficial
• Must have advanced Excel skills, macro & VBA knowledge.
• Work collaboratively with colleagues to achieve shared goals
• Build strong, personal and effective working relationships
• Take risks and adapt to a fast-paced environment
• Be a clear, concise, creative and persuasive communicator (in writing and in person) across both internal and external stakeholders
• Work self-sufficiently with great attention to detail
• Ability to work independently, taking high level project briefs and liaising with internal departments to get hold of the necessary information to produce cogent analytical assessments and present these at board level.
• Ability to work in a team environment and deal with multiple stakeholders across the business to ensure all teams are pulling together to achieve common goals and success measures.
• Ability to work to tight deadlines.
• Inspires others to high performance, self-motivated with the drive to operate effectively in ambiguity. 
• Values and role models a diverse, inclusive working environment in which everyone can work to their full potential. 

Data Analyst Duties and Responsibilities:

• Develop and iterate on quantitative reports, analysis, and insights that demonstrate customer ROI 
• Create data-informed recommendations for Sales and Product teams.
• Engage with Product Design Teams to build out actionable dashboards 
• Work with Data Engineering and QA teams to deliver and maintain client-facing analytics projects.
• Work to standardize datasets and metrics used by business users 
• Analysts across the organization by focusing on data integrity, data catalogs, and other helpful documentation.

Data Analyst Skills, Experience, Qualifications:

• Experience in quantitative analysis required
• Bachelor's degree required (degree in Business, Engineering, Informatics, or Math preferred)
• Proficiency using a BI tool to visualize findings and analysis (Tableau preferred)
• Data modeling experience turning business requirements into data objects
• Experience with querying languages (e.g. SQL) and/or scripting languages (e.g. Python, R)
• Working knowledge of end-to-end data pipelines and ETL or ELT paradigms preferred
• Excellent communication skills with the ability to establish analytic and technical credibility with a variety of stakeholders
• Demonstrated experience translating complex technical solutions into easy-to-digest information
• Experience working with a sales team or product management team preferred
• Understanding of predictive modeling and tools would be a bonus
• Knowledge of Hobsons products would be a bonus

Data Analyst Details:

• Execute a strategy, migrating away from manual data gathering to a consistent, repeatable reporting platform
• Acquire data from primary or secondary data sources and have the ability to understand tables
• Gather, validate and analyze data using statistical techniques that will generate useful business reports
• Report KPIs and other points of measurement with accuracy, completeness and timeliness
• Identify, analyze, and interpret trends or patterns in complex data sets
• Filter and "clean" data by reviewing reports and performance indicators to locate data integrity problems
• Work with management to prioritize business and information needs
• Locate and define new process improvement opportunities

Data Analyst Knowledge, Skills and Abilities:

• Ability to query databases to analyze data sets and translate data into meaningful business analytics
• Effective communication, presentation and technical writing skills
• Ability to establish successful relationships and work in a cross-functional capacity
• Demonstrates accountability and integrity
• Highly motivated self-starter, driven for results, effective at prioritizing and managing complex tasks
• Demonstrated ability to think strategically and develop creative solutions, and to understand and discuss complex technical concepts
• Strong attention to detail
• Technical expertise regarding data models, database design development, and data mining
• SEQUEL experience a plus

Data Analyst Duties:

• Collect and interpret data in response to requests from across the contract
• Analyse results to support decision making and improvements in the business, understanding the drivers for change and the limitations within any data
• Provide support for improvement projects, through the provision of good quality data.
• Identify patterns and trends in data sets and report findings to relevant teams to help drive change
• Cross-examine databases identifying performance trends and producing reports.
• Support the development of performance dashboards to give teams better visibility and understanding of the data available to inform business decisions.
• Use GIS mapping and analysis techniques to support improvements in data management and develop alternative methods of reporting and sharing data.
• Work alongside teams within the business to establish business needs and focus on priorities

Data Analyst Skills and Abilities:

• Proven experience of data analysis and use of relevant tools/systems to enable this
• Use of PowerBI or similar systems to develop performance dashboards
• Demonstrable experience of GIS tools for analysis and presentation of data sets
• Experience of working in a highway contract environment preferable
• Good literacy and numeracy skills
• Proficiency on Microsoft packages

Data Analyst Roles and Responsibilities:

• Use computerised models to extract data.
  
• Interpret data trends.
• Advise on the effectiveness of the data and suggest improvements.
• Remove any potentially corrupted data.
• Report findings in concise language.
• Identify key business areas that may benefit from data analytics.
• Model the impact of potential strategies and decisions using data.

Data Analyst Skills, Experience, Qualifications:

• Experience working in a Data Analyst position.
  
• Background analysing, modelling and interpreting data.
• Programming experience in Python, SQL and Oracle.
• Good level of mathematical ability.
• Excellent problem-solving skills.
• Familiarity working in a manufacturing environment would be beneficial.

Data Analyst Duties and Responsibilities:

• Develop and implement new tools and systems to validate client data and analyzing the performance of existing models
• Manage reports, create dashboards, and visualize data to communicate the delivery of information to clients and team members
• Analyze performance data for ad campaigns
• Understand clients needs and metrics and communicate actionable insights to the internal team
• Experience in a growth stage company, extremely well-organized, methodical and efficient
• Familiarity with business intelligence and data visualization tools like Periscope
• Help drive the adoption and usage of internal and external analytics tools for self-service
• Operational experience – ability to identify gaps and create processes
• Support all business functions by providing reporting and ad hoc analyses on a timely basis
• Courage to challenge the status quo when logic and reason require it. See something broken? Fix it.

Data Analyst Skills, Experience, Qualifications:

• Experience with SQL a big plus
• Experience in eCommerce a plus
• Bachelor in data science or quantitative discipline; advanced degree a plus
• Business analytics, affiliate marketing, data science, display advertising, online marketing, social marketing or a mix of education and experience
• Fundamental knowledge of ad targeting methodologies and iterative test-and-learn optimization practices
• Sharp eye for detail and organizational skills
• Comfort with ambiguity and with working in a fast-paced, always-on, start-up environment
• Outstanding written and oral communications skills
• Fluency in mathematical concepts and statistical modeling
• Critical thinking and problem-solving capabilities
• High level of proficiency with Microsoft Excel, pivot tables, and relevant reporting tools

Roles of Data Analyst:

• Own historical subscription plan membership and usage database – ensure all data is complete, clean and accurate
• Become an expert on point of sale revenue and usage mapping
• Identify data gaps, find data sources to fill these gaps, and make recommendations for additions to our data environment
• Design, implement and maintain reporting dashboards and KPIs with emphasis on automation
• Create decision support tools and analysis related to pricing initiatives and program changes
• Gather insights from legacy subscription data and make recommendations to management for increasing membership and improving profitability
• Develop detailed forecast model based on unique drivers of subscription membership
• Complete periodic variance analysis including researching POS level data for insights
• Prepare and deliver presentations describing trends and conveying findings
• Assist in the implementation of new BI tools

Requirements of Data Analyst:

• Bachelor’s Degree in Finance, Mathematics, Statistics, Data Science, MIS or related field
• Sound problem solver who can quickly process complex information and present it clearly and simply
• Solutions-driven, independent thinker with sharp attention to detail
• Ability to recognize trends and derive actionable insights from large, complex data sets
• Experience transforming raw sets of big data into clean and actionable information including integration of disparate data sources
• Experience in relational database management and/or data architecture (SQL knowledge a plus)
• Advanced Excel skills including extensive use of pivot tables, array formulas, look-ups, “if” statements
• Advanced financial modeling capabilities including scenario and sensitivity analysis
• Knowledge of statistical analysis principles and advanced quantitative methods
• Experience leveraging BI tools (Cognos, Tableau, Hyperion or similar) for data analysis
• Excellent written and verbal communication; capable of making presentations to all levels of the organization including Executive leadership
• Exposure to CRM, loyalty, subscription, or database marketing a plus
• Ability to work with and act in utmost confidentiality with sensitive company information

Data Analyst Duties and Responsibilities:

• Collect, interpret and analyze data to support the everyday needs of data processing, inquiry, and reporting
• Assist in the process of defining the style and reporting guidelines to be used in report design.
• Assist in the process of defining the company’s data collection and analysis processes to include Data Lakes, Data Warehouses, Master Data Management, etc.
• Assist in the development of data standards, guidelines, rules, and procedures.
• Identify improvements in the reporting process and contribute to the continued success of the business.
• Assist in the process of defining master data elements and the migration of existing data structures, systems, and processes to the new data management system.
• Create and maintain data models.
• Coordinate with the various business units to understand their information-based needs to redesign and align future workflows and processes for reporting to support those needs.
• Assist in the investigation of data issues, data repair, data protection, designs for new systems and research into new uses of available data to support the enterprise.
• Assist in the protection and integrity of data through active controls, overarching security and continuous data life cycle management.
• Assist in evaluating database types and utilities such as NoSQL and Graphical DBs
• Assist development team in creating normalized database structures.
• Assisting the creation of a Data Dictionary to provide clear definitions of data elements, and rationalization of their purpose and use.
• Researching apparent issues of data discrepancies or miss-alignments.
• Developing a clear understanding of where, when and how each data element is used, updated, transformed, stored and protected.
• Integrating the data mappings with other workflow and applications architecture documentation for useful reference.
• Maintaining the data definitions, models and mappings, as changes occur in the overall IT ecosystem, to keep them current.

Data Analyst Skills, Abilities and Experience:

• BS Computer Science or relevant field.
• Ability to decipher and organize large amounts of data.
• Ability to write comprehensive reports.
• An analytical mindset with mathematical aptitude.
• Good organizational and time management skills.
• Ability to diagnose and resolve data issues.
• Accuracy and attention to details.
• Ability to work in teams and independently.
• Understanding of the latest developments in data analysis and reporting.
• Expert knowledge of SQL.
• Experience in data modeling.
• Experience with Microsoft’s business intelligence product suite, Tableau, or Power BI.
• Hands-on experience with developing, monitoring and maintaining ETL processes
• Experience with building data warehouse solutions for CRM & ERP data
• Experience with data integration tools
• Experience with Spreadsheet Server and/or WorldWriter a plus, but not required.
• Experience with RPG a plus, but not required.
• Experience with the Feed industry a plus, but not required.
• Experience with Birst a plus, but not required.

Data Analyst Roles and Responsibilities:

• Identify and classify our target audiences as well as flagging growth opportunity areas.
• Analysis of customer behaviours across all our different channels and be able to identify trends.
• Collate data from multiple internal and external sources effectively and present it to stakeholders in an easy-to-understand format.
• Turn complex data and large data sets into easy to understand visuals which can be presented and articulated to senior audiences.
• Be able to contribute to the product life cycle and development, whether that be new products or from our existing line of products.
• Work with the Marketing team to identify important KPIs such as leads, conversion rates and web traffic and suggest ways to improve on these using collated data.
• Perform research into tools and software that can collect data and present it in a meaningful way.
• Understand the unique business requirements for each department and what is achievable with our existing data sets.
• Contribute ideas towards the general marketing strategy.
• Understand the challenges the sales team face and make informed recommendations for initiatives and interventions, supported by sound data analysis.
• Coordinate and evaluate opportunities and perform risk-assessment, making recommendations on how to address potential opportunities.

Data Analyst Skills, Experience, Qualifications:

• Preferably a degree in a numerical discipline such as Mathematics or Statistics or experience in a similar analyst role.
• A strong knowledge of and experience with reporting packages and SQL as well as statistical packages for analysing datasets, such as Excel or SAS.
• Be a self-starter and comfortable in working to their own initiative without needing direction.
• Strong skills using Google Analytics, Google Ads and/or other business analytical services (Mixpanel, Hubspot…)
• An understanding of how customer analytics can inform and impact business strategy.
• Excellent presentation and communication skills 
• Able to explain complex concepts to both a technical and non-technical audience.

Data Analyst Duties and Responsibilities:

• Acts as the day-to-day, business owner of our key data stores.
• Supports the planning, implementation and support of data acquisition, staging, loading and transformation of data.
• Understands business needs and translates them into business requirements and then functional requirements.
• Works alongside IT support to translate functional requirements into technical designs.
• Works with team members in developing data store solutions and data models that support new reports, dashboards and other analytical solutions to meet business requirements.
• Develops and maintains detailed documentation of the data including data definitions, high level ETL and data lineage.
• Designs, develops, and executes test plans to proactively identify defects/issues across large enterprise data stores and new data integrations.
• Supports the establishment and prioritization of a team backlog for incident resolution and enhancement requests.
• Provides detailed analysis on backlog issues including business impact to support prioritization.
• Demonstrates a strong understanding of complex data models, data structures, and data governance best practices to support large enterprise data stores.
• Supports adhoc requests by querying the data stores to return results to meet customer needs.

Data Analyst Skills, Experience, Qualifications:

• Demonstrates the skills and knowledge to establish and manage timelines, project priorities and handle multiple/concurrent projects.
• Maintain a sense of accountability and responsibility.
• Demonstrates high degree of professionalism in communication, attitude and teamwork with customers, peers and management.
• Proactively communicates new and innovative ideas, solutions, etc. to help advance the organization.
• Educates and trains team members on new technologies and architectural trends.
• Experience working directly with business customers to understand needs, resolve issues, perform root cause analysis, support adhoc requests and work backlog queues.
• Experience working directly with customers to document business requirements, functional requirements and testing.
• Experience utilizing SQL to navigate large enterprise data stores with complex data structures.
• Experience working with large data sets in a variety of enterprise data storage solutions with both a technical and business functional skill set.
• Experience with the planning, implementation and support of the extract, transform and load (ETL) process for new data sets.
• Experience working with enterprise data stores, data lakes, external data sources, APIs and data modelling concepts.
• Experience in consumer BI/Reporting Tools (Tableau, Power BI, Qlik Sense)
• Experience working in an analytics COE or an analytics consulting role.
• Advanced skills in SQL and basic skills in python or R.
• Knowledge of AWS data lake solutions including S3, Redshift/ Spectrum and more.