2024-7360_Data Warehouse Developer - Level II

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.

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.

• 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

• 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.

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