Data Analyst

barrowwise; Arizona; On-site; USD 65,000 - 95,000; Full time

Job summary

Barrow Wise Consulting, LLC is seeking a Data Analyst to support a GSA project by organizing and analyzing large data sets and developing dashboards using SQL, Python, Tableau, and Google Data Studio. The role emphasizes automating reports, improving data pipelines, and migrating reports to Google, with a focus on data quality, 508 compliance, and documentation.

The ideal candidate holds US citizenship, a technical bachelor's degree, and 3+ years in data processing and visualization across tools

Qualifications

• 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.

Responsibilities

• Organize and analyze large amounts of structured and unstructured data sets using data analytical tools, including locating, accessing, merging, cleaning, and standardizing data.
• Develop and/or manage and improve Google Apps Script projects and dashboards such as KPI dashboards and reports.
• Consult, develop, and build base requirements for automated reporting tools and capacity models.
• Establish data pipelines and implement best practices 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 using R, Python, SQL, Scala, Java; maintain Google sites and READ web applications.
• Translate Oracle SQL scripts to Oracle BI Publisher and automate communications with leasing stakeholders.
• Utilize Google Apps Scripts to write JavaScript ES6 scripts without third-party add-ons.
• Automate manual processes using GSA-approved tools and platforms, including SQL, Salesforce, Tableau, Google Data Studio.
• Write HTML/CSS/JavaScript (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.
• Ensure code is properly documented for future migration.

Skills

SQL

Python

VBA

Java

GIS

Tableau

BigQuery

Google Data Studio

JavaScript ES6

jQuery

Education

Bachelor's degree in a technical field

Tools

Google Apps Script

Oracle

UNIX

JavaScript ES6

jQuery

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.