Avaya Call Center / BI Architect

Apply Now

Company: Codeforce360

Location: Nashville, TN 37211

Description:

Required Skills:
  • Avaya Platform - Avaya CMS - Avaya POM - Avaya Experience Portal - Avaya CBA - Avaya Context store SQL/T-SQL Data Modeling (Star Schema, 3rd normal form, etc.).

Job Description:
  • The 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.

Qualifications:
  • Experience with Reporting from the Avaya Platform (CMS, POM, AEP, CBA, Context Store).
  • Deep knowledge of KPI's used in the Contact Center and an understanding of collecting the data from various data sources.
  • Experience developing logical and Physical data models (Transactional (ER), Dimensional (Snowflake, Star)).
  • Work collaboratively with Architects, Application Engineers, Analysts, Business and IT leaders throughout the company to understand data needs and use cases.
  • Write complex SQL queries involving multiple tables inner and outer joins.
  • Proficiency in creating tables, views, stored procedures, user defined functions and other T- SQL statements for various applications
  • Knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts
  • SQL Server development, system analysis, design, development & support of MS SQL Server 2016/2012/ in Production, QA and Development.
  • Knowledge of Data extraction, transforming and loading (ETL) using DMExpress or SQL Server Integration Services (SSIS) or other Enterprise ETL tools.
  • Experience deploying and troubleshooting ETL/SSIS packages and scheduling SQL Agent jobs to run on daily, weekly and monthly basis.
  • Generating reports using tools such as PowerBI, SSRS or Excel (Pivot) that could be used to send information to diverse group of users.
  • Creating and publishing various production metrics including system performance and reliability information to systems owners and management.
  • Troubleshooting and resolving production data loads and participates in root cause analysis for failures.
  • Optimizing queries by creating various clustered, non-clustered indexes and indexed views.
  • Creating and maintaining databases, including creating roles and managing user permissions where needed as well as resolving deadlocks.
  • Work with OpenShift Container Platform to build and scale applications.
  • Experience using Python for data science and automation projects.
  • Analyzing data using statistical techniques/tools and provide detailed analysis of findings to Business leaders.
  • The utilization of various version control tools such as GITHUB to sync work at all times.

Similar Jobs