The BI Developer is primarily responsible for the technical aspect of reports design. He/she works with the Reporting team to develop automated reports, in order to speed up the process by removing manual and repetitive steps in reporting, without compromising integrity of the data and quality of reports.
Using existing reporting tools, BI Developer must review all reporting process documents, identify opportunities for automation and design intelligent reporting templates. They must work with the Reporting team, and/or Operations regarding any change in the reporting process.
Principle duties include:
Review of all existing reporting processes to identify opportunities for automation
Optimization of reports by replacing multiple traditional reports with dashboard type reporting.
Execution and monitoring of the whole reports development process, which includes the following:
Development of new template/s and its presentation to the Reporting Team and/or Stakeholders
Monitoring and Completion of User acceptance tests (QC), prior to rollout
Creation and handover of related process documentation to Reports Analysts
Provide backup support to Reports Analysts on Ad hoc and regular reports, data troubleshooting and/or assist in other projects, as may be required by the Sr. Manager and/or Director.
Typical Qualifications
education, experience, knowledge, skills and abilities typically needed to perform this job--potential candidates are screened for requirements listed in this section
Education
4 year computer-related course or equivalent combination of education and experience
Experience Target
5 years of experience in BPO/Contact Center reporting process and minimum 3 years in reports development, exposure to process improvement projects is preferred.
Knowledge/Skills/Abilities
Expert on Advanced Excel, especially with Pivots, Charts and Formula.
Expert on reports design using Power Query/Power Pivot, VBA Macro and Power BI (including Power BI service)
Knowledgeable on the database lifecycle, ETL processes and able to create databases using SQL and other database tools.
Experience in other BI tools (e.g. Tableau, Qlik) preferred, but not required
Experience in Big Data and wrangling tools (e.g Alteryx, Python/R) is an advantage.
Able to multitask, work in a dynamic, fast-paced environment.
Able to troubleshoot data issues and present solutions/recommendations for reports optimization.
With good verbal and written communication skills in order to properly communicate with all levels of internal and external stakeholders.
Special Certifications
None
Business Travel Required
Minimal, Setup of role is HYBRID setup
