AT&T Sr Data Analyst,Consumer Wireline & Direct Marketing

AT&T Sr Data Analyst,Consumer Wireline & Direct Marketing

Working as a Senior Data Analyst, you will work directly with the client user community and business analysts to define and document data requirements as the foundation for database design, data extraction, analysis or cleansing. You will also determine and document data mapping rules for movement of data between applications or for population of new databases.

Additional Responsibilities:

• Adhere to and promote the use of data administration standards
• Support data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts using SAS, Teradata SQL and/or Informatica
• Create and sustain processes, tools, and on-going support structures that enable reuse and efficiency
• Investigate and resolve data issues across platforms and applications, including discrepancies of definition, format and function
• Create and populate meta-data into repositories
• Responsible for coding, testing, and creating customer-level tables that can be used to generate reports and ad-hoc analyses
• Ensure that the reporting team has the tables needed for accurate and consistent customer data reporting by product
• Bundle data where information must be compiled on multiple consumer products
• Responsibilities may also include:
  • Create data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models
  • Create data flow diagrams and process models and integrates models across functional areas and platforms
  • Employ data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis

Quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance

Overall Purpose: Responsible for analyzing data in response to new business requests, performing maintenance and changes on interfaces, and identifying and resolving data discrepancies across multiple business applications. Key Roles and Responsibilities: Works directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applications. Determines and documents data mapping rules for movement of medium to high complexity data between applications. Adheres to and promotes the use of data administration standards. Supports data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts. Creates and sustains processes, tools, and on-going support structures and processes. Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function. Creates and populates meta-data into repositories. May create data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models. May also create data flow diagrams and process models and integrates models across functional areas and platforms. Works closely with DBAs to transition logical models to physical implementation. May be responsible for employing data mining techniques to achieve data synchronization, redundancy elimination, source identification, data reconciliation, and problem root cause analysis. May also be responsible for quality control and auditing of databases, resolving data problems, and analyzing system changes for quality assurance. Education: Preferred Bachelor of Science degree in Computer Engineering, Computer Science, Applied Science, Electrical Engineering, or Math or equivalent experience. Experience: Typically requires 5-8 years experience using SAS, and Teradata SQL. Knowledge and/or experience with Business Intelligence tools. Informatica experience desirable.

Supervisory: No.

""May consider applicants who reside (and will remain) in locations other than those listed.""


Qualifications:
Required Qualifications:

• Five years experience with SQL coding
• Experience creating, testing, and optimizing data tables
• Ability to clear a background check and drug test
• Ability to communicate clearly
• The successful candidate will be able to perform the following with or without reasonable accommodation:
  • Ability to operate a personal computer, wireless equipment, copier and fax

Desired Qualifications:
• Bachelor of Science degree in Computer Engineering, Computer Science, Applied Science, Electrical Engineering, or Math or equivalent experience

• 6 or more years experience with SQL coding
• Experience with consumer data on the EDW, to include eCI, SDR, MIS_VIEWS, and Telco Unreg Retail Views
• Expertise on Telco, DSL, Satellite, Wireless, IPTV, HSIA, and VoIP data
• Experience with AT&T data warehouses (EDW, eCDW, RDW, etc.)
• SQL server familiarity
• Demonstrated ability to be client focused
• Ability to write coding requirements based on business needs
• Expertise in planning, implementation, quality checking and data analysis
• Strong organizational skills with attention to detail
• Strong analytical skills

We offer:

• Competitive pay (base salary plus bonus incentive).
• Excellent benefits (401k, tuition reimbursement, paid time off, medical/dental and more!)
• Top-notch on-going training on the latest technology
• A fun, fast paced work environment

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

The largest communications company in the United States. And the world. We are the industry leaders in providing wireless service, high speed internet access, local and long distance voice, and directory publishing and advertising services across the US. We are also developing our business to include next-generation television services with our new AT&T U-VerseSM TV. 

Join our incredibly diverse company of more than 250,000 people and help drive the innovation that keeps AT&T at the leading edge of technology and service. Expect big things from the company that created the communications industry.