Establish and Works closely with business units to analyze, document and design solutions for data analysis, interpretation and reporting. Responsible for providing data that is accurate, congruent and reliable, ensures the information is easily available to user departments for analysis or integration with other systems. The Business Intelligence Analyst-Senior is distinguished from the Business Intelligence Analyst by its focus on in depth data solutions and lead responsibilities.
Duties/Responsibilities
(Work assignments may vary depending on the department’s needs and will be communicated to the applicant or incumbent by the supervisor.)
Provides analytical support for the development of business intelligence solutions;
Works on complex, cross-functional business intelligence solutions affecting one or more departments;
Participates in multiple projects as team member, can act as the team lead when needed;
Works with internal and external customers and Analytics and Data Governance partners to develop and analyze business intelligence needs;
Interprets business requirements and determines data analysis solutions to meet department needs;
Designs analytics and custom reports that can potentially be used in multiple departments throughout the County;
Performs analysis for a wide range of requests using data from various platforms;
Researches business problems and creates data models that help analyze identified issues;
Provides direction for the planning, design, and execution of data analysis solutions;
Reviews test plans and monitors testing process to ensure that results meet the identified need;
Provides support to test teams and resolves issues identified by the test results;
Provides input to the development of quality metrics, standards, policies and procedures for the form, structure, and attributes of the Business Intelligence tools and systems;
Creates data quality tickets, as needed and ensures timely resolution;
Researches tools, software frameworks and mechanisms for data analytics, interfaces with vendors to keep abreast of new technologies;
Ensure the proposed business intelligence solutions adhere to current County standards;
Designs and delivers end-user training and training materials;
Provides guidance, training, and problem solving assistance to other team members.
KNOWLEDGE & SKILLS:
Knowledge of:
- software development and applications programming applicable to area of assignment;
- principles and techniques of systems analysis and design;
- development and maintenance of data communications, security and privacy measures;
- principles of database design, data warehousing, data modeling and data mining;
- effective teamwork behaviors.Skill in:
- using Microsoft Excel (lookups, formulas, pivots, macros);
- writing SQL statements to analyze data: joining, filtering, aggregating;
- working within the Agile sprint methodology;
- written, verbal, interpersonal and management presentation communications;
- operating as an effective member of a team;
- writing procedures and work instructions;
- employing quality skill sets and diagnostic tools;
- problem solving and conflict resolution;
- understanding client applications and business requirements and concepts;
- employing diagnostic, analytical and conceptual skills with detailed orientation;
- gathering requirements, analyzing business problems, automating business processes and implementing application solutions;
- using BI tools such as SAP BO, Lumira, Tableau or Power BI;
- using reporting tools such as Crystal Reports, Web Intelligence or SSRS.
- English fluent
Minimum Qualifications
A Bachelor’s degree from an accredited college, university or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely related field as determined by the appointing authority at the time of recruitment and five years of business analysis or related technical experience.
(Relevant experience and/or education from an accredited college, university or technical trade school may be substituted.)
Qualifying education and experience must be clearly documented in the “Education” and Work Experience” sections of the application. Do not substitute a resume for your application or write “see resume” on your application.
Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies, specifically addressing the required and preferred qualifications.):
- A Master’s degree in computer science, computer engineering, informatics or management information systems (MIS).
- Experience using business intelligence tools.
- Experience with assessment, evaluation, and selection of tools that support the collection, sharing, standardization and integration of healthcare data.
- Experience with analytic query tools such as SQL.
- Experience with interoperability, to include databases, data linking and data system integration.
