Summary THIS IS A NATIONAL GUARD TITLE 5 EXCEPTED SERVICE POSITION. This National Guard position is for a DATA ANALYTICS SPECIALIST, Position Description Number T5879000 and is part of the OH USPFO, National Guard. The purpose of this position is to be responsible for administering and coordinating a complex data analytics program across the Army and Air National Guard within the state with external recipients, ARNG units, ANG wings and Joint Forces Headquarters staff offices. Responsibilities As a DATA ANALYTICS SPECIALIST, GS-0301-12, you will perform the following duties: 1. Provides technical advice on all aspects of data analytics. Responsible for administering and coordinating a complex data analytics portfolio including Army and Air National Guard and highly technical special projects. The specialist uses knowledge of innovative business intelligence, to create prepare, design, test, validate and deploy superior quality, compelling insightful and timely delivered data visualization solutions from various sources, which are automated and sustainable. The incumbent will research, design, develop and manage the content, and features data analytic applications. Uses data analytic and business intelligent tools to develop custom workflows, other applications and to process numerous additional data analytics and management tasks. Communicates and coordinates with content managers to ensure content conforms to Section 508, DoD, DFAS Site Office standards and policy, analytical visualizations, and content best practices. 2. Utilizes expertise in interpreting, developing, and applying appropriate data to generate usable products that enable leaders to make informed decisions about the enterprise related to business processes, management, and efficiencies. Conducts studies, identifies trends, risks, and themes based on the data and information. The analyst applies scientific and statistical standards to evaluate data to develop high-priority analyses and metrics. The incumbent also supports larger workforce management initiatives by collecting and consolidating corresponding data to develop, prepare, and update comprehensive reports, charts, graphics, and presentations to illustrate findings. 3. Counsels and advises others including Federal staff, and recipients to accomplish the program goals. Identifies areas for new content based on the needs of key business stakeholders for the purpose of accelerating decision time and increasing accountability. Manage full development life cycle using necessary software for hosting and facilitating web site communications to include analysis, planning, development, test, implementation, and maintenance. Designs and maintains related key performance indicators. Gathers specifications and requirements to create, business applications, data analytical dashboards and visualization solutions to support customer needs. 4. Performs qualitative and quantitative techniques to analyze and measure the effectiveness, efficiency, and productivity of National Guard programs (examples include Comptroller, Logistics, Real Property, Maintenance, and Human Resources). Applies appropriate program evaluation and measurement in order to prepare project papers and staff reports and provides briefings to JFHQ leaders, Staff personnel, unit/wing leaders, and respective program managers. 5. Provides technical guidance in the development and review of policy and procedural issuances from the Department, the agency, and Operational Directorates related to data analysis. Reviews and comments on proposed changes in rules or regulations, conducts special studies, and prepares position papers and special reports. Responds to letters, memos, phone calls, emails, etc. with recipient and Federal staff. 6. May have limited leader responsibilities. Distributes and balances workload among employees. Gives on-the-job training to lower-graded employees. May approve leave for assigned employees. Completes annual performance appraisals. Resolves simple complaints and grievances, referring the more serious ones to the supervisor. Recommends training needs for employees. Provides input to the supervisor concerning selections, promotions, reassignments, recognition of outstanding performance. *The above duty description does not contain all details of the official position description. A copy of the entire position description can be found on FASCLASS by searching the position description PD#: (T5879000). https://acpol2.army.mil/fasclass/search_fs/search_fasclass.asp Requirements Conditions of Employment Qualifications GENERAL EXPERIENCE: Progressively responsible clerical, office, or other work that indicates ability to acquire the particular knowledge and skills needed to perform the duties of the position to be filled. SPECIALIZED EXPERIENCE: Experience that equipped the applicant with the particular knowledge, skills, and abilities (KSA's) to perform successfully the duties of the position, and that is typically in or related to the position to be filled. To be creditable, specialized experience must have been equivalent to at least the next lower grade level. Applicants who have the 1 year of appropriate specialized experience, as indicated in the table, are not required by this standard to have general experience, education above the high school level, or any additional specialized experience to meet the minimum qualification requirements. DESIRED (But Not Required) SKILLS: Experience with Microsoft stack of reporting and business intelligence tools, including T-SQL, Power BI, SSAS (tabular), SSIS, & SSRS. Proficiency with SQL development Experience with Data and Process Modeling Experience with various software development methodologies, tools and techniques - particularly Agile-based approaches Experience with systems functional analysis, technology business analysis, and a working understanding of a variety of different technical platforms, databases, data frameworks, and related technologies Familiarity with DevOps-based environments Familiarity with unstructured data sources Experience with 3rd party tools for Power BI development Experience in designing, developing and deploying end-to-end complex ETL (Extract, Transform, Load) packages using Microsoft SSIS Experience in developing and supporting multi-dimensional Microsoft SSAS Cubes using Analysis Services and MDX Experience in integrating BI solution components such as Power BI, Power Pivot, Performance Point views with Excel spreadsheets, On-premise data sources, and Cloud services / Office 365 Experience in SSIS Developer implementing end-to-end ETL packages (SSIS) Education Additional Information If you are a male applicant who was born after 12/31/1959 and are required to register under the Military Selective Service Act, the Defense Authorization Act of 1986 requires that you be registered or you are not eligible for appointment in this agency (https://www.sss.gov/RegVer/wfRegistration.aspx).