Report Analytics Developer

Two95 International Inc.; Petaling Jaya; On-site; MYR 60,000 - 80,000; Full time

Job summary

A global technology solutions provider in Petaling Jaya is seeking an experienced Data Analyst to develop and support enterprise applications. The role involves delivering analytics from various data sources, collaborating with technical teams, and requires strong knowledge in data modeling and business intelligence tools. Ideal candidates will have at least 2 years of relevant experience and a Bachelor's degree in a related field.

Qualifications

• Min 2 years solid experiences in Data Analysis, preferably in Data Modelling.
• Excellent in preparing presentations and able to articulate insights.
• Hands on and proficient in NoSQL, RDBMS, CQL, PL/SQL.

Responsibilities

• Responsible for end to end delivery of reporting and analytics.
• Develop report prototypes and fine tune deliverables.
• Collaborate with local and USA technical teams.

Skills

Data Analysis

Business Intelligence

Agile development

SQL

Communication skills

Education

Bachelor Degree in Computer related field

Tools

Amazon Redshift

Tableau

Ms SQL Server

Oracle

Job description

This role is responsible for developing and supporting various global enterprise applications from onsite premise to cloud based Data Warehouse, Business Intelligence and Data Analytic solutions. These solutions integrate closely with our application, hosted on AWS (Amazon Web Services) for internal employees and an external portal for our contractual parties.

Key Responsibilities

• Responsible for end to end delivery of reporting and analytic capabilities from various data sources to meet business requirements across corporate functions worldwide.
• Develop report prototypes and fine tune report deliverables.
• Excellent in preparing presentations and able to articulate insights/trends/variance from data Analysis.
• Perform unit testing and data validation.
• Produce metrics, creating documentation, and process workflows.
• Provide support as required to ensure the availability and performance of developed reports and dashboards.
• Collaborate with local Technology Team on a day-to-day basis and with USA technical team on need basis. When required, must be flexible in schedule to facilitate real time communication with offshore team via Skype, phone, or other tools.

Experience

• Min 2 years solid experiences in Data Analysis preferably Data Modelling, Trending, Prediction and Forecasting etc.
• Hands on and proficient in NoSQL, RDBMS, CQL, PL/SQL, T-SQL or any other DB technologies.
• N-Tier enterprise application development in a distributed environment.
• Completed at least 2 full Agile development life cycles.
• Knowledge of logical and physical data modelling concepts (relational and dimensional).

Qualification

Min Bachelor Degree in Computer related field or equivalent work experiences.

Skills

• Databases – Amazon Redshift, Cassandra, Ms SQL Server, Oracle, Postgres, OrientDB.
• BI Tools – Business Objects, Tableau, Ms Excel.
• Scripting - CQL, PL/SQL, T-SQL, SQL, Java, Unix/Linux Shell.
• Data Modelling – Star schema, Snowflake schema, Galaxy schema.
• Good troubleshooting and analytical skills.
• Excellent communication in English and inter-personal skills.
• Experience with rapid release software (continuous delivery) development practices (Agile/Scrum).

Ability

• Able to work independently with minimal supervision.
• Excellent team player contributing to the team success.
• Ability to work and collaborate with remote team.
• Ability to communicate difficult technical concepts in a straight-forward, simple manner.
• Passion for innovation and technology.

Added Advantage

• Experience / Knowledge in large distributed systems, Hadoop, Ms SQL Server Integration Services, Unix Shell Scripting, JIRA, GitHub, Jenkins.
• Experience working in Royalty systems or within Music Publishing industry.