Be an early applicantLess than 25 applicants

Company

Arch Capital Group Ltd. · 3 hours ago

Lead Data Engineer - Remote, (Eastern Time)

Jersey City, NJ

Full-time

Remote

Senior Level, Lead/Staff

$149K/yr - $201K/yr

10+ years exp

Maximize your interview chances

FinanceFinancial Services

Comp. & Benefits

H1B Sponsor Likely

Insider Connection @Arch Capital Group Ltd.

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Handle multiple projects in parallel, participate and deliver solution design while working closely with the architecture

Design and Develop/Review ETL programs primarily using modern ETL tools like Matillion, DBT , and Python

Coach and guide the technical team in terms development of ETL jobs

Provide performance improvement and tuning of data pipeline.

Perform technical reviews, data validation, and end to end testing of ETL objects, source data analysis and data profiling

Create necessary documentation as per the standards and update the project documentation

Support QA on end-to-end testing and provide daily/weekly project status to the project manager

Work with deployment team in the code migration across the environments

Triage the Production issues and work on the code fixes

Proven experience in database administration with cloud data platforms like Snowflake

Frees up data engineers and analysts from administrative tasks

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

ETL DevelopmentMatillionSnowflakePythonAzureAgileSQLPower BIDBTDimensional ModelingData VaultDevOpsData Profiling

Required

10+ years of experience in implementation of BI projects in a large-scale enterprise data warehouse environment

Hands-on experience in building large cloud data warehouses using Snowflake; including database architecture design, data transformations, stored procedures, account and security principles, performance management, etc.

Experience with cloud computing services, particularly deploying and running services in Azure

Expert-level understanding of Agile, SDCL, CI/CD, DevOps, GitOps, and ProdOps.

A team player with excellent verbal and written communication skills

Experience with other ETL tools like Matillion, ADF, and DBT

Advance SQL knowledge and familiar with relational, Vault, and dimensional modeling

Knowledge of Power BI

Required knowledge and skills would typically be acquired through a bachelor’s degree in information technology or related field

Preferred

Financial industry data fluency is preferred but not required

Company

Arch Capital Group Ltd.

Glassdoor

4.1

Arch is a leading global insurer with operations in more than a dozen countries.

Founded in 1995

Hamilton, Hamilton, BMU

5,001-10,000 employees

https://www.archgroup.com

H1B Sponsorship

Arch Capital Group Ltd. has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (4)

2022 (19)

2021 (11)

2020 (12)