Senior Analyst and Data Modeler

19792-15G10054
Pasig City
25-Sep-21
International Role - No - Only National applicants will be considered.
2+ Years

*Please submit your CV in English.

PURPOSE OF THE POSITION:

This position is primarily responsible for building new and optimizing existing data models for financial and data analysis. This position is also responsible to engage and collaborate closely with business owners and SMEs in the production of enterprise wide PowerBI Data models. This position requires strong technical skills in Microsoft business analytics particularly with DAX formula language and Power BI Data Modeling. This position must be able to translate and transform highly complex business requirements, and using specialized, complex and large financial data, develop data models that will lead to high-quality, data-driven decisions. This requires strong communication and collaboration skills, as well as strong financial analysis and reporting skills.

KEY RESPONSIBILITIES:

  • Collaborate with business owners, subject matter experts and other stakeholders to evaluate the reporting requirements.

  • Understand the needs of the customers and translate this into PowerBI Data models.

  • Design, develop and deploy Power BI Data models that will be the basis of financial reporting and analysis for Global Finance Solutions.

  • Review and continuously develop and optimize existing Power BI Data models and datasets that adapts to the latest advancement in the Microsoft Power Platform, and integrate seamlessly with other financial systems and tools used in Global Finance.

  • Collaborate with teams within and outside Global Finance, including WVIT and external vendors, to evaluate, determine and recommend solutions that will optimize and increase efficiency of data models

  • Develop and publish specialized and usually complex financial reports, and analysis for senior leadership, directors, and other stakeholders.

  • Hand-over for business-as-usual and regular operations the models and reports that have been built. Effectively train business units on the data model or financial report so they can sustainably and in the long-term manage and maintain the models or reports.

  • Continuously learn, recognize, develop, and adopt best practices in data modeling, reporting and analysis, automation, data integrity, data analysis, validation and tools.

  • Assess and recommend innovations in PowerBI that are relevant for Global Finance and GFS, in particular.

  • Teach and train others on PowerBI, and PBI Data Modeling more specifically.

  • Attend and participate in meetings, team events, conference that may be assigned.

  • Attend and participate in chapel services, daily and group devotions.

  • Promote World Vision’s values through example and hold self and others accountable for the same across the team.

  • Perform all other duties that may be assigned.

KNOWLEDGE, SKILLS AND ABILITIES:

  • Minimum 6 years of experience in finance or accounting functions preferably in an international non-profit organization or multinational corporation

  • At least 3 years of experience with business intelligence tools and financial software (e.g. Sunsystems, OLAP, Datawarehouse, Dashboards) and reporting tools

  • Some experience in DAX calculations/codes

  • Some experience in Power Query or M language 5.

  • Bachelor or University degree in Accounting, Finance or Business or Computer Science

  • Excellent skills in structured problem solving and ability to perform complex analyses and draw meaningful and actionable insights.

  • Proven technical expertise on Data Transformation, Data flows, Financial Reporting and Dashboards.

  • Extensive and advanced knowledge in all areas of finance and accounting

  • Proven expertise in and advanced skills in PowerBI Ddata modelling

  • Proven ability to write complex DAX code for data manipulation

  • Strong ability to understand multiple data sources and how they relate to each other

  • Strong technical skills in Microsoft Office

  • Excellent communication skills, both verbal and written at all levels with a high degree of accuracy and attention to detail: ability to communicate technical information to non-technical audiences.

  • Demonstrated ability to think independently and recommend best practices

  • Superior organization, prioritization, and self-motivation skills.

  • Fluency in English is required.

Work Environment/Travel:

  • The position requires ability and willingness to travel less than 5% of the time.

  • Ability to work within an office environment and flexibility to work across all time zones in which World Vision functions.