Senior Business Intelligence Analyst/Developer

17589-16G18044
Pasig City
11-Dec-20
International Role - No - Only National applicants will be considered.

*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.