What are the responsibilities and job description for the Associate Business Intelligence Analyst position at The County of Santa Clara?
Description
Under general supervision, to gather, review, and interpret applicable data and analytical needs; to define, implement and ensure existing analytical applications and reports are executable and functional; as well as anticipate trends, events and consequences of business changes and develop recommendations to management for increasing business intelligence and data driven decision making.
Typical Tasks
- Analyzes data and reporting results; validates data to ensure analytics are extracting the correct data; and ensures statistical sample size validity, where appropriate;
- Consults with customers to identify and evolve their data and business intelligence requirements;
- Creates analytical applications and reports based on detailed specifications;
- Develops and maintains analytical and reporting specifications and process documentation;
- Maintains ongoing documentation of the appropriate business intelligence solution for various reporting or data extract needs;
- Extracts and prepares data from appropriate systems; develops and deploys query parameters, visual layouts, and filters;
- Trains customers in business intelligence systems usage;
- Uses Master Data Management (MDM) definitions, and works with Data Stewards to create new definitions, for accurate output labeling;
- Works with teams to do needs analysis to determine business intelligence needs; gathers report data objectives, data required and specifications;
- May be assigned as a Disaster Service Worker, as required;
- Performs other related duties as required.
Employment Standards
Sufficient education, training, and experience to demonstrate the possession and direct application of the following knowledge and abilities:
Training and Experience Note:
Possession of a Bachelor's degree from an accredited college in Computer Science, Information Technology, Science, Business or a related field.
Training and experience equivalent to the possession of a Bachelor's degree. Relevant analytical, administrative, lead, supervisory or management experience that includes interpreting rules and regulations, gathering data and formulating recommendations, and report writing can substitute for education on a year-for-year basis;
Two (2) years of experience working with business intelligence tools creating analytical applications and reports.
Special Requirements
Knowledge of:
For positions assigned to the healthcare vertical, the following knowledge is required:
For positions assigned to the healthcare vertical, the following knowledge is desirable:
Ability to:
Training and Experience Note:
Possession of a Bachelor's degree from an accredited college in Computer Science, Information Technology, Science, Business or a related field.
OR
Training and experience equivalent to the possession of a Bachelor's degree. Relevant analytical, administrative, lead, supervisory or management experience that includes interpreting rules and regulations, gathering data and formulating recommendations, and report writing can substitute for education on a year-for-year basis;
and
Two (2) years of experience working with business intelligence tools creating analytical applications and reports.
Special Requirements
- Ability to travel to alternate locations in the course of work.If driving, possession of a valid California Driver's License prior to appointment and the ability to qualify for and maintain a County driver authorization.
- Depending on the position, related certifications may be required.
Knowledge of:
- Relational, Big Data, and NoSQL databases, data warehouses, data stores and data marts;
- Data analysis, data validation, data models and data mining;
- Automated or custom reports;
- Query parameters, layout, and filters;
- User acceptance testing;
- Principles of customer service;
- Principles of effective teamwork;
- Principles of training.
For positions assigned to the healthcare vertical, the following knowledge is required:
- Specific data handling requirements for patient identifiable information and protected health information.
- EPIC data warehousing and reporting environments (Caboodle, Clarity, Business Objects, etc.)
- Healthcare data standards, taxonomies and reference data coding systems (i.e. ICD 10, CPT, SNOMED-CT, etc.)
- EPIC Certification in appropriate functional area, or ability to become certified within 6 months
For positions assigned to the healthcare vertical, the following knowledge is desirable:
- Healthcare integration technologies and techniques (HL7 v2 or higher, EDI, etc.)
Ability to:
- Produce analytics that incorporate business metrics, KPIs, scorecards and dashboards;
- Use business intelligence tools;
- Provide excellent customer service;
- Work effectively on a team;
- Train customers on report usage;
- Keep necessary documentation for various reporting or data extract needs.
