Vacancy expired!
Overall Purpose:This position is part of our Human Resources Workforce Analytics TeamResponsible for the design, implementation, and maintenance of data management systems ( primarily SQL server and Azure SQL MI ) associated with the collection and usage of various datasets for reporting and analytics.Key Roles and Responsibilities:Collaborates with others in HR (Human Resources), other business units, vendors, and/or internal information systems staff to manage and maintain database management systems (primarily SQL server and Azure SQL MI). This includes configuring database servers, establishing disaster recovery protocol, scheduling and performing regular server maintenance, and creating database management procedures to meet changing requirements. Designs, deploys, and enhances ETL processes. Analyze existing SQL queries for performance improvements. Serves as HR department liaison to the IT function. This position may recommend, implement, and plan for improvements and enhancements to database management systems to support business priorities and enable data driven decisions. Counsels on project management, change management or leadership in the introduction of new technology in support of reporting and analytics. Develops project plans and leads complex client projects for technology system changes. May perform various Information Technology roles such as analysis, development, testing, deployment, data base management, configuration, and on-going support. Develops appropriate system and process documentation. Makes decisions under uncertain conditions. This position will have access to highly confidential information and compliance with AT&T data security guidelines is required. Works on problems of diverse scope where analysis of data requires evaluation of varying factors. Demonstrates good judgement in selecting methods and techniques for obtaining solutions. Supports solutions for complex projects. May direct work of a small group as the technical lead for specific projects.Education: Bachelors Degree in Business Information Systems, Engineering, Math or Science prefered.Experience: Typically, 5-8 years of experience in a related field.Required skills/experience:Design, implement, and manage data warehouse and business intelligence solutions
Dimensional modeling
Data modeling in a tool such as erwin or ER/Studio
Create and troubleshoot ETL using SSIS
Write SQL queries in a variety of dialects
T-SQL and SQL Server development
Production database administration
System administration for Windows and Linux
Database performance tuning and optimization
C# and ASP.NET programming
Git or other distributed version control system
Write technical documentation
Effective client relationship management
Explain complex technical concepts to non-technical audience
Manage competing priorities effectively
Define business requirements and translate into data and reporting solutions
Desired skills/experience:Power BI development (DAX, PowerQuery/M, dataflows) and platform management
Azure development, administration, and data engineering
DevOps culture, processes, and tools
Data governance
JIRA or other bug tracking/work management tool
Project management experience
Agile methodology
Low code/no code automation, such as Automation Anywhere RPA or Microsoft PowerApps
Knowledge of Python Development
Principal Functional Skills / Competencies associated with this Title:Capacity Planning and Management
Data Administration
Database Backup and Migration
Database Design (Physical)
Database Development Tools
Database Management System
Database Structures
Information Security Management
Operating Systems and Environments
Performance Measurement and Tuning
Query and Database Access Tools
Relational Databases
Repository Tools
Scripting Tools and Languages
Software Installation and Support
Technical Troubleshooting
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. (http://careerintelligence.web.att.com/cip/view/main.html#!/jobProfile/49092505)Job Code - 49092505We expect employees to be honest, trustworthy, and operate with integrity. Discrimination and all unlawful harassment (including sexual harassment) in employment is not tolerated. We encourage success based on our individual merits and abilities without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, marital status, citizenship status, military status, protected veteran status or employment status.
Vacancy expired!