-
ID
#17811622 -
Job type
Permanent -
Salary
TBD -
Source
Apex Systems -
Date
2021-08-03 -
Deadline
2021-10-02
Avaya Call Center / BI Architect
Tennessee, Antioch, 37011 Antioch USAVacancy expired!
Consulting Application Engineer is part of the Business Intelligence (BI) Analytics center of excellence and provides conformed databases to support data analysis and reporting from a variety of reporting tools such as Business Objects, MicroStrategy, Teradata, SSRS, SSAS and PowerBI. The consultant will work with technical users, business analysts, and business owners to understand requirements and identify solutions and is responsible for translating business needs into the development of analytical work products to support BI activities. This position needs the qualities of a BA as well as the qualities of a Business Intelligence architect. This position needs a strong background in Call Center/Telephony data. Particularly the Avaya Dialer applications. Consultant works in conjunction with and may provide leadership to a team of developers to meet technical requirements. The position will be capable of conducting all work with no oversight and will be viewed as an expert in the applications.
Priority Abilities 1 . Experience with Reporting from the Avaya Platform (CMS, POM, AEP, CBA, Context Store) 1 • Deep knowledge of KPI's used in the Contact Center and an understanding of collecting the data from various data sources. 1 . Experience developing logical and Physical data models (Transactional (ER), Dimensional (Snowflake, Star)). 1 • Work collaboratively with Architects, Application Engineers, Analysts, Business and IT leaders throughout the company to understand data needs and use cases 1 • Write complex SQL queries involving multiple tables inner and outer joins 1 • Proficiency in creating tables, views, stored procedures, user defined functions and other T- SQL statements for various applications 1 • Knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts 2 • SQL Server development, system analysis, design, development & support of MS SQL Server 2016/2012/ in Production, QA and Development. 2 • Knowledge of Data extraction, transforming and loading (ETL) using DMExpress or SQL Server Integration Services (SSIS) or other Enterprise ETL tools 2 • Experience deploying and troubleshooting ETL/SSIS packages and scheduling SQL Agent jobs to run on daily, weekly and monthly basis 2 • Generating reports using tools such as PowerBI, SSRS or Excel (Pivot) that could be used to send information to diverse group of users 2 • Creating and publishing various production metrics including system performance and reliability information to systems owners and management 2 • Troubleshooting and resolving production data loads and participates in root cause analysis for failures 3 • Optimizing queries by creating various clustered, non-clustered indexes and indexed views 3 • Creating and maintaining databases, including creating roles and managing user permissions where needed as well as resolving deadlocks 3 • Work with OpenShift Container Platform to build and scale applications 3 • Experience using Python for data science and automation projects 3 • Analyzing data using statistical techniques/tools and provide detailed analysis of findings to Business leaders. 3 • The utilization of various version control tools such as GITHUB to sync work at all times.EEO EmployerApex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at orVacancy expired!