Report Analyst I Job in Sitel Group

Required Skillset

• Bachelors Degree in appropriate field of study or equivalent work experience
• Must have experience in the contact center arena
• Detail oriented, analytical and inquisitive
• Relevant experience of minimum 2 years with overall experience of minimum 5 years
• Excellent in creating Excel VBA macros
• Advanced knowledge in MS Excel functions and Formulas
• Ability to analyze the given data on correlation between different factors and choosing right type of visualization to depict the same
• Good to have hands on experience with any of the following BI tools: Tableau, Qlik sense, Power BI
• Good to have working experience in visualization packages like Seaborn, Plotly dash or Bokeh
• Good knowledge in descriptive analytics tools like Box plot, Histogram, Matrix plot, Heat maps, Scatter plot, etc.

Job Description:

This Position is key to driving internal efficiencies within our organization and so this role requires the ability to strategically think through what the objectives are and if they are being executed in the most efficient manner. Questioning the Status Quo is a requirement for the success of the Lead Reporting Analyst.

• Build VB prototypes and small scale applications, along with VBA scripts, in a bid to automate Excel spreadsheets.
• Develop, enhance, and maintain MS Office applications, and handle both frontend and backend development procedures.
• Design, configure, develop, and implement enhancements and production fixes to existing systems.
• Develop and implement new systems, and ensure that their configuration is properly handled.
• Use development best practices, and appropriate patterns to develop required software solutions.
• Create SQL Server views, stored procedures and queries, and actively mitigate potential security gaps.
• Create and maintain technical documentation, including user manuals and guides.
• Formulate and define system scope and objectives, based on the individual needs of each user.
• Analyze and revise existing system logic difficulties, and ensure that technical knowledge of all phases of application systems is maintained.
• Develop, maintain and support existing MS Excel VBA applications, and analyze and convert business requirements as needed.
• Perform object oriented analysis and design, and diligent testing to ensure optimal performance of all assigned systems, and system modules.
• Manage implementation of reports, dashboards & self-service reporting using Tableau and Microsoft ETL & reporting solutions
• Responsible for the development of management/financial reports with data sets extracted from utilization revenue, expense, performance indicators, and outcome measurements across the operation
• Oversees and prepares data retrieval analysis and reports for internal staff, customer and other external stakeholders

Tools expertise:

Tools \ Levels

Basic

Advanced

Master

MS Excel

Tableau / Power BI / Qlik sense

.

Bokeh / Plotly Dash / Seaborn (python)

• .

MS Power point

• .