Gather disparate data from various data sources; analyze and normalize to ensure data integrity for analysis. Provide consistent, relevant and accurate data as well as guidance/knowledge of the data and definitions that are available for analysis. Must have the ability to write queries in SQL organically and without an automated system.
Major Tasks, Responsibilities and Key Accountabilities
Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data to be incorporated into a centralized data format.
Analyzes, reports, makes comparisons to industry/company benchmarks, determines trends, and prepares cost analyses.
Defines data definitions and documents data limitations.
Creates or prepares spreadsheets for data analysis; prepares reports with charts and graphs and for ad hoc requests. May make presentations.
Presents recommendations based on findings and analysis. Provides input on policies and procedures.
Mentors and assists in the supervision of analysts to ensure accuracy, timeliness, and overall project completion
Performs other duties as assigned.
Nature and Scope
Identifies key barriers/core problems and applies problem solving skills in order to deal creatively with complex situations. Troubleshoots and resolves complex problems. Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results.
Independently performs assignments with instruction limited to the expected results. Determines and develops an approach to solutions. Receives technical guidance only on unusual or complex problems or issues.
May oversee the completion of projects and assignments, including planning, assigning, monitoring and reviewing progress and accuracy of work, evaluating results, etc. Contributes to employees' professional development but does not have hiring or firing authority.
Work Environment
Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.
No travel required.
Education and Experience
Typically requires BS/BA in a related discipline. Generally 5-8 years of experience in a related field OR MS/MA and generally 3-5 years of experience in a related field. Certification is required in some areas.
REQUIRED SKILLS -
Proficiency in Excel (Pivot tables, V-look ups, formulas, etc)