Business Intelligence Analyst (sql Programmer)

Ortigas, Philippines

Job Description

GENERAL FUNCTIONResponsible for the monitoring business trends and metrics, and conducts real-time assessment and historical review to identify high-risk and suspicious transactions, to avoid or deter any fraudulent activities from happening.DUTIES AND RESPONSIBILITIES Business Intelligence and Reporting

  • Ensures that all regular reports are accurate and sent on time.
  • Conduct and coordinate financial, product, market, operational and related research to support strategic and business planning
  • Interpret, evaluate and interrelate research data and develop integrated business analyses and projections for incorporation into strategic decision-making
  • Plan and coordinate the development of market research studies in support of strategic planning and specific marketing initiatives, as required and presents findings of studies
  • Perform daily, weekly and monthly reviews and analyses of current processes using operational metrics and reports
  • Suggest changes to senior management using analytics to support your recommendations. Actively participate in the implementation of approved changes
  • Create informative, actionable and repeatable reporting that highlights relevant business trends and opportunities for improvement
  • Conduct insightful, ad hoc analyses to investigate ongoing or one-time operational issues
  • Performs other tasks as directed by immediate superior.
  • Provide regular reports on daily audits, relevant findings on fraud investigations and periodic analysis
Database Management
  • Help ensure the accuracy of daily data generated and archived
  • Develops effective process to ensure management and storage of database
  • Automates periodic or seasonal reports through queries needed in business analysis
  • Ensures management of database design and security
  • Continuously explores and tests new database and data handling systems to better improve management of data
  • Monitors database efficiency and optimizes storage capacity
  • Assists in troubleshooting any problems encountered in data generation and report creation
  • Develops protocols for data processing, data extraction and manipulation
  • Creating complex query definitions that allow data to be extracted and/or to automate regular reports
  • Training colleagues in how to input and extract data to comply with the database requirement
  • Ensures that only authorized individuals are able to access and manipulate confidential data
  • Coordinates with other departments to cater reports needs and data storage
Fraud Analytics
  • Monitor real time queues from different transactions such as account creation, bet placement deposit and withdrawal, to identify fraudulent activity like account take over or sharing, theft and similar other risks.
  • Anticipate and identify fraudulent transactions, validate information through thorough investigation and cancel them from further processing.
  • Resolve queued transactions within the service level agreements to reduce potential revenue losses.
  • Diligently follow investigation and escalation procedures while ensuring the integrity of any findings
  • Monitor constantly customer and transactional records to identify unauthorized transactions and fraudulent accounts.
  • Ensure confidentiality of all information collected during investigation as well as any result thereof.
  • Determine existing fraud trends by analyzing accounts and transaction patterns.
  • Identify system improvements to prevent fraudulent activities.
  • Recommend anti-fraud processes for changing transaction patterns and trends based on customer behaviors.
  • Provide relevant feedback regarding the fraud and risk management process flow and services, and proposes appropriate solutions to identified challenges
  • Provide recommendations for improving existing processes within scope of role
User Access
  • Ensures that all profile creation of staff/players/outlets are within mandated access limitations
  • Monitor and review provided access from time-to-time to assess if it falls within the scope of work
  • Responsible in ensuring activation or deactivation of staff or shop till access depending on operational protocol and needs.
Administrative Affairs
  • Adheres to all the company's administrative policies and procedures and enforces the same
  • Ensures the positive reflection of the company's image through appropriate behavior and demeanor in conducting company business
QUALIFICATIONS AND REQUIREMNETS
  • With relevant experience in a similar role/responsibility
  • Adept with various reporting tools and software especially MS Excel/Oracle SQL/GCP Big Query
  • Has good organizational skills
  • Detail oriented, analytical and inquisitive
  • Has advance computer skills - MS Office, Internet, Outlook
  • Has good numerical and analytical skills
  • Has good communication and interpersonal relationship skills
  • Has basic knowledge in sports
  • Willing to render overtime and/or be on shifting schedule
  • On-call even during weekends and holidays
  • Can coordinate with various personnel across the company
  • Able to understand business needs and has the initiative to create improvements when necessary
PERSONAL ATTRIBUTES
  • Well-groomed with pleasant personality
  • High personal integrity
  • High level of initiative and resourcefulness
  • Diplomatic and tactful
  • Can work under pressure with minimal supervision
  • Has a strong sense of responsibility and urgency
Job Types: Full-time, PermanentSalary: Php28,000.00 - Php35,000.00 per monthBenefits:
  • Health insurance
  • Life insurance
Schedule:
  • 8 hour shift
  • Shift system
Supplemental Pay:
  • 13th month salary
  • Overtime pay
Application Question(s):
  • Willing to work in the office?
  • Can work on shifting schedule?

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD1060819
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Ortigas, Philippines
  • Education
    Not mentioned