Discover companies you will love

  • Assistant Manager , IT (Data Warehouse Architect)
  • 5 registered

Assistant Manager, IT (Data Warehouse Architect) | Join our dynamic team today!

Assistant Manager , IT (Data Warehouse Architect)
Full-time

on 2018-06-27

251 views

5 requested to visit

Assistant Manager, IT (Data Warehouse Architect) | Join our dynamic team today!

Full-time
Full-time

Share this post via...

Jelena Lim

Always on the hunt for individuals with the Scootitude!

flyscoot's members

Always on the hunt for individuals with the Scootitude!

What we do

Scoot™ is the low-cost, medium-to-long haul arm of the Singapore Airlines Group. Scoot took to the skies in June 2012 and merged with Tigerair Singapore in July 2017, retaining the Scoot brand and positioning it well for a new chapter of growth.

Why we do

Scoot offers an impeccable delivery service with personality, a contemporary feel and the choice to only pay for what matters to you. We announced ourselves to the world publicly on November 1st 2011 and, since then, we have grown spectacularly thanks to our customers and fans.

How we do

We want people with big smiles and even bigger personalities. People with passion—passion for travel, passion for people, passion for pushing boundaries. An airline with a different attitude. People with a different attitude. Scootitude™. If you think you have Scootitude and can handle the excitement and challenges ahead to grow with us, apply today! Receive information about vacancies and recruitment from Scoot Careers Facebook Page – "GOT Scootitude?"

As a new team member

The Data Warehouse Architect/Administrator role is an integral piece of the Information Management team. The successful candidates will be responsible for planning, designing and supporting data warehouse solutions and working with data warehouse technologies to come up with plans that best support the company’s data warehouse. Maintain integrity and stability of data warehouse to ensure it is running at optimum capacity and performance. Main Responsibilities - Plan, design and build data warehouse architecture and structures for the company’s enterprise data warehouse to meeting business data needs - Collect and Analyze key information, identify core business processes and construct conceptual data model - Locate data source and plan data transformations. Extracted large volumes of structured and unstructured data feed from different data sources, performed transformations and loaded the data into data warehouse using Dell Boomi integration tool - Performed data analysis and data validation from various data sources. Ensuring data integrity and accuracy - Work closely with other IT team and business users to clarify business requirements and translate the requirements into technical specifications - Experience in Master Data Management (MDM) implementation and deployment - Develop and maintain expertise in advance and/or emerging data warehouse and analytical information technologies such as Hadoop, in-memory analytics, data warehouse appliances, and data warehouse virtualization - Prepare designs for database systems and recommend improvements for performance - Maintain and develop various database scripts and tools to facilitate automation process Essential Skills - Candidates must have at least a Bachelor degree in Computer Science or equivalent. - A minimum of 2-3 years as Data Warehouse Architect/Administrator. - A minimum of 5-7 years of Data Warehouse/Big Data experience in design, development, implementation and support of company’s data warehouse - Strong understanding of data modeling in data warehouse environment such as start schema and snow flake schema - Knowledge of dimensional modeling and ETL process development using Dell Boomi integration preferred - Proficient in data extraction scripting languages (eg. Javascript, Groovy, MSSQL, RStudio) - Knowledge/Experience in data warehouse storage platform (eg Hadoop, Amazon S3) - Knowledge/Experience in QlikSense data analytic tool is preferred - Desirable Traits - Knowledge/ Experience with end users reporting tool - Knowledge/Experience with airline industry technology preferred - Candidates should possess strong analytical, problem solving, communication, and interpersonal skills - Good development and analytics skill set. - Able to conceptualize and formulate a feasible solution based on loosely-defined and abstract user requirements. - Able to work well with all levels of users and peers. - Able to be independent. - Able to plan and manage timeline - Candidate must be a strong team player, proactive, resourceful and self-motivated - Candidate who are able to multitask and work under pressure - Candidates with a proven track record for high quality standard

What we do

Scoot™ is the low-cost, medium-to-long haul arm of the Singapore Airlines Group. Scoot took to the skies in June 2012 and merged with Tigerair Singapore in July 2017, retaining the Scoot brand and positioning it well for a new chapter of growth.

Why we do

Scoot offers an impeccable delivery service with personality, a contemporary feel and the choice to only pay for what matters to you. We announced ourselves to the world publicly on November 1st 2011 and, since then, we have grown spectacularly thanks to our customers and fans.

How we do

We want people with big smiles and even bigger personalities. People with passion—passion for travel, passion for people, passion for pushing boundaries. An airline with a different attitude. People with a different attitude. Scootitude™. If you think you have Scootitude and can handle the excitement and challenges ahead to grow with us, apply today! Receive information about vacancies and recruitment from Scoot Careers Facebook Page – "GOT Scootitude?"

As a new team member

The Data Warehouse Architect/Administrator role is an integral piece of the Information Management team. The successful candidates will be responsible for planning, designing and supporting data warehouse solutions and working with data warehouse technologies to come up with plans that best support the company’s data warehouse. Maintain integrity and stability of data warehouse to ensure it is running at optimum capacity and performance. Main Responsibilities - Plan, design and build data warehouse architecture and structures for the company’s enterprise data warehouse to meeting business data needs - Collect and Analyze key information, identify core business processes and construct conceptual data model - Locate data source and plan data transformations. Extracted large volumes of structured and unstructured data feed from different data sources, performed transformations and loaded the data into data warehouse using Dell Boomi integration tool - Performed data analysis and data validation from various data sources. Ensuring data integrity and accuracy - Work closely with other IT team and business users to clarify business requirements and translate the requirements into technical specifications - Experience in Master Data Management (MDM) implementation and deployment - Develop and maintain expertise in advance and/or emerging data warehouse and analytical information technologies such as Hadoop, in-memory analytics, data warehouse appliances, and data warehouse virtualization - Prepare designs for database systems and recommend improvements for performance - Maintain and develop various database scripts and tools to facilitate automation process Essential Skills - Candidates must have at least a Bachelor degree in Computer Science or equivalent. - A minimum of 2-3 years as Data Warehouse Architect/Administrator. - A minimum of 5-7 years of Data Warehouse/Big Data experience in design, development, implementation and support of company’s data warehouse - Strong understanding of data modeling in data warehouse environment such as start schema and snow flake schema - Knowledge of dimensional modeling and ETL process development using Dell Boomi integration preferred - Proficient in data extraction scripting languages (eg. Javascript, Groovy, MSSQL, RStudio) - Knowledge/Experience in data warehouse storage platform (eg Hadoop, Amazon S3) - Knowledge/Experience in QlikSense data analytic tool is preferred - Desirable Traits - Knowledge/ Experience with end users reporting tool - Knowledge/Experience with airline industry technology preferred - Candidates should possess strong analytical, problem solving, communication, and interpersonal skills - Good development and analytics skill set. - Able to conceptualize and formulate a feasible solution based on loosely-defined and abstract user requirements. - Able to work well with all levels of users and peers. - Able to be independent. - Able to plan and manage timeline - Candidate must be a strong team player, proactive, resourceful and self-motivated - Candidate who are able to multitask and work under pressure - Candidates with a proven track record for high quality standard
0 upvotes

    0 upvotes

    What happens after you apply?

    1. ApplyClick "Want to Visit"
    2. Wait for a reply
    3. Set a date
    4. Meet up