Data Analytics Specialist IV

Uber
Chicago, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 74K

Job location

Chicago, United States of America

Tech stack

Microsoft Excel
Data analysis
Big Data
Data Infrastructure
Data Transformation
Data Structures
Data Visualization
Data Warehousing
Database Queries
Software Debugging
Hive
Python
Operational Data Store
Performance Tuning
Power BI
Standard Sql
SQL Databases
Tableau
Technical Data Management Systems
Data Processing
Freeform SQL
Spark
Backend
Data Analytics
Front End Software Development
Code Restructuring
Looker Analytics
Data Pipelines

Job description

This is a SQL-first analytics role where you'll spend the majority of your time writing, optimizing, and maintaining SQL queries that power global customer support reporting. You'll be responsible for building and maintaining the data infrastructure that field managers and senior leadership rely on for daily decision-making., Write, debug, and optimize complex SQL queries daily using PrestoSQL/Spark to transform raw data into reliable reporting datasets.

  • Build and maintain backend data pipelines and processes that feed operational dashboards
  • Perform data quality control and validation to ensure accuracy across reporting systems
  • Refactor and improve existing queries for performance and maintainability
  • Conduct data wrangling and schema analysis to understand data structure and relationships

Data Analysis & Subject Matter Expertise

Deep dive into operational data to understand support workflows, become a subject matter expert, and identify data gaps or quality issues

  • Perform ad hoc SQL-based analyses to investigate performance anomalies and operational blockers
  • Partner with stakeholders to translate business questions into technical data requirements

Visualization & Reporting

  • Build and maintain data products that provide frontend access to your SQL-generated datasets.

What the Candidate Will Do :

Strong SQL proficiency :

  • You should be comfortable writing complex queries including:
  • Multi-table joins (inner, left, right, full outer)
  • Subqueries and CTEs (Common Table Expressions)
  • Logic-based (CASE WHEN) and conditional statements
  • Window functions
  • Date/time manipulation

Data manipulation tools : Advanced Excel or Google Sheets for analysis and validation

Data literacy : Understanding of data types, schema design, and data quality concepts

Requirements

We need someone who enjoys solving problems and writing SQL. If you're more comfortable in Python/R doing statistical modeling than writing joins and aggregations in SQL, this role may not be the best fit., * At least 2 years experience in analytics

  • Strong analytics, SQL, and web query skills
  • Experience within Python or R and visualization tools
  • Strong stakeholder management skills, * Stakeholder management and the ability to translate business needs into technical solutions
  • Self-directed work style with strong attention to detail
  • Clear written and verbal communication
  • Experience with PrestoSQL, Spark SQL, or similar SQL variants
  • Data visualization experience (Tableau, Looker, Power BI)
  • Previous experience building data pipelines and processes
  • Familiarity with data warehousing concepts
  • Experience working with large datasets and performance optimization
  • Strong writen and verbal communication

Benefits & conditions

For Chicago, IL-based roles: The base hourly rate amount for this role is USD$35.71 per hour. You will be eligible to participate in Uber's bonus program, and may be offered other types of comp. All full-time employees are eligible to participate in a 401(k) plan. You will also be eligible for various benefits. More details can be found at the following link https://jobs.uber.com/en/benefits.

Apply for this position