Data Analyst

barrowwise; California (MO); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive compensation packages

Attractive benefits

Equal opportunity employer

Job summary

Barrow Wise Consulting, LLC is seeking a Data Analyst to support the GSA project and perform data analysis, reporting, and automation across teams.

You will develop data pipelines, write SQL and Python code, use Google Apps Script, Tableau, and Google Data Studio, and ensure accessibility and documentation.

This role emphasizes problem-solving, collaboration, and delivering measurable insights to clients.

Qualifications

• US citizenship is required.
• Bachelor's degree or higher in a technical field (e.g., Computer Science, Information Technology).
• 3+ years' experience with two or more of the following data processing, analysis, and visualization tools: VBA, SQL, Python, Java, GIS, Tableau, BigQuery, and Google Data Studio.
• 3+ years working to improve operational and reporting data processes and infrastructure.
• 3+ years' experience with data manipulation, management, and reporting.
• Coding skills in languages such as SQL and Python.
• Advanced Google Workspace/Sheets/Excel experience.

Responsibilities

• Organize and analyze large amounts of structured and unstructured data sets; develop derived metrics.
• Develop and/or manage Google Apps Scripts for dashboards and reports.
• Consult, develop, and build base requirements for automated reporting tools.
• Establish data pipelines; develop best practices for data pipelines in collaboration with the business line.
• Migrate all READ Reports to Google to maintain and improve reporting.
• Create data collection and analysis tools using R, Python, SQL, Scala, Java; develop READ web applications.
• Consult and build requirements for leasing reports and workload models; automate communications.
• Translate Oracle SQL scripts with UNIX commands to Oracle BI Publisher.
• Use Google Apps Script to write JavaScript ES6 scripts with approved tools.
• Automate manual processes using GSA-approved tools, apps, reports, and platforms.
• Leverage SQL, Salesforce, Tableau, Google Scripts, and Google Data Studio for data pulls and transformations.
• Write HTML/CSS/JavaScript (jQuery) to create Google web services and apps.
• Check accuracy of calculations, PV analysis, and cash flows.
• Ensure Section 508 compliance where required.
• Document code for future migration.

Skills

SQL

Python

VBA

Tableau

BigQuery

Google Data Studio

GIS

Excel

Java

Education

Bachelor's degree or higher in a technical field

Tools

Google Apps Script

UNIX shell

Job description

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.
• Check accuracy of calculations, including present value analysis and cash flows.
• Ensure compliance with Section 508 where required, see https://www.section508.gov/.
• Ensure code is properly documented to be positioned for migration to a future application.

An Ideal Candidate has:

• US Citizenship
• Education: Bachelor's degree or higher in a technical field (e.g., Computer Science, Information Technology)
• 3+ years' experience with two or more of the following data processing, analysis, and visualization tools in a professional setting: VBA, SQL, Python, Java, GIS, Tableau, BigQuery, and Google Data Studio
• 3+ years working to improve operational and reporting data processes and infrastructure
• 3+ years' experience with data manipulation, management, and reporting
• Coding skills in languages such as SQL and Python
• Advanced Google Suite/Workspace/Sheets/Excel experience

Barrow Wise Consulting, LLC offers an ethical, challenging, diverse, and rewarding experience. Join us and become part of an enthusiastic, responsible team that delivers innovative solutions to our clients. We provide competitive compensation packages, attractive benefits, and great careers. Barrow Wise is an equal opportunity, drug‑free employer committed to diversity in the workplace. Minority/Female/Disabled/Protected Veteran/LBGT are welcome.

Our employees stand behind Barrow Wise's core values of integrity, quality, innovation, and diversity. We are confident that Barrow Wise's core values, business model, and team focus create positive career paths for our employees. Barrow Wise will continue to lead the industry in delivering new solutions to clients and persevere until the client is overjoyed.