Data Engineer 2 - Night Shift
About the job
- A minimum of 8 years of data engineering experience using extract, transform, and load (ETL) or extract, load, and transform (ELT) technologies.
- At least 6 years of ETL/ELT experience with IICS, Informatica, StreamSets, dbt, Python, Databricks, Snowflake, Azure Data Factory, or equivalent technologies.
- At least 4 years of hands-on experience with Snowflake.
- Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI.
- At least 3 years of hands-on experience in an Azure environment.
- At least 3 years of hands-on experience with agile methodologies.
- Experience with data warehouse, data lake, or data hub modeling.
- At least 3 years of hands-on experience with data standardization, conformance, or transformation processes.
- A solid understanding of master data management (MDM) and reference data.
- At least 3 years of hands-on experience with continuous integration and continuous delivery (CI/CD), especially in data engineering.
- Experience working in a SOX- and SOC 2-compliant environment.
- Experience with automated monitoring of data loads.
- Experience supporting a production environment.
- A strong understanding of technologies used in the industry and their impact, as well as enhancement management and product lifecycle development.
- Knowledge of source code version control systems such as Git, including branching and merging, resolving code conflicts, and three-way and baseless merges.
- Relevant experience working with third-party vendors to deliver results.
- A bachelor's degree in computer science, management information systems (MIS), or a related field is required.
- Develop and maintain ELT Snowflake data warehouse solutions.
- Collaborate with internal and external technology and business partners to implement product changes.
- Produce detailed design and unit test documents as required.
- Critically analyze business requirements, architect data solutions, and implement them.
- Define, develop, and maintain standards and processes to ensure effective ETL solutions.
- Maintain production systems.
- Work closely with the product manager to develop and execute action plans to address gaps.
- Recommend innovations that enhance or provide a competitive advantage to the organization.
- Communicate with business and technical teams.
- Mentor junior offshore developers to accomplish results.
- Build and continuously improve data engineering best practices.
- Automate processes to require no or minimal human intervention.
- Experience working in the insurance or reinsurance industry is highly desirable.
- Experience working with external data feeds to enrich internal data is desired.
About the company
Arch Capital Group Ltd. operates globally in three segments: Insurance, Reinsurance, and Mortgage. The Insurance segment covers specialty lines, the Reinsurance segment handles property and casualty risk, and the Mortgage segment provides mortgage insurance and reinsurance products. The company underwrites policies, sets premiums to match risk, and earns investment income from premiums and investments. By focusing on disciplined underwriting, risk management, and capital allocation, Arch Capital aims to maintain financial strength and sustainable profitability while growing through prudent risk transfer.
Company Size
N/A
Company Stage
IPO
Headquarters
Hamilton, Bermuda
Founded
1995
Get referred to Arch Capital Group
See people who can refer or advise you
Simplify's Take
What believers are saying
- Q2 2026 operating income reached $893 million, despite $201 million catastrophe losses.
- Book value per share rose to $68.04 by June 30, 2026.
- Arch’s June 2026 leadership consolidation under Maamoun Rajeh sharpens accountability across segments.
What critics are saying
- Q2 2026 net premiums written fell 6.9%, showing slowing growth into softening markets.
- Insurance segment underwriting income dropped to $27 million in Q2 2026, pressuring profitability.
- Higher-priced 2036 and 2056 notes replaced cheaper 2026 debt, lifting future interest costs.
What makes Arch Capital Group unique
- Arch’s 25-year underwriting record produced 18.0% Q2 2026 annualized ROE.
- Arch’s three-segment model diversifies specialty insurance, reinsurance, and mortgage earnings.
- Arch repurchased $1.95 billion in 2026 first-half shares, signaling capital discipline.
Help us improve and share your feedback! Did you find this helpful?
Benefits
Hybrid Work Options
Company News
Arch Insurance North America has launched a new US-based transactional liability team to expand its transactional risk insurance capabilities. The business will initially focus on Representations & Warranties and Tax coverage products. The new team is led by William Carson, who joined Arch from Everest where he served as Head of Transactional Risk, North America. Carson reports to Chris Christon, Senior Vice President, Executive Assurance. Arch Insurance has been active in the transactional risk market for over 15 years through various partners and channels across North America, Bermuda and the United Kingdom. The direct US platform complements Arch's existing distribution model and multi-channel approach. Anne Hardner, Executive Vice President, Executive Assurance for Arch Insurance, said the expansion reflects Arch's broader commitment to the transactional risk marketplace and will allow the company to strengthen its market presence and better serve brokers and clients.
- **Bond Offering Size**: Arch Capital Group announced the pricing of $2 billion in senior notes, with 5.250% notes maturing in 2036 and 5.950% notes ...
Novella, the artificial intelligence (AI)-powered wholesale insurance broker, has announced it raised $21 million to recruit a team of brokers, continue deve...
Comeryx is the first fully digital platform purpose-built for the small business artisan contractors market. We replace manual friction with an autonomous decision engine, enabling wholesalers to quote, bind, and issue complex risks in minutes, not days.
Rainbow, San Francisco, CA-based provider of a digitally-enabled managing general underwriter building tailored small business insurance products, raised $12M in funding