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:

40

Time Type:

Regular

Location:

Hyderabad, Andhra Pradesh, India

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.

Job ID R-12925-1Date posted 03/06/2024

When the day comes that you get some much needed R&R (not that you’d ever want to leave #LifeAtATT) you’ll know your future is set with the AT&T Retirement Savings Plan (ARSP). Savings Give back to your community and connect with colleagues through social and team-building events, and annual paid time off for volunteer efforts of your choice. Community & Team Events Let’s start with the big one: Your work gets rewarded with competitive compensation and benefits. It really does pay to be on our team. Compensation When it comes to priorities, we know family tops the list. For the moments that matter the most, you'll be there for them, and we'll be here for you. Family Leave Vacation? Staycation? Heck, let’s take a road trip. On top of paid holidays, chill out with paid time off (PTO) that you can spend any way you want. Paid Time Off Our people have class. Literally. We can help you out on approved education costs with our tuition assistance plan. Tuition Assistance Here’s another reason to breathe easy: You and your family get access to excellent medical, dental and vision insurance options. Insurance Options Wanna make your friends really jealous? You’ll get discounted access to the latest and greatest AT&T products and services — plus other awesome items, like tickets to live events. Discounts You strike us as an over-achiever (don’t worry, it’s a compliment). Our training and development programs are your ticket to expert status in your job. Training & Development When the day comes that you get some much needed R&R (not that you’d ever want to leave #LifeAtATT) you’ll know your future is set with the AT&T Retirement Savings Plan (ARSP). Savings Give back to your community and connect with colleagues through social and team-building events, and annual paid time off for volunteer efforts of your choice. Community & Team Events Let’s start with the big one: Your work gets rewarded with competitive compensation and benefits. It really does pay to be on our team. Compensation When it comes to priorities, we know family tops the list. For the moments that matter the most, you'll be there for them, and we'll be here for you. Family Leave Vacation? Staycation? Heck, let’s take a road trip. On top of paid holidays, chill out with paid time off (PTO) that you can spend any way you want. Paid Time Off Our people have class. Literally. We can help you out on approved education costs with our tuition assistance plan. Tuition Assistance Here’s another reason to breathe easy: You and your family get access to excellent medical, dental and vision insurance options. Insurance Options Wanna make your friends really jealous? You’ll get discounted access to the latest and greatest AT&T products and services — plus other awesome items, like tickets to live events. Discounts You strike us as an over-achiever (don’t worry, it’s a compliment). Our training and development programs are your ticket to expert status in your job. Training & Development When the day comes that you get some much needed R&R (not that you’d ever want to leave #LifeAtATT) you’ll know your future is set with the AT&T Retirement Savings Plan (ARSP). Savings Give back to your community and connect with colleagues through social and team-building events, and annual paid time off for volunteer efforts of your choice. Community & Team Events