Job Description

Job Description

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. Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data. 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.

Works directly with the client user community and business analysts to define and document data requirements for data integration and business intelligence applications. Supports data selection, extraction, and cleansing from corporate data warehouse and data marts. Extracts and analyzes data from specific applications, systems and/or databases to create reports and provide recommendations based on the analysis of the data. Investigates and resolves data issues across platforms and datamarts, including discrepancies of definition, format and function. May be responsible for employing data mining techniques to achieve data synchronization/mapping, redundancy elimination, source identification, data reconciliation, and problem root cause analysis.

**Expertise in SQL programming and at least 5 yrs. of experience with data extraction from data-stores like Vertica, DEEP, Teradata and Oracle IS required.

Strong familiarity for ATT data-sets including billing, ordering, inventory and video and streaming data.

Experience in data-warehouses like Snowflake, DEEP and automation using python/ksh programming will be a strong plus.

Education: Preferred Bachelors degree in Information Systems, Engineering, Math, or Sciences; Data Analytics nanodegree; or equivalent experience.

Experience: Typically requires 5-8 years experience. Senior level technical expertise. Deep technical knowledge and subject matter expert on ATT technologies.

Supervisory: No.

Principal Functional Skills / Competencies associated with this Title:

* Data Governance
* Data Mining
* Data Movement Tools
* Data Warehousing
* Emerging Technologies
* ETL Process
* Information Management
* Modeling: Data, Process, Events, Objects
* Query and Database Access Tools
* Relational Databases
* Scripting Tools and Languages
* System and Technology Integration

Note: Additional skills / competencies may be added to this specific requisition. During the application process, you will be asked to provide your proficiency and experience with all the skills / competencies associated with the requisition.

Click here to view this job description in Career Intelligence.

Job Code - 49092604