Business Intelligence Analyst/Developer III

*Please submit your CV in English.

PURPOSE OF POSITION:

The position will direct, organizes and support Business Intelligence (BI) projects in the designing, developing and implementation of the solutions. It will work on a highly complex, cross-functional and enterprise IT group. It will also provide subject matter expertise for key BI core functions. Engage with the business SMES and contribute to artefacts of data architecture, data profiling, data curation, analysis design processes.

The role will coordinate and provide technical lead in the implementation of the Data Warehouse and maintenance of those solutions. Lead in design and development of strategy for integration and migration of data to data warehouse.

Provide support in creating and developing data request queries and reports through visualization.

MAJOR RESPONSIBILITIES:

Project/Work Planning:

  • May lead workstream planning process from inception, technical design, development, testing and delivery of BI solutions.

  • Participate in project management estimation process.

  • Assists in planning, implementation of data identification.

  • Analyze functional business processes and requirement.

  • Manages and plans for BI services.

Business Requirements:

  • Work with business partners to develop and analyze business intelligence needs.

  • Provides input to business requirements and functional specifications for the design and implementation of solution.

  • Interprets business requirements and determines optimum BI solutions to meet needs.

  • Interfaces with business partners to identify and provides input to new technology opportunities that will have an impact on the enterprise wide BI systems.

  • Leads interviews with end users to determine the requirements for data, reports, analyses, training, data quality and performance.

Design/Develop:

  • Work with Architects to design and develop BI applications/solutions.

  • Analyzes and tests new releases/versions of BI applications/solutions in order to determine rollout schedule, technical compatibility and identify and resolve integration issues.

  • Analyzes, designs, and develops query parameters, layout, filters, and analytics for business solutions.

  • Enhances the performance of business intelligence tools by defining data profiling, data to filter and index that adds value to the user.

  • Designs and develops and optimizes enterprise wide information “views” and custom reports.

  • Provides technical direction for the development of reports keeping usability, security and data integrity.

Testing:

  • Lead or provide technical direction for the planning, designing, and execution of testing efforts.

  • Develops, executes and documents test plans.

  • Reviews test plans and monitors testing process to ensure that business results are tested.

  • Provides support to test streams.

  • Resolves issues based on test results.

Support:

  • Provides adhoc, warranty, and post implementation phase support.

  • Troubleshoots solution outputs.

  • Recommends improvements of BI applications.

  • Optimizes BI applications or performs report and query tuning to improve performance.

  • Supports and helps manage external resources, such as service providers and vendor field support.

Info Quality Assurance:

  • Provides input to the development of information quality metrics.

  • Creates data quality tickets, as needed.

Research/Evaluation:

  • Researches tools, frameworks and mechanisms for data analytics.

  • Interfaces with vendors to keep abreast of new technologies, pricing and customer applicability.

  • Participates in vendor evaluations.

Policies, Standards, Procedures:

  • Adheres to current standards.

  • Provides input to policies, standards, and procedure for the form, structure and attributes of the BI tools and systems.

Training:

  • Designs and delivers end-user training and training materials.

  • Trains users to transform data into action-oriented information and to use that information correctly.

Coaching/Mentoring:

  • Provides guidance, training, and problem solving assistance to other team members.

  • Mentors less-experienced individuals.

KNOWLEDGE, SKILLS & ABILITIES:

  • Bachelors’ degree in Programming/Systems or Computer Science or other related field. Or specialized training/certification. Or equivalent work experience.

  • Experience in developing Data warehouse/Data Lake.

  • Experience in data analysis and data mining.

  • 5-7 years of related technical experience in designing and developing business intelligence tools and systems.

  • Knowledge of one or more business/functional areas.

  • Willingness and ability to travel domestically and internationally, as necessary.

  • Has the ability to manage and lead the team.

  • Specialized Training or BI certification.

  • Preferably a Power BI Certification.

Preferred Skills, Knowledge and Experience:

  • SQL

  • Strong technical knowledge in SQL Server BI suite (SSIS, SSAS, SSRS). Preferably in Azure environment.

  • Microsoft Power BI, Tabular, power apps and/or any other visualization tools.

  • Knowledge in with Azure Data Lake, SQL Data Warehouse.

  • Any experience in Data Science (Machine Learning) programming using R or Python.

  • Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools.

Work Environment/Travel:

  • The position requires ability and willingness to travel domestically and internationally up to 20% of the time.

Senior Business Intelligence Analyst/Developer

*Please submit your CV in English.

PURPOSE OF POSITION:

The position will direct, organizes and leads Business Intelligence (BI) projects in the designing, developing and implementation of the solutions. It will work on a highly complex, cross-functional and enterprise IT group. It will also provide subject matter expertise for key BI core functions. Engage with the business SMES and contribute to artefacts of data architecture, data profiling, data curation, analysis design processes.

Overseeing the implementation of the Data Warehouse and maintenance of those solutions. Lead in development of strategy for integration and migration of data to data warehouse.

Provide support in creating and developing data request queries and reports through visualization.

MAJOR RESPONSIBILITIES:

Project/Work Planning:

  • Lead workstream planning process from inception, technical design, development, testing and delivery of BI solutions.

  • Participate in project management estimation process.

  • Assists in planning, implementation of data identification.

  • Analyze functional business processes and requirement.

  • Manages and plans for BI services.

Business Requirements:

  • Work with business partners to develop and analyze business intelligence needs.

  • Provides input to business requirements and functional specifications for the design and implementation of solution.

  • Interprets business requirements and determines optimum BI solutions to meet needs.

  • Interfaces with business partners to identify and provides input to new technology opportunities that will have an impact on the enterprise wide BI systems.

  • Leads interviews with end users to determine the requirements for data, reports, analyses, training, data quality and performance.

Design/Develop:

  • May work with Architects to design and develop BI applications/solutions.

  • Analyzes and tests new releases/versions of BI applications/solutions in order to determine rollout schedule, technical compatibility and identify and resolve integration issues.

  • Analyzes, designs, and develops query parameters, layout, filters, and analytics for business solutions.

  • Enhances the performance of business intelligence tools by defining data profiling, data to filter and index that adds value to the user.

  • Designs and develops and optimizes enterprise wide information “views” and custom reports.

  • Provides technical direction for the development of reports keeping usability, security and data integrity.

Testing:

  • May lead or provide technical direction for the planning, designing, and execution of testing efforts.

  • Develops, executes and documents test plans.

  • Reviews test plans and monitors testing process to ensure that business results are tested.

  • Provides support to test streams.

  • Resolves issues based on test results.

Support:

  • Provides adhoc, warranty, and post implementation phase support.

  • Troubleshoots solution outputs.

  • Recommends improvements of BI applications.

  • Optimizes BI applications or performs report and query tuning to improve performance.

  • Supports and helps manage external resources, such as service providers and vendor field support.

Info Quality Assurance:

  • Provides input to the development of information quality metrics.

  • Creates data quality tickets, as needed.

Research/Evaluation:

  • Researches tools, frameworks and mechanisms for data analytics.

  • Interfaces with vendors to keep abreast of new technologies, pricing and customer applicability.

  • Participates in vendor evaluations.

Policies, Standards, Procedures:

  • Adheres to current standards.

  • Provides input to policies, standards, and procedure for the form, structure and attributes of the BI tools and systems.

Training:

  • Designs and delivers end-user training and training materials.

  • Trains users to transform data into action-oriented information and to use that information correctly.

Coaching/Mentoring:

  • Provides guidance, training, and problem solving assistance to other team members.

  • Mentors less-experienced individuals.

KNOWLEDGE, SKILLS & ABILITIES:

  • Bachelors’ degree in Programming/Systems or Computer Science or other related field. Or specialized training/certification. Or equivalent work experience.

  • Experience in developing Data warehouse/Data Lake.

  • Experience in data analysis and data mining.

  • 5-7 years of related technical experience in designing and developing business intelligence tools and systems.

  • Knowledge of one or more business/functional areas.

  • Willingness and ability to travel domestically and internationally, as necessary.

  • Has the ability to manage and lead the team.

  • Specialized Training or BI certification.

Preferred Skills, Knowledge and Experience:

  • SQL

  • Strong technical knowledge in SQL Server BI suite (SSIS, SSAS, SSRS). Preferably in Azure environment.

  • Microsoft Power BI, Tabular, power apps and/or any other visualization tools.

  • Development skills with Azure Data Lake, SQL Data Warehouse.

  • Any experience in Data Science (Machine Learning) programming using R or Python.

  • Experience in Data modelling, Database design, normalization techniques using Database diagrams, Erwin, and other Data modeling tools.

Work Environment/Travel:

  • The position requires ability and willingness to travel domestically and internationally up to 20% of the time.

Customer Support Analyst II

*Please submit your CV in English.

PURPOSE OF POSITION:

The candidate is responsible for responding to customer requests by diagnosing and resolving problems and for supporting the ongoing technology needs of all employees by providing Level 2 and 3 help desk support. S/he works with a broad range of infrastructure products and complex client technology services and support area of IT. He/she works on multiple projects concurrently as a team member or as a technical lead.

S/he Candidate responds remotely or onsite to requests for IT support, logging problems, generating trouble tickets, diagnosing and resolving incidents and problems, and if necessary, escalating the problem to the appropriate level of expertise. S/he is responsible for documenting solutions to problems and developing end-user guidelines on an ongoing basis to improve customer support processes and practices. .

The role requires an understanding of the foundation architecture, hardware and software used by the organization. S/he demonstrate skill in various custom or packaged hardware and software. S/he have the ability to gather information on issues and have diagnostic capabilities to describe or resolve problems.

KEY RESPONSIBILITIES:

Service Desk:

  • First point of contact and day-to-day technical support to end users.

  • Responds to Level 2 support and works with vendors on Level 3 support.

  • Generates activity and status reports.

  • Provides the user access service.

  • Researches trouble issues which affect multiple clients.

  • Reviews checklists and scripts.

  • Works with vendor technical support personnel on solutions for clients.

  • Creates, modifies and reviews documentation of issues resolutions.

  • Develops and delivers documentation to ensure appropriate end-user support.

  • Creates and submits documented resolution to Knowledge Base.

  • Updates manuals/guides to incorporate new recommended products.

Client Technology Support:

  • Participates in deployment of new or upgrade information technology and infrastructure projects, including assisting co-workers and vendor partners.

  • Installs and performs minor repairs to hardware, software, and peripheral equipment, following design or installation specifications.

  • Updates configuration management tools.

  • Develops and documents procedures for performing configuration changes, updates and upgrades.

  • Provides on-going support of client technology.

  • Participates in integration and user acceptance testing.

Technical Support:

  • Ensures that all technical resources are available for meetings that include video conferencing.

  • Customer satisfaction achieved for video conferencing services.

  • Engages the hardware vendors on issues to remedy issues or escalates for support.

  • Monitors and communicates system status.

  • Diagnoses and resolves client workstation and mobile device hardware and software issues.

  • Creates temporary solutions until permanent solutions can be implemented.

  • Assists systems, programming and vendor professionals as needed to resolve problems.

  • Coordinates the resolution of escalated application, hardware and software problems.

Information Security:

  • Adheres to the integrity of controls, regulations and guidelines.

  • Reviews operation processes to ensure consistent approval and compliance.

  • Makes recommendations and changes as appropriate.

Inventory Management:

  • Maintains IT inventory management for all IT equipment and/or software in accordance with company policy and procedures.

Service Improvements:

  • Tracks performance metrics.

  • Reviews tracking log to identify recurring problems, or problems affecting a large number of clients.

  • Develops procedures and controls for service improvements.

  • Recommends solutions to common problems and updates frequently asked questions documentation.

Training:

  • Trains co-workers on new or existing functionality or services.

  • Identifies customer training needs based on common problems.

Communications/Consulting:

  • High level of customer satisfaction and productivity.

  • Alerts team members about recurring problems.

  • Communicates technical information to both technical and non-technical personnel.

Others:

  • Special assignments as appropriate to the role

  • Attend, participate in , and lead devotions/chapel as scheduled or convened.

  • While this job description is intended to be an accurate reflection of the duties involved in this position, World Vision reserves the right to add, remove, or alter duties when business needs dictates.

KNOWLEDGE, SKILLS AND ABILITIES:

  • Bachelor’s Degree in Computer Science, Information Systems, or other related field. Or equivalent work experience.

  • Technical Certification in one or more IT related disciplines or technology eg ITIL.

  • Demonstrated knowledge of complex hardware and software products and problem solving / diagnostic skills.

  • Typically requires 3-5 years of relevant technical and business work experience.

  • Willingness and ability to travel domestically and internationally, as necessary.

Preferred Skills, Knowledge and Experience:

  • Effective in written and verbal communication in English.

  • Strong ability to work as part of a team and coordinate with all staff.

  • Ability to relate technical issue to a largely non-technical audience.

  • Good problem solving and analytical skills.

  • Good customer service skills and experience.

  • Able to work under tight deadline and cope with pressure.