Data Analyst: Data Pipelines & Automation Specialist

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

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