Data Analyst

Panama City, FL, USA ● San Antonio, TX, USA Req #6802
Wednesday, September 18, 2024

STS Systems Support, LLC (SSS) is seeking a Data Analyst to support the Air Force Installation & Mission Support Center (AFIMSC) Real Estate Services and Real Property Management and Engineering Services (RPMES), managed out of AFIMSC/A58GO.  The Air Force is working to mature its Real Estate and RPMES processes, procedures, and strategies to an end-state that optimizes life-cycle management while balancing risk and fiscal constraints.  The successful candidates will be part of the SSS team providing innovative solutions to execute the programs above. This position will serve the Real Estate Services team and work alongside the SSS data science and analyst teams to enhance their data practices and analysis. 

The role will include supporting the Air Force Real Estate Services Asset Management Plan (AMP) Manager with the management of the specific asset product line and the development of real estate principles and execution of the requirement development and validation process.

Responsibilities will include the following:

  • Provide Subject Matter Expert (SME) with experience and proven skills in interpreting, analysis, reporting, design, development, integration, training, testing, documentation, and implementation of key data from Accountable Property Systems of Record (APSR) and information therein.
  • Analyze Real Estate data, aggregate requirements, assess asset performance predictions from Financial Management Systems (FMs), analyze statistics and trends across portfolios, validate data, perform data management, compile other summarizing reports for each Real Estate Services (RES) portfolio, and recommend enhancements to processes.
  • Support integration of multiple database tools including socialization of data tool capabilities, development of learning aids for tool implementation, development of dashboard exports to align with reporting cycles for senior leader briefings, incorporation of user feedback, collaboration for development and tracking of metrics for performance, and application of analytics to dashboard tools and integration.
  • Work directly with the Real Estate Management Team to provide analysis of associated databases for requirements validation research, verification of requirement entry matches in databases, awareness of requirement changes from previous years, and reporting and visualization of associated metrics such as cost, term lengths, status updates, and trend identification.
  • Perform management of large dataset APSR information compilation, reporting and application, possibly involving multiple projects and groups of personnel at multiple locations.
  • Assist with Real Estate requirement submission, description, justification, categorization improvement and streamlining, validation tool development input, testing and use, and other process improvement support.
  • Improve data confidence within FM and other Civil Engineer IT systems through quality assurance checks, data reviews, and ensuring corrections and updates occur.
  • Facilitate resolution to challenging technical and programmatic issues.
  • Develop informative, professional graphs, charts, datasets, and comparative analysis.
  • Generate finished product reports and presentations for appropriate stakeholders.

Basic Qualifications:

  • Bachelor’s Degree, preferably in STEM field such as math, statistics, data analyst, data science, engineering, IT, or computer science.
  • 3-5 years of related experience.
  • Experience with SQL, VBA, Python, and/or other database querying including development of data Extract, Transform, Load (ETL) automation. Experience working with Air Force databases preferred.
  • Proficient in Microsoft Excel, Word, and PowerPoint.
  • Experience working with SharePoint, Power Automate, and Power Apps Canvas.
  • Understanding of Exploratory Data Analysis (EDA) and able to tell the story within the data to technical and non-technical professionals.
  • Work well in a team environment, able to independently develop professional deliverables and take direction well.
  • Good written and verbal communication skills including the ability to develop graphs, charts, datasets, and comparative analysis.
  • Ability to adapt and develop innovative solutions.
  • Understanding of cross-functional span of control over various specialties and fields.

Preferred Qualifications: 

  • Experienced in Air Force FM Systems such as BEAST, FASTR, NexGen, etc.
  • Familiarity with data visualization, preferably in Tableau, Excel, Python, or similar software.
  • Basic knowledge of Machine Learning such as Linear and Logistic Regression, Decision Trees, PCA, and Random Forest Modeling in Python or R coding languages.
  • Experience with Air Force database structures including APSR, ACES-RP, and other data bases.
  • Experience in a customer service, contractor environment.
  • Air Force experience preferred.
  • A background in engineering, math, statistics, data analysis, information systems, planning, or investment.
  • An existing NAC-I clearance or ability to receive clearance.
  • Position may require Secret Clearance.

The position will support a mixed government – contractor environment in Panama City, FL or San Antonio, TX.  Working remotely with the expectation of meeting in person when the occasion calls also considered for fully qualified candidate.  This position requires the ability to receive a NAC.

 

STS Systems Support, LLC (SSS) offers a competitive benefits package to include paid holidays, paid time off including sick and vacation leave, medical, dental and vision insurance, flexible spending accounts, short and long term disability, company paid life insurance, 401(k) with a company match and discretionary profit sharing and tuition reimbursement. 

SSS is an Equal Opportunity Employer. Employment decisions are made without regard to any protected category. Hiring preference will be given to BBNC shareholders, their spouses and descendants and Alaska Natives in accordance with Public Law 93-638

Other details

  • Pay Type Salary
Location on Google Maps
  • Panama City, FL, USA
  • San Antonio, TX, USA