Group O

Returning Candidate?

Data Analyst

Data Analyst

Job ID 
2017-1488
Job Locations 
US-TX-San Antonio
Category 
Information Technology
Division 
Business Analytics

More information about this job

Overview

Group O has an immediate need for a Data Analyst to join its growing team. This position is primarily responsible for processing and analyzing large volumes of data using SQL skills. This team supports Consumer Marketing’s ADHOC reporting and data solution needs in support of AT&T product strategies. Example of work supported would be Market Opportunity analysis, product sales/churn reports, campaign success metrics, order provisioning support and promotional offer application analysis. The analysis is used to enhance product acquisition/retention strategies and to guide how Marketing should focus its budget.    

Responsibilities

  • Writing SQL queries in a Teradata environment.
  • Utilization of Advanced Techniques in Excel (including pivot tables, graphing and mechanization).
  • Utilization of MS Access including data import/export, query building, information extraction, and mechanization.
  • Utilization of VB or VBA.
  • Collecting, analyzing and reporting on various internal and external metrics and processes.
  • Performing data mining.
  • Developing and implementing solutions to gather, process and present required reports.

Qualifications

  • Proficient in SQL code creation (2+ years’ experience)
  • Knowledge of Teradata desired
  • Use relational databases to link and merge multiple tables for management and query analysis
  • Knowledge of query/reporting tools (Teradata SQL Assistant, Tableau, SAS etc.)
  • Experience with development, loading and manipulation of data files (ETL) Export/Transfer/Load
  • Excellent verbal and written communication.
  • Proficient in the Microsoft Office suite of products. Expert in Excel/Access a plus.
  • Work well independently.
  • Experience working in a team of diverse individuals
  • Creative / proactive problem solver.
  • Self-starter / self-motivated
  • Eager to learn new programs and applications
  • Expert knowledge of complex databases: i.e., Teradata database with thousands of data tables and views accessing customers, products, orders, etc.
  • Expert knowledge of aggregating data using complex SQL code. i.e., using functions such as SUM, COUNT, CASE statements, etc.
  • Expert knowledge of Excel Graphs, Charts, Pivot Tables, etc.
  • Must be able to multitask efficiently and progressively. i.e., don't let daily distractions such as ad hoc requests delay the primary objective
  • Must work well in a team environment
  • Excellent verbal and written communication skills; ability to communicate information to a variety of groups at different technical skill levels.
  • Aster or MS SQL Server experience a plus

Connect With Us!

Not ready to apply? Connect with us for general consideration.