Facility Portfolio Data Analytics Analyst

R&K is seeking a Data Analytics Analyst to support our Federal/Department of Defense clients in a real estate and real property program. Work will be conducted primarily as telework. The Data Analytics Analyst will execute the annual DoD real property data set, the associated annual reports and customized reports based on customer requests. The Data Analytics Analyst will focus on generating data analysis of the DoD real property portfolio with the aim to deliver decision-quality data solutions in response to senior leadership requirements.

R&K is an employee-owned company and an equal opportunity / affirmative action employer. EOE AA M/F/Vet/Disability.

Duties:

• Create a consolidated data set based on multiple inputs and data formats

• Execute existing quality assurance reports and develop additional reports to support anomaly identification and validation and verification of data sets

• Create analytic reports to provide data insights into data relationships; provide trends

• Execution of annual and ad hoc reports based on customer requirements. Ability to reuse and refine existing code.

• Maintain existing tools and develop new tools along with documentation and peer code review

• Analysis of real property data through SQL, Microsoft Access, Microsoft Excel, and Python

• Data analysis using Python programming at the introductory to advanced levels

• Create reports using data visualization to support analysis and summary of the real property data

• Maintain and create technical documentation for all work products using clear file naming conventions; support team review

• Must be able to clearly communicate with the end customer and team members on report requirements

• Work collaboratively with stakeholders and team members to understand and detail report requirements and develop, explain and demonstrate the technical solution. Must be comfortable with an iterative approach.

• Analyze and problem solve data quality issues and associated architecture

• Understand and communicate to team members how databases delivers data, how the application presents data, and all the business rules that govern the data.

• Review and analyze BI report content to validate data and provide analytical insights

• Experience working independently and collaborate with the team, and seeking reach back support as needed

Required Qualifications

• Bachelor's Degree in a related field such as Computer Science or Business Information Technology

• 5 years or more of relevant experience

• Active or capable of achieving a DoD Secret security clearance which requires US Citizenship

• Excellent communication skills, both oral and written

• Ability to work with a small team effectively

• Strong experience in Python Programming

• Strong experience using Microsoft Word, Microsoft Excel, SQL

• Ability to learn to query and code in Microsoft Access using Visual Basic for Applications (VBA)

• Ability to data mine; taking large data sets and creating focused data sets

• Strong organization and documentation skills

• Experience creating reports that are customer ready

• Must have the ability to learn functional concepts associated with DoD real property data and conventions

• Ability to learn Microsoft Azure DevOps and Microsoft Teams

• Strong knowledge of technology and capable of learning different technology to meet product, project, and customer needs and business aspects.

• Proficiency with remote work management tools and platforms, ensuring regular communication

• Participate in the software development life cycle, including daily scrum meetings

• Manage tasks to ensure it is completed on-time

Desired Qualifications

• Basic object-oriented terminology, such as classes, methods, and events

• Basic HTML knowledge

• Experience with data visualization tools such as Microsoft Power BI or Tableau