Works with end users to ensure tight fit between Analytics environment and business requirements. Designs and manages the Analytics tools and applications environment. Configures analytics tools, develops the semantic layer and metadata, and creates reports and report definitions. Creates and delivers end-user training and documentation and provides second-line support to power users who develop reports on behalf of their departmental colleagues
- Bachelor’s degree in computer science or a related field or equivalent experience.
- This position requires significant knowledge in complex query writing using SQL, Oracle SQL, or Postgres SQL as well as the use of Analytics Platform tools, such as Tableau.
Knowledge, Skills, Abilities, Experience, or Characteristics
o 2 years of report development and data analysis.
o Strong knowledge of Analytics tools, such as Tableau.
o Customer-focused in both independent and team roles in a high technology business/area.
o Demonstrated ability to translate business questions and requirements into reports, views, and query objects
o Expert SQL skills required
o Demonstrated ability to customize analytics dashboards to meet user needs
Helpful / Preferred
o Exposure to AWS.
o Strong database experience strongly preferred.
o Expertise with at least one of the following database technologies and familiarity with the others: relational, columnar and NoSQL (i.e. MySQL, Oracle, MSSQL, Vertica, Mongodb)
Functions and Responsibilities (…in addition to other duties as assigned)
o Troubleshoots analytics tool problems and tunes for performance
o Develops multidimensional semantic layer and query objects for end users
o Works with our team to aggregate large data sets for use within Appriss solutions
o Creates reports and report templates
o Develops and manages training and documentation
Physical and Mental Requirements
Job is physically comfortable; individual has discretion about walking, standing, etc.
Job requires a high level of judgment, analytical ability and creativity, such as investigating moderately complex problems or situations, analyzing information and recommending solutions. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
Some travel may be involved for both training and customer facing issues.
The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.