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.

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;
Three (3) years of experience with business intelligence tools creating analytical applications and reports at a level comparable to the County's Associate Business Intelligence Analyst classification.

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;
Five (5) years of experience working with data reporting and analytics. Three (3) years of this experience must be at a level comparable to the County's Associate Business Intelligence Analyst classification.

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 or desirable.

Knowledge of:

• Data gathering techniques and writing detailed technical specifications documentation;
• Taxonomies, operations and workflows in field of specialization (healthcare, finance, etc.);
• Database concepts, design, constraints, functions and optimization;
• Business Intelligence / Data Warehousing structures and practices;
• Commercial Business Intelligence tools (e.g. SAP/Business Objects, PowerBI, Tableau, QlikView, etc.);
• 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:

• Design and communicate system solutions to client issues and problems of medium complexity;
• Determine data structures that benefit the entire reporting environment;
• Establish effective work relations with those contacted in the course of business;
• Work with functional teams to do needs analysis to determine reporting needs; gather report data objectives, data required and specifications;
• Develop detailed specifications for writing new reports, including appropriate distribution methods;
• Develop, test and deploy new/revised automated or custom reports;
• Mine data from appropriate systems; develop and deploy query parameters, layout, and filters;
• Analyze data and reporting results; validate data to ensure reports are extracting the correct data;
• Identify inefficiencies in queries and optimize for best performance;
• Conduct and participate in user acceptance testing;
• Follow-up and communicate resolutions, issues and delays to users in a timely manner;
• Develop and maintain reporting specification and process documentation;
• Maintain ongoing documentation of the appropriate reporting solution for various reporting or data extract needs;
• Make recommendations to maintain, update and improve reporting processes and related documentation;
• Provide analytical and technical support/coaching for requests, projects or initiatives;
• Educate and coach other team members;
• Manage time effectively, including proper and timely escalation;
• Produce complex 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.