Senior, ETL Development job

company building AT&T location El Segundo, CA
171
Senior, ETL Development
jobs
412
jobs in
El Segundo, CA
14
jobs at
AT&T
Find out how you match this company

Job

Company

Description

Salary

Skills

Summary

Job openings

Company Description

Headquartered in Dallas, TX, AT&T Inc. is the world's largest telecommunications company, the largest provider of mobile telephone services, and the largest provider of fixed telephone services in the United States. It is ranked #9 on the Fortune 500 list. Career areas include call center jobs, corporate, government support, retail, sales and IT. Your work gets rewarded with competitive compensation and benefits, including paid time off, tuition assistance, insurance options, discounted access to AT&T products and services, retirement savings plan and more. Training and development programs help to move your career forward within the company. AT&T proudly champions diversity: 26.8% of its 2018 budget was devoted to diversity initiatives.

Job Description

AT&T; Entertainment Group is changing the way the world experiences entertainment. We re delivering cutting edge products and services that redefine the future. Innovation is at the heart of what we do and we re revolutionizing the way our customers access content anytime, anywhere. With premier video services like DIRECTV and U-Verse to our newest streaming service, DIRECTV NOW, our industry leading team is at the forefront of making it all happen. Together, we re creating the best entertainment and communications experience in the world.

This is a terrific opportunity for someone well-versed in advanced data analytics to build, expand, and maintain the Marketing Analytics Engine data environment. This requires expert experience in data profiling, database administration, scripting languages & ETL. You will use Big Data technologies and expansive datasets of customer attributes including billing, device, usage, network, contacts to customer care, sales channel, online interactions, and survey data.

As the successful candidate you will:
  • Support the Campaign Analytics environment and data, evolving the frequency of refreshes to near-real-time data availability
  • Automate and streamline ETL for recurring loads
  • Audit data and conduct basic reporting to ensure the accuracy of the data used for analysis
  • Implement new data sources to enhance the capabilities of the team
  • Conduct exploration, evaluation, and delivery of new technologies, techniques, and tools to advance the capabilities of the team
  • Create of datasets and facilitate presentations to clients through data visualization tools
  • Utilize new visualization techniques to push data insights further into the business and marketing organization

This type of background will help to ensure your success:

  • 5-7 years related experience in advanced analytics, big data, relational database structures, research methods, sampling techniques, and system testing
  • Teradata, Aster, Oracle, Netezza, Vertica and Hadoop experience highly desired
  • Expert background in data analysis and profiling (UNIX Scripting, SQL, SAS, Perl, Pig & Python)
  • Expert background in database management, ETL scripting, and automation
  • Experience with marketing campaign data and analytics
  • Passion for refining general problem statements into specific and meaningful datasets for analytic use
  • Bachelor's degree in Computer Science or similar discipline; Advanced degree in a related field is highly desired

AT&T; is an Affirmative Action/Equal Opportunity Employer, and we are committed to hiring a diverse and talented workforce. EOE/AA/M/F/D/V

This job was posted on Sat Feb 03 2018 and expired on Thu Feb 08 2018.
Minimum $81629.59664444956
$109106.22558032637 average
Maximum $138183.43484256492

Tasks

  • Test programs or databases, correct errors, and make necessary modifications.
  • Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
  • Modify existing databases and database management systems or direct programmers and analysts to make changes.
  • Specify users and user access levels for each segment of database.
  • Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions.
  • Develop methods for integrating different products so they work properly together such as customizing commercial databases to fit specific needs.
  • Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
  • Work as part of a project team to coordinate database development and determine project scope and limitations.
  • Review procedures in database management system manuals for making changes to database.
  • Revise company definition of data as defined in data dictionary.
  • Review project requests describing database user needs to estimate time and cost required to accomplish project.
  • Train users and answer questions.
  • Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.
  • Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
  • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.
  • Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software.
  • Select and enter codes to monitor database performance and to create production database.
  • Establish and calculate optimum values for database parameters, using manuals and calculator.

Skills

  • Reading Comprehension - Understanding written sentences and paragraphs in work related documents.
  • Active Listening - Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.
  • Writing - Communicating effectively in writing as appropriate for the needs of the audience.
  • Speaking - Talking to others to convey information effectively.
  • Mathematics - Using mathematics to solve problems.
  • Critical Thinking - Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
  • Active Learning - Understanding the implications of new information for both current and future problem-solving and decision-making.
  • Monitoring - Monitoring/Assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.
  • Coordination - Adjusting actions in relation to others' actions.
  • Complex Problem Solving - Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
  • Operations Analysis - Analyzing needs and product requirements to create a design.
  • Programming - Writing computer programs for various purposes.
  • Operation Monitoring - Watching gauges, dials, or other indicators to make sure a machine is working properly.
  • Judgment and Decision Making - Considering the relative costs and benefits of potential actions to choose the most appropriate one.
  • Systems Analysis - Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
  • Systems Evaluation - Identifying measures or indicators of system performance and the actions needed to improve or correct performance, relative to the goals of the system.

Knowledge

  • Computers and Electronics - Knowledge of circuit boards, processors, chips, electronic equipment, and computer hardware and software, including applications and programming.
  • Mathematics - Knowledge of arithmetic, algebra, geometry, calculus, statistics, and their applications.
  • English Language - Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.
  • Telecommunications - Knowledge of transmission, broadcasting, switching, control, and operation of telecommunications systems.

AT&T

Description

Headquartered in Dallas, TX, AT&T Inc. is the world's largest telecommunications company, the largest provider of mobile telephone services, and the largest provider of fixed telephone services in the United States. It is ranked #9 on the Fortune 500 list. Career areas include call center jobs, corporate, government support, retail, sales and IT. Your work gets rewarded with competitive compensation and benefits, including paid time off, tuition assistance, insurance options, discounted access to AT&T products and services, retirement savings plan and more. Training and development programs help to move your career forward within the company. AT&T proudly champions diversity: 26.8% of its 2018 budget was devoted to diversity initiatives.
Type

Company - Public

Size

Large

Revenue

Over $10B

Location

201 South Douglas StEl Segundo, CA, 90245and others

Industry

Manufacturing - Communcations EquipmentTelecommunications

Founded

1876

Website

Visit Website

Similar jobs in the area

Similar jobs