This position will be assigned to the Air Force Service Center. This is a regular full-time category position with guaranteed 40 hours per week. Employees appointed to a regular category position are eligible for benefits.

Duties

Develop, implement, and maintain leading-edge analytic capabilities, taking complicated problems and building simple models/frameworks. Identify trends and opportunities for growth through analysis of complex financial datasets. Evaluate organizational financial methods and provide source-to-target mappings and information-model specification documents for financial datasets. Evaluate internal financial systems for efficiency, problems, and inaccuracies, and develop and maintain protocols for handling, processing and cleansing financial data. Create best-practice reports based on data mining, analysis, and visualization. Work directly with financial managers and users of financial data to gather requirements, provide status updates and build relationships. Work closely project managers to understand and maintain focus on their analytic needs, including critical metrics and KPIs, and deliver actionable insights to relevant decision-makers. Proactively analyze financial data to answer key questions for stakeholders with an eye on what drives business performance and investigate and communicate which areas need improvement in efficiency and productivity. Develop and maintain financial databases by acquiring data from primary and secondary sources and build scripts that will make the data evaluation process more flexible or scalable across datasets. Create and maintain rich interactive visualizations through data interpretation and analysis, with reporting components from multiple data sources using data visualization tools such as Google Charts, Grafana, Microsoft Excel/Power BI, Tableau, Zoho Anlaytics, Datawrapper, Infogram. Provide quality assurance of imported data, working with financial analysts. Commission and decommission data sets. Process confidential data and information according to user requirements. Manage and design reporting environment, including data sources, security, and metadata. Support data warehouse in identifying and revising report requirements. Assess, test, and implement new or upgrade data analysis software and assist with strategic decision on procuring new data analysis capabilities. Troubleshoot the reporting database environment reports. Train end users on new reports and dashboards. Provide technical expertise in data storage structures, data mining, and data cleansing. Manage data users and user roles. Manage master data, including creation, updates, and deletions. Prepare financial data reports for executive leadership that effectively communicate trends, patterns and predictions using relevant data. If interested in applying for this position you may preview the online application: https://apply.usastaffing.gov/ViewQuestionnaire/12473884

Requirements

• This position requires the incumbent to complete a background investigation with favorable results.
• This position includes cyberspace work as a paramount duty requirement. Per DoDM 8140.03, the incumbent of this position must achieve the appropriate foundational and resident qualification requirements within nine months of assignment.
• This position requires that the incumbent be a U.S. Citizen or a Legal U.S. Resident for a minimum of 3 years.
• This position requires that the incumbent to reside in the local area.

Qualifications

Who May Apply: Open to everyone. Applicants will be categorized by preference(s) and/or priority consideration eligibilities. An applicant's eligibility will be determined based on eligibility claimed in the questionnaire and proof of eligibility MUST be provided with application by the closing date, 08/14/2024 Business Based Action, Outside Applicant Veteran, Spouse/Widow/Parent of Veteran, and Transition Hiring Preference In order to qualify, you must meet the experience requirements described below. Experience refers to paid and unpaid experience, including volunteer work done through National Service programs (e.g., Peace Corps, AmeriCorps) and other organizations (e.g., professional; philanthropic; religious; spiritual; community; student; social). You will receive credit for all qualifying experience, including volunteer experience. Your resume must clearly describe your relevant experience; if the position allows for qualifying based on education, your transcripts will be required as part of your application. Qualifying Experience: Experience mining data as a data analyst and using visualization tools to present data findings. Proven analytics experience, including mining, evaluation, and visualization to facilitate better understanding of data-driven insights. Strong SQL or Excel skills, with aptitude for learning other analytics tools such as Tableau, Power BI, Google Charts, Grafana. Practical experience in statistical analysis through the use of statistical packages, including Excel, SPSS and SAS. Experience with use of and the operation and functioning of relational databases, data integration and warehousing techniques using third party integration tools. Knowledge, Skills and Abilities (KSA's): Your qualifications will be evaluated on the basis of your level of knowledge, skills, abilities and/or competencies in the following areas: Bachelor's degree in economics, mathematics, finance, statistics, information systems or computer science field. Experience with any of the following: Data Analysis Expressions (DAX), SQL queries, Power BI, Direct Query or Microsoft Fabric Problem solving skills to complex financial data sets Experience in an accounting role is highly desired. Knowledge of financial, accounting principles and methods Ability to function in a telework environment utilizing VPN, Zoom, Skype and Teams. **NOTE: Those qualified applicants who meet both the minimum qualification requirement(s) and highly preferred criteria(s) will be considered best qualified for this position and will be referred to the selecting official(s) first for consideration. All other applicants will be referred as needed and requested by the selecting official(s). **Reminder to Applicants: Your experience has to be clearly identified in your resume in order to receive consideration. If your resume does not provide enough information regarding your work history for us to make a creditable qualification determination, your application package may be rendered disqualified and you will no longer be considered for this position. (Format example: Employer name, position title, beginning and ending dates of employment, with summary of duties, etc.)

Education

Some federal jobs allow you to substitute your education for the required experience in order to qualify. This position does not allow for education substitution.

FOREIGN EDUCATION: Education completed in foreign colleges or universities may be used to meet the requirements. You must show proof the education credentials have been deemed to be at least equivalent to that gained in conventional U.S. education program. It is your responsibility to provide such evidence when applying.

Contacts

• Address AFSVC Information Technology Systems AFSVC/VT 2261 Hughes Ave, Suite #156 Lackland AFB, TX 78236-9852 US
• Name: AFSVC HQ NAF HR Office
• Email: [email protected]