2024-7360_Data Warehouse Developer - Level II

Arch Global Services (Philippines) Inc.; Cebu City; On-site; PHP 800,000 - 1,200,000; Full time

Job summary

A leading global insurance firm is seeking a Datawarehouse Developer in Cebu City to develop and maintain its Reinsurance Datawarehouse Application. The role involves collaboration with both internal and external partners and requires at least 3 years of experience in ETL/ELT technologies. Ideal candidates should have a Bachelor's degree in a relevant field and a strong understanding of Data warehouse concepts.

Qualifications

• 3+ years of Data warehouse development experience using ETL/ELT technologies.
• Experience in the insurance or reinsurance industry is desired.
• Strong understanding of data conformance process.

Responsibilities

• Develop and maintain Reinsurance Datawarehouse Application.
• Collaborate with business and technology partners.
• Analyze business requirements and implement Data warehouse solutions.

Skills

ETL/ELT experience with Python

Experience with Data bricks

Experience with Snowflake

Experience in Azure environment

Knowledge of Data warehouse concepts

Experience with Data Modeling

Experience with external data feeds

Experience with CICD processes

Strong understanding of industry technologies

Knowledge of version control systems like Git

Education

Bachelor's degree in Computer Science

Job description

Overview

Arch Capital Group Ltd. is a Bermuda-based company which provides insurance, reinsurance and mortgage insurance on a worldwide basis. Arch Capital Services Inc. provides support and expertise to entities across ACGL to help them operate effectively and efficiently. Arch is committed to helping its associates create what’s next by providing access to a variety of programs supporting your professional development and a culture that encourages innovation, collaboration and professional growth. We seek talent that thinks innovatively, values collaboration and will go the extra mile to serve our customers and develop our company.

Job Description

Shift Assignment: Mid Shift

The Datawarehouse Developer has responsibility of development and maintenance of Reinsurance Datawarehouse Application used extensively by Reinsurance business teams. The Senior Datawarehouse Developer will work closely with the rest of the Arch Re product management team and business peers to effectively execute Datawarehouse project initiatives. This person should be able to deliver in a fast-paced and deadline-driven environment.

Responsibilities

• Development and maintenance of Reinsurance Datawarehouse Application
• Collaborate with internal and external technology and business partners to implement product changes
• Produce detail design and unit test documents, as required
• Critically analyze business requirements, architect and implement Datawarehouse solutions
• Define, develop and maintain standards and processes to ensure effective ETL solution
• Production maintenance
• Work closely with product manager to develop and execute action plans to address gaps
• Recommend innovations that enhance and/or provide a competitive advantage to the organization
• Communicate effectively with both the business and technical teams

Qualifications

• ETL/ELT experience working with Python, Data bricks, Snowflake and ADF
• Experience working in Azure environment
• Experience working in insurance or reinsurance industry – desired
• Experience with agile methodologies
• Knowledge with Datawarehouse concepts
• Experience with Data Modeling
• Experience working with external data feed to enrich internal data - desired
• Experience with data conformance process
• Experience with CICD process (good to have)
• Experience building Datawarehouse solution to support finance close process
• Experience monitoring and supporting production database and server environment
• Strong understanding of technologies utilized in the industry and the ability to see their impact as well as enhancement management and product lifecycle development
• Knowledge of source code version control systems such as Git including branching/merging, resolving code conflicts, and 3-way and baseless merges
• Relevant experience working with 3rd party vendors to deliver results
• Minimum of 3+ years of Datawarehouse development experience using ETL/ELT technologies

Education

• Bachelors’ degree in Computer Science, Management of Information Systems, or related field required

Note: Please refer to job description.