Enjoy problem-solving, need a venue to display your creativity, and emerging technologies pique your interest; if so, Barrow Wise Consulting, LLC is for you. As a multi-disciplined leader, you understand the gifts that set you apart from everyone else. Demonstrate innovative solutions to our clients. Join Barrow Wise Consulting, LLC today.
Responsibilities:
The Data Analyst will support Barrow Wise's GSA project and perform the following duties:
- Organize and analyze large amounts of structured and unstructured data sets using data analytical tools, to include experience locating, accessing, merging, cleaning, and standardizing data, and developing derived metrics.
- Develop and/or manage & improve upon existing Google Apps Scripts to include the Project Data Sheet, Leasing eStretch, Expiring Lease Report, Performance measures / KPI dashboard, R9 READ Lease & Project Inventory, Realty Financial Specialist tracker, and Monthly Status Report.
- Consult, develop, and build base requirements for the development of the READ Leasing, Planning, and Federal workload report, duration analysis, prioritization tool, and workload capacity model into a more automated and streamlined reporting tool.
- Establish data pipelines, as well as develop and implement best practices and procedures for data pipelines in collaboration with the business line.
- Migrate all READ Reports to Google to maintain and improve reporting.
- Create and implement data collection and analysis tools while utilizing programming languages and environments (e.g., R, Python, SQL, Scala, Java). Develop and maintain Google site and web application for READ
- Consult, develop, build, and maintain base requirements for ad hoc leasing development to automate communications or reporting with leasing stakeholders. Oracle to UNIX conversion when required.
- Translating and converting Oracle SQL plus scripts with UNIX shell commands to Oracle BI publisher.
- Utilize Google Apps Scripts to write both standalone and bound scripts using JavaScript ES6 without using any 3rd party Add-ons, Extensions or APIs that are not explicitly approved by GSA.
- Automate manual processes using a variety of GSA approved tools, applications, reports, software, and platforms (to include process automation).
- Leverage tools like SQL, Salesforce, Tableau, Google Scripts, and Google Data Studio to automate date pulls and data transformation.
- Write HyperText Markup Language (HTML), Cascading Style Sheets (CSS), and JavaScript (utilizing jQuery) to create Google web services and applications.