Sr Specialist Data Analysis (Snowflake, SQL, Unix)

Job Description:

Overall Purpose:

This career step requires career level experience. 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. Job Contribution: Technical professional with some experience. Sound technical knowledge growing through application, expanding knowledge of ATT technologies.

Education:

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

Experience:

Typically requires 8-10 years experience. Technical Career Pathway (TCP) role.

Supervisory: No.

Full life-cycle experience on enterprise software development projects.

Experience in relational databases/ data marts/data warehouses and complex SQL programming.

Role & Responsibilities:

Experience with Snowflake, Hadoop and fluent with SQL, Postgres SQL, Vertica, Mongo DB and data analysis techniques.

Snowflake Certification would be an added advantage.

Extensive experience in ETL, shell or python scripting, data modelling, analysis, and preparation

Experience in Unix/Linux system, files systems, shell scripting.

Good to have knowledge on any cloud platforms like AWS, Azure, Snowflake, etc.

Good to have experience in BI Reporting tools – Power BI or Tableau

Good problem-solving and analytical skills used to resolve technical problems.

Ability to work independently but must be a team player. Should be able to drive business decisions and take ownership of their work.

Experience in presentation design, development, delivery, and good communication skills to present analytical results and recommendations for action-oriented data driven decisions and associated operational and financial impacts.

Sharp technical troubleshooting skills.

Strong Experience in Python and well-versed in Data analytical frameworks, Data Modelling (Structured)

Experience in client engagements, interpreting client’s business needs, and providing recommendations for data solutions

Must possess a good understanding of business requirements and IT strategies.

Strong financial acumen and analysis experience to determine business impacts for the application of the statistical solution

Strong Performance tuning skills – Query level tuning / DB tuning / Memory level tuning.

Expert knowledge of RDBMS, RAC, Backup & Recovery etc.

Strong DBA skills and relevant working experience.

Knowledge on DB Security viz. AVDF, DB Vault, Key Vault, e-Wallet, TDE would be added advantage.

Good knowledge of Machine learning packages

Good to have Data science and latest market trends.

Weekly Hours:

Time Type:

Location:

It is the policy of AT&T to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, AT&T will provide reasonable accommodations for qualified individuals with disabilities.