Lowongan di PT. Cygnet Pericon

Cygnet Pericon is a provider of Business Intelligence (BI) and Regulatory Compliance Solutions for the Financial Services Industry in the Asia Pacific region. Our BI solution helps business organizations deliver profitable customer acquisition and retention strategies, timely and focused answers for risk management concerns, and the insight to track, understand and manage corporate performance. We also leverage on our partners' knowledge and world-class experiences to deliver global products and solutions localized to the needs of our customers.

For our Jakarta office, we are looking for a:

Business Analyst

POSITION DESCRIPTION
To analyze, develop, implement and maintain an automated regulatory reporting product for banks using an industry proven software toolset.

PRIMARY RESPONSIBILITY
1. Analyze, specify, develop and maintain reporting requirements of the regulatory bodies in Indonesia.
2. Provide support for the developed product.

QUALIFICATIONS
Education:
1. Preferable to hold a formal accounting qualification.

Experience:
1. Current and complete knowledge of Indonesian regulatory reporting regime (LBU Basel2, LLD, LHBU, SID, LKPBU, etc.)
2. Several years experience in the banking industry.
3. Self-starter with the ability to work independently
4. A team-worker that shares information and knowledge with the other team-members
5. Able to adopt a structured approach to projects and the ability to set priorities

Specific Knowledge Requirements:
1. Thorough expertise in Banking Instruments
2. Expertise in Risk Measurement and Liquidity is a strong asset
3. Back-office banking systems, accounting systems and procedures especially in reporting, interfacing to these systems and data extraction
4. Computer literate, familiarity of the PC in a windows environment and productivity tools like MS-Office Products
5. Good understanding of databases, storing data, general approach to data retrieval
6. Professional knowledge of English and Bahasa Indonesia


Data Warehouse Analyst

POSITION DESCRIPTION
As a Data Warehouse Analyst you perform database analysis and design in solving complex problems. You define architecture, including database structures and metadata, and develop and maintain best practices for data extraction, data loading, and data transformation into and out of a data warehouse or data mart.

KEY RESPONSIBILITIES
To lead and consult on all the stages within the data warehouses and data environments:
* • overall design, implementation, integration of data warehouses and data environments
* • construction and testing, including data design, database architecture, metadata and repository creation

QUALIFICATIONS
Education:
A degree holder in Computer Science, Information System.

Experience:
1. Provide technical oversight and direction to Data Warehouse and business intelligence design and development activities
2. Define and maintain the Data Warehouse Target Architecture
3. Define the future state of the Data Warehouse domain
4. Develop plan to achieve the Data Warehouse Target Architecture
5. Leverage the client’s Enterprise Architecture Relationship
6. Partner with Solution Architects to define the future state based on analytical requirements from each business vertical.
7. Thorough understanding of Data Warehouse technologies.
8. Extensive data profiling, data modeling, entity-relationship modeling and dimensions modeling experience.
9. Expert SQL skills on SQL Server.
10. Brand name ETL tool experience, with expertise in developing complicated ETL mappings.
11. Understanding dimensional and 3NF data architectures
12. Understanding of business processes, workflow, data mapping and cross-data integration in complex data warehouse environments.
13. Extensive experience transforming business requirements into technical specifications and source-to-target mappings.
14. Experience with relational (OLTP) and dimensional (BI/ Data Warehouse) databases
15. BI and Data Warehousing best practices and industry standards.
16. Demonstrated leadership skills and experienced driving to solutions in a team environment.


ETL – Business Objects Designer/Developer

POSITION DESCRIPTION
Analysis, design, implementation and support of extract, transform and load (ETL) processes to support a Risk Management/Regulatory Reporting/Financial Reporting.

KEY RESPONSIBILITIES
1. Liaise with data source expert(s) to understand the underlying database for extraction purposes, liaise with Business Analyst(s) to design jobs, work flows and data flows to perform transformation required to populate the target database.
2. Conduct testing and tuning of the developed ETL jobs to ensure system correctness, completeness and high performance execution.
3. Ensure proper documentation for each developed ETL jobs

QUALIFICATIONS
Education:
A degree holder in Computer Science or Information System.

Experience:
1. Proficient in designing, developing, and implementing ETL solutions and providing quality data services. Oracle Warehouse Builder experience and Strong PL/SQL experience is desirable. SQS Server Integration Services (SSIS) experience preferred.
2. Proficient in analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications.
3. Minimum 1-3 years experience in querying and analyzing data sources to understand the data and determine logic for data transformations.
4. Experience working in the Banking industry is a plus.
5. Proficient in data analysis, defect identifications and resolutions.
6. Excellence in oral/written communications in English, interpersonal relations, and team cooperation.
7. Self-starter with the ability to work independently.
8. Able to adopt a structured approach to projects and the ability to set priorities.

Specific Knowledge Requirements:
1. Familiarity with Oracle data warehousing features such materialized views, bitmap indexes, IOTs, external tables, etc. especially as ETL pertains to them.
2. Experience with Business Objects preferred.
3. Experience with Oracle 10g or 9i preferred.
4. Experience with SQS Server Integration Services (SSIS) preferred.


SharePoint / .Net Developer

POSITION DESCRIPTION
This position requires a developer that has extensive (min. 1-3 years experience) in developing custom application (e.g. HR application, loan origination, etc) for banking purposes.

KEY RESPONSIBILITIES
1. Work with customers to understand their business requirements
2. Think outside the box to provide solutions that stretch capabilities and provide users with a rich and user friendly portal interface
3. Overall understanding of the application and how it addresses customer needs
4. Reporting/communication with Project Manager
5. Create and implement development standards and methodology
6. Potential On-Call duties

QUALIFICATIONS
Education:
A degree holder in Computer Science or Information System.

Experience:
1. Experience working in the Banking industry preferred
2. Design of multi-tier Web based solutions on the Microsoft .NET platform
3. Anticipate, mitigate, identify, troubleshoot, and resolve SharePoint problems.
4. Web Technologies: HTML/DHTML/XHTML/XML, XSLT, JavaScript, VBScript, CSS, ASP, .NET, Web Services
5. Relational Database Experience in SQL Server delivering database-based Web pages, data modeling and design, SQL language skills including design of event triggers and stored procedures
6. Web Design, Layout, and Development - special consideration given to advanced Web part development
7. Work as the project architect on functional and technical solutions considering usability and performance during all phases of development
8. Ensure the integrity and security of SharePoint data in accordance with business needs and industry best-practices regarding privacy, security, and regulatory compliance.
9. Proficient in data analysis, defect identifications and resolutions
10. Excellence in oral/written communications in English, interpersonal relations, and team cooperation
11. Self-starter with the ability to work independently
12. Able to adopt a structured approach to projects and the ability to set priorities
13. 1-3+ years applications development experience including design, coding, testing, and implementation
14. Strong organizational, written and verbal communication skills


Technical Consultant

POSITION DESCRIPTION
An entry / junior level position for Analysis, design, implementation and support of extract, transform and load (ETL) processes to support a Risk Management/Regulatory Reporting/Financial Reporting.

KEY RESPONSIBILITIES
1. Liaise with data source expert(s) to understand the underlying database for extraction purposes, liaise with Business Analyst(s) to design jobs, work flows and data flows to perform transformation required to populate the target database.
2. Conduct testing and tuning of the developed ETL jobs to ensure system correctness, completeness and high performance execution.
3. Ensure proper documentation for each developed ETL jobs

QUALIFICATIONS
Education:
A degree holder in Computer Science or Information System.

Specific Requirements:
1. Proficient in designing, developing, and implementing ETL solutions and providing quality data services.
2. Proficient in analyzing business/data requirements, writing metadata definitions, and writing data mapping specifications.
3. Experience in PL/SQL or Oracle is desirable.
4. Course work and experience in database as well as in querying and analyzing data sources to understand the data and determine logic for data transformations are preferred.
5. Proficient in data analysis, defect identifications and resolutions.
6. Excellence in oral/written communications in English, interpersonal relations, and team cooperation.
7. Self-starter with the ability to work independently.
8. Able to adopt a structured approach to projects and the ability to set priorities.

NOTE: Only those candidates meeting the criteria above will be considered.

WE OFFER
In addition to a casual yet dynamic work atmosphere, we offer competitive compensation and benefits and the possibility to participate in international projects in Asia.

Interested? Contact our HR department now! Please send e-mail to: hrd2010@cygnetpericon.com
http://www.cygnetpericon.com