ANALYTICS CONSULTANT SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Updated: July 29, 2024 - The Analytics Consultant adeptly utilizes tools like SAS or SQL for data synthesis and analysis, crafting actionable insights from varied sources. Proficient in statistical modeling and visualization techniques, they deliver innovative solutions and support marketing strategies with customer segmentation expertise. Their consultative approach ensures effective problem-solving and communication of results to diverse stakeholders, emphasizing their role as a versatile analytics partner.
Summary of Analytics Consultant Knowledge and Qualifications on Resume
1. BS in Business Analytics with 5 years of experience
- Ability to translate analytical topics and insights into actionable recommendations
- In-depth knowledge of marketing mix modeling, marketing ROI, social media analytics, data strategy, forecasting models, and optimization
- Experience working with SPSS, R/Python, and Excel
- Fluent in Swedish and English
- Business experience leading analyses and initiatives with a track record of business impact.
- Experience strategy consulting or on strategy teams in large companies
- Experience programming using R, Hadoop, or Python
- Have the ability to translate business problems into analytical solutions by knowing appropriate models to suggest to data scientists.
- Understand and recommend modeling techniques to data scientists.
- Present recommendations to senior staff and internal clients.
- Ability to Have current AGSVA baseline security clearance
- Ability to provide expertise and leadership in the design and build of SAP MDG solutions
2. BS in Computer Science with 8 years of experience
- Experience with SAP MDG and workflow configuration
- Experience with defining workflow rules in BRF+
- Ability to provide support to all testing activities for the MDG solution
- Ability to be involved in a minimum of 2 SAP MDG implementation projects
- Preparation of functional and technical specifications for nonstandard MDG functionality.
- Configuration and documentation of the SAP MDG technical solution as defined in the Explore Phase Business Process Design documents.
- Configure enhancements to standard workflows to support gaps in functionality.
- Ability to set up Email notifications for all in-scope MDG data objects.
- Ability to set up field value derivation for change requests BRF+ rules - BADI for cross-entity derivation
- Ability to set up field value checks BADI for validations
- Ability to set up field properties per change request type Field Property BADI - Hidden, Required, Optional Fields in an MDG change request
- Ability to configure the workflow change request steps in BRFIMG for all MDG data objects (material master, Service Master, BP, GL accounts, EAM objects)
- Ability to assist with activation of bulk create and bulk change functionality
- Ability to extend Idoc and provide logic for MDG data object custom fields of legacy fields by enhancement, UI enhancement, and Table enhancement.
3. BA in Finance with 3 years of experience
- Experience with SAS or SQL, or other data management, reporting or query tools
- Analytical experience with the ability to pull and synthesize information and data from multiple sources to create a robust analysis including actionable recommendations.
- Ability to translate and summarize complex data into understandable, actionable information and recommendations.
- Ability to communicate effectively, in both written and verbal formats, with a wide variety of partners both technical and non-technical
- Ability to proven data-driven storytelling ability and strong problem-solving skills
- Self-motivated to identify opportunities and propose solutions to business partners
- Advanced knowledge of statistical and predictive modeling techniques such as machine learning, decision trees, data reduction, clustering, and regression
- Creativity for new and novel analytics approaches or data visualizations to deliver insights
- Experience in delivering Insights and Data Visualization deliverables using Tableau
- Experience with banking and financial products and analytic support
- Experience or Knowledge of Customer Segmentation and Targeting various audiences
- Experience in creating a measurement plan and assisting marketing managers in setting up a campaign (test vs control) and developing marketing KPIs for a campaign.
- Consultative experience with the ability to identify and understand the problem, design a solution, gain buy-in and consensus on the approach, gather necessary resources to complete the assignment, and communicate results in a timely way to partners and peer groups.
- Knowledge and understanding of structuring complex data across varied sources.
4. BS in Data Science with 6 years of experience
- Experience in relating to finance, data analytics, or ESG
- Advanced university degree ideally in environmental science, engineering, economics, or finance
- Demonstrated interest in issues of climate change and sustainable investing
- Prior exposure to private equity or other alternative asset classes is a bonus
- Very strong quantitative (and qualitative) analytical skills and excellent conceptual thinking aptitude
- Advanced command of Excel working knowledge of Python or other programming languages is a bonus
- Excellent interpersonal and communication skills with a customer-first attitude
- Willingness to work with a highly collaborative, flexible, and innovative team across different locations and ability to prioritize tasks and meet deadlines
- Working knowledge of Wells Fargo databases
5. BS in Statistics with 7 years of experience
- Have the ability to manage multiple conflicting priorities while staying highly organized
- Desire to work in a highly collaborative role and interface with many teams and departments throughout the organization
- Have strong communication and presentation skills
- Ability to communicate with a variety of audiences including senior leadership
- Must be a proactive, self-starter with the ability to meet deadlines
- Have intermediate to advanced Excel skills
- Must have a strong affinity for working with data and communicating findings
- Ability to support the resolution of defects during the system integration and user acceptance testing activities of the project.
- Ability to support dress rehearsals and go live cutover.
6. BA in Economics with 4 years of experience
- Experience with test planning and test execution experience -regression testing, UAT testing, creating test cases, tracking test results, making observations, helping execute test plans
- Experience with SQL skills – used for the retrieval of data and manipulation of data (majority of data and testing is done all within SQL)
- Experience with communication and presentation skills – will be presenting test results to multiple groups across the LOB
- Experience with Python– use Python for testing & running scripts
- Experience with Capital Markets Knowledge – all products included in this (ex. cash products, derivatives, FX, trade, etc.)
- Experience with Data Management / Data Governance experience
- Experience with Financial Institution/Bank background
- Ability to create MDG extension to standard MDG data objects
- Experience with execution of unit testing of the MDG configuration and production of unit test documentation
7. BS in Information Systems with 2 years of experience
- Be relentless client-focus on both details and objectives
- Experience with enterprise-level projects and corporate programs
- Experience with analytical and/or data-intensive platforms and applications
- Experience with client-facing technical/analytical consulting experience
- Experience with data analysis skills with Excel and/or SAS (i.e. Enterprise Guide)
- Excellent verbal, written, and organizational skills
- Be Proactive – Curious – Creative – Confident - Compelling
- Must be able to ferret out information and synthesize solutions.
- Must be able to define workable solutions (time, money, value) given a set of business constraint
- Client-facing technical/analytical consulting experience
- Have advanced data analysis skills with Excel and/or SAS (i.e. Enterprise Guide)
- Have excellent verbal, written, and organizational skills
- Experience building statistical models in a business setting.