OLAP Developer

TRC Group; Singapore; On-site; SGD 60,000 - 80,000; Full time

Job summary

A dynamic technology firm in Singapore is seeking an experienced Analysis Services Developer to develop and support OLAP solutions. The role involves collaborating with management to optimize data structures, ensuring high data accuracy, and deploying changes to production while adhering to strict timelines. A Bachelor's degree in Information Technology and a minimum of 4 years of experience with MS OLAP technology are required. This permanent role offers attractive staff benefits, including travel perks.

Benefits

Attractive staff travel benefits

Industry benefits

Qualifications

• Proven hands-on experience designing, developing and supporting OLAP processing.
• Minimum 4 years experience as an OLAP Developer using Microsoft technology.
• Demonstrated experience in user requirements gathering.
• High proficiency in SQL, specifically TSQL.
• Ability to manage multiple tasks effectively.

Responsibilities

• Develop and support OLAP cubes using Microsoft Analysis Services.
• Monitor OLAP query and build times for optimizations.
• Correct issues with OLAP in the production system.
• Collaborate to redesign data structures to optimize processing.
• Ensure quality control for all OLAP cube components.

Skills

OLAP development

SQL

TSQL

Business analysis techniques

Interpersonal and communication skills

Education

Bachelor's degree in Information Technology or related discipline

Tools

SQL Server Integration Services

Job description

Analysis Services Developer

Reporting to the Analysis Systems Manager the key responsibilities of this role are :

• Development and support of OLAP cubes using Microsoft Analysis Services 2008 R2
• Development and support of associated SQL and SSIS procedures and batch processes
• Delivery of data to the enterprise with a high level of accuracy and in a rigid timeframe.
• Meet user requirements for analysis solutions and deploy to the production environment

To be considered for this role you’ll have :

• Proven hands‑on experience designing developing and supporting OLAP processing in a demanding environment.
• Minimum 4 years experience as an OLAP Developer and using Microsoft technology
• Demonstrated experience in interfacing with internal clients regarding information delivery
• Demonstrated experience in the production of information from data
• Experience and a strong understanding of business analysis techniques used when eliciting systems requirements from users
• High proficiency in the use of SQL in particular TSQL
• Proven experience and capability to deliver data to the enterprise in a rigid timeframe.
• Proficient in database design techniques relational and dimension designs
• Ability to manage multiple maintenance enhancement and project related tasks
• Excellent interpersonal and communication skills

You will :

• Meet user requirements for analysis solutions and deploy to the production environment
• Proactively monitor OLAP query times and identify opportunities for redevelopment of packages to meet acceptable query times
• Proactively monitor OLAP build times and and configuration of the production environment to optimise processing times
• React to incidents and provide immediate response
• Correct issues with OLAP in the production system ensure root cause is identified and corrective steps are actioned
• Identify opportunities to refine processes to reduce time taken for reports to execute
• Collaborate with Data Warehouse Manager and Reporting Systems Manager to identify opportunities to redesign data structures to reduce system load
• Deploy changes to production according to change control processes
• Ensure all components of the OLAP cubes are tested and quality controlled.
• Ensure all development work is carried out in an environment where source code is controlled and change control is carefully managed.

Additional Information

• 1. Analysis Services Developer
• 2. Introductory bullet points
• Challenging dynamic role in aviation industry
• Fast growing company
• Singapore based with attractive staff travel and industry benefits
• Permanent position
• 3. Broad information about the role :

This role requires an experienced Analysis Services (MS OLAP) Developer with a track record of understanding complex data schemas and working in a demanding environment. The successful applicant will be highly productive with a history of interpreting users requirements and building high performing and accurate OLAP solutions.

• 4. Reporting line :

Reporting to the Analysis Services Manager the key responsibilities of this role are :

• See responsibilities on page 1
• 5. Employment conditions for example :

This is a permanent role. A 3 month probation period applies.

• 6. Experience / skills required for example

  To be considered for this role you’ll have :

  • Bachelors degree in Information Technology or related discipline
  • Four or more years experience in working with MS OLAP technology
  • Demonstrated experience building new OLAP solutions and deployment
  • Demonstrated experience interacting with users for requirements and analysis on queries
  • Proven ability to work both autonomously and as a member of a team.
  • Experience with SQL Server Integration Services would be well regarded.

Key Skills

Drawing,GP,Administration,Data Management,Arabic Faculty

Employment Type : Full Time

Experience : years

Vacancy : 1