Datawarehouse Developer Level II

Arch Global Services (Philippines) Inc.; Cebu City; On-site; PHP 2,276,608 - 3,414,912; Full time

Job summary

A leading global service provider is seeking a Senior Datawarehouse Developer in Cebu City. You will be responsible for the development and maintenance of the Reinsurance Datawarehouse Application and will work closely with product management and business teams. The ideal candidate should have extensive experience in Datawarehouse development, specifically with ETL/ELT technologies such as Azure Data Factory and SQL. Strong analytical skills and the ability to thrive in a fast-paced, deadline-driven environment are essential for this role.

Qualifications

• Minimum of 3+ years of Datawarehouse development experience using ETL/ELT technologies.
• Experience working in insurance or reinsurance industry – desired.
• Strong understanding of technologies utilized in the industry.

Responsibilities

• Development and maintenance of Reinsurance Datawarehouse Application.
• Collaborate with internal and external technology and business partners.
• Communicate effectively with both the business and technical teams.

Skills

Datawarehouse development experience

ETL/ELT using Azure Data Factory

Python

Experience in Azure environment

Agile methodologies

Data Modeling

Source code version control systems like Git

Education

Bachelor’s degree in Computer Science

Tools

Azure Data Factory

Data Bricks

SQL

Snowflake

Job description

Job Summary

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.

Job 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

Required Skills

• Minimum of 3+ years of Datawarehouse development experience using ETL/ELT technologies.
• ETL/ELT experience working with Azure Data Factory, Data Bricks, SQL
• Experience with Python and Snowflake
• 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

Education

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