General Statement of Duties
The Business Intelligence Analyst II performs highly analytical professional-level work with responsibility for business intelligence functions across multiple departments. The position combines an understanding of core business processes with data warehousing and reporting expertise and translates them into actionable business intelligence. Interfaces with business leaders and internal customers from business units and county departments to architect and implement highly visible solutions involving data warehouse creation and maintenance, static reports, dashboards, financial and operational metrics reporting, and process automation. A high degree of professional technical knowledge and analytical skills are utilized to assure that County program goals and outcomes are effectively supported.(#3214)
Familiarity with Microsoft SharePoint and experience in data analysis using Excel PowerPivot are advantages.
Examples of Work
The Business Intelligence Analyst will focus on our Business Intelligence initiative and participate in continuous improvement activities. This position acts as a primary contributor to the design and implementation of a suite of solutions based on customer and/or organizational requirements. Data Staging, ETL, data cleansing, data de-normalization, tabular and multidimensional cube creation using data from multiple systems will be required to build data solutions to meet these requirements with a high degree of confidence and accuracy. Development of solutions for ad-hoc requests that can be deployed to other members of the team as recurring reports. Excel, SharePoint, SSIS, SSAS, & SSRS will be used on a regular basis in these solutions and it is important that the candidate has experience with these tools. The position provides documentation around area of support based on department and organization standards. Work is performed within the framework of established policies and procedures under the direction of the Business Intelligence Manager.
Knowledge, Skills and Abilities
Ability to perform a variety of tasks and functions that involve related or varying processes. Ability to analyze and determine various courses of actions and appropriate services. Ability to solve a variety of problems that require the examination of data and processes to determine the best course(s) of action. Thorough knowledge of applicable information technology to best return information to the business users. May require ability to develop and implement system changes.
Business Intelligence Program Skillset. Ability to interpret business unit and management data needs. Ability to identify and collect relevant data and to assess the accuracy and integrity of data. Ability to analyze complex data. Ability to interpret and evaluate results, prepare documentation, and create financial and budget reports and/or presentations. Knowledge of predictive analytics modeling and design. Knowledge of the Microsoft Business Intelligence suite of products. Ability to independently resolve and/or develop recommendations for unprecedented, complex issues and problems. Ability to serve as a resource for others in resolving unprecedented, non-standard issues and problems. Ability to anticipate problems and develop recommendations for management resolution. Ability to consult with management if decisions have organizational and/or public impact. Ability to consider impact on productivity and service delivery. Ability to consider short and long term impact of decisions. Ability to state information in a clear and concise manner, in both written and oral form. Ability to provide appropriate documentation to support conclusions. Ability to review and edit the work of others. Ability to convey and/or consult on issues of a complex nature in a clear, concise, and organized manner. Ability to establish effective working relationships that foster organizational success. Ability to modify delivery, language, or content to suit the characteristics and needs of the audience. Ability to understand client programs, organization and culture. Ability to listen to customers to identify needs or problems. Ability to convey customer needs to others involved. Ability to offer suggestions to resolve problems or issues. Ability to present appropriate issues to internal management. Ability to understand the organization’s mission, the function of the specific work unit and how it interrelates with other work units to serve the customer/client. Ability to understand the impact and implications of decisions on the community and other departments. Knowledge of the primary duties/purpose of the work unit and how the unit contributes to accomplishing the goals of the organization. Knowledge of how individual decisions impact the achievement of the organization’s goals. Ability to consider how one’s actions affect the public view of the organization. Ability to consider how one’s interactions with customers reflect the organization’s goals.
Minimum Education and Experience
A master's degree in public or human services administration or a human services programmatic fields such as psychology, social work, etc., preferably with course work in human services planning and one year of experience in human service program planning or administration, or research and evaluation using statistical methodologies; or graduation from a four-year college or university and three years of administrative or consultative experience, research, evaluation and statistical application in the human service field; or an equivalent combination of education and experience.
All applicants will be given credit only for information provided in response to this announcement. No additional information will be solicited or considered by this office; therefore, persons who submit incomplete applications may not receive full credit for their education, training, and experience. Applicants will not automatically be given credit based on their position title. If work history involves part time work, you must state the number of hours per week to receive credit.