R&K is seeking a Data Analytics Analyst focused on Facilities Portfolio Analytics 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 use domain knowledge of real property, military construction and Energy Resilience and Conservation Investment Program (ERCIP) data hierarchy, metadata, and the relationships within the data to build, operate, and sustain the data warehouse. The Data Analytics Analyst will focus on performing data analysis of the DoD real property portfolio and help drive data solutions to the online real property data warehouse and executing reports for customers. R&K is an employee-owned company and an equal opportunity / affirmative action employer. EOE AA M/F/Vet/Disability. Duties: Analysis of real property data through SQL, MS Access, MS Excel, and Python Employment of data cleaning techniques, such as spotting data type mismatch, erroneous values, formatting issues Assisting in the validation and verification of real property data provided by the Military Services through automated collection Data analysis using Python programming at the introductory to advanced levels Data visualization creation using tools such as Microsoft Power BI Development of data sets in Excel and business intelligence products to support senior leadership information needs Data processing using various techniques to include with CSV files Analysis and problem solving of real property data issue and associated architecture Delivery of decision-quality data solutions in response to senior leadership requirements and various annual reporting cycles. Understanding of how the databases delivers data, how the application presents data, and all the business rules that govern the data. Collection and analyzation of relevant testing metrics, such as test coverage and execution progress, and defect density Experience and ability to work generally independent and collaborative in nature. Skills & Experience Active or capable of achieving a DoD Secret security clearance 5 years of relevant experience Experience with an Integrated Development Environment (IDE), such as IntelliJ or Eclipse. Experience with the Java Runtime Environment (JRE) and Java programming language Basic object-oriented terminology, such as classes, methods, and events. Basic HTML knowledge Experience with SQL Strong experience with Microsoft Access and Microsoft Excel Strong experience in Python Programming and ability to export that knowledge Ability to data mine; taking large data sets and creating focused data sets Experience creating reports that are customer ready Understanding of DoD Real Property conventions Education & Years of Experience Bachelor’s Degree in: Operations Research, Engineering, Mathematics, Economics or Management Science – or – 5 or more years’ commensurate professional experience in DoD Real Property Management and/or Energy, Installations, and Environment disciplines (Real Property Asset Accountability, Facility Management, Facility Operations, Engineering, Installations Energy, Environment), or Systems Engineering.
ms-access HTML Data Analyst mathematics Python CSV IDE SQL economics Java Engineering Systems Engineering Microsoft Excel Power BI