Lead Data Engineer - Remote, (Eastern Time)

Arch Capital Group Ltd.; Jersey City (NJ); Remote; USD 148,000 - 202,000; Full time

Job summary

Arch Capital Group Ltd. is looking for a Lead Data Engineer to join their Corporate IT team, focusing on data integration solutions for their Analytics platform. The position requires advanced knowledge of ETL development and cloud technologies, with a salary range of $148,614 to $201,066, reflecting the need for expertise in a collaborative environment.

Qualifications

• Over 10 years of experience in BI projects.
• Expert-level understanding of Agile, SDCL, CI/CD.
• Advance SQL knowledge and familiarity with relational modeling.

Responsibilities

• Design and develop ETL programs using Matillion and Python.
• Validate, test, and document data integrations.
• Triage production issues and coach the technical team.

Skills

ETL development

Data modeling

Cloud technologies

Agile methodologies

SQL

Education

Bachelor’s degree in information technology

Tools

Matillion

Snowflake

Power BI

DBT

Azure

Job description

Join to apply for the Lead Data Engineer - Remote, (Eastern Time) role at Arch Capital Group Ltd.

Join to apply for the Lead Data Engineer - Remote, (Eastern Time) role at Arch Capital Group Ltd.

Arch Capital Group Ltd. provided pay range

This range is provided by Arch Capital Group Ltd.. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$148,614.00/yr - $201,066.00/yr

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility℠.

Job Summary

The Senior ETL developer will work with the Corporate IT team to maintain and develop data integration solutions to support our Analytics platform. The solutions must align with data vault, data mart, dimensional modeling, and ETL standards and guidelines. The data modeling and data integration solutions will be based on Matillion with Snowflake data warehouses/databases & Power BI for reporting platform.

The ideal candidate will need to understand business and technical requirements and translate this into data integration designs and deliverables by working with the Corporate Data Architect. The position also requires supporting the Agile process in terms of Development, testing, deployment and post-production support.

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
  
  

Education And Experience

• 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
• Financial industry data fluency is preferred but not required
• Required knowledge and skills would typically be a acquired through a bachelor’s degree in information technology or related field
  
  

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible.

$148,614 - $201,066/year

• Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be modified in the future.
  
  

Click here to learn more on available benefits.

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you. If this job isn’t the right fit but you’re interested in working for Arch, create a job alert! Simply create an account and opt in to receive emails when we have job openings that meet your criteria. Join our talent community to share your preferences directly with Arch’s Talent Acquisition team.

10200 Arch Capital Services LLC

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

Referrals increase your chances of interviewing at Arch Capital Group Ltd. by 2x

Sign in to set job alerts for “Senior Data Engineer” roles.

New York, NY $100,000.00-$200,000.00 3 months ago

New York, NY $153,000.00-$210,000.00 5 months ago

Senior Data Architect/Engineer - Leading Systematic Hedge Fund - New York

Senior Data Analyst cum Business Analyst

Data Engineer/Solutions Architect – Reinsurance - Hybrid

Senior Data Analyst-Mt Sinai Hospital - Transplantation Services

New York, NY $65,885.00-$110,500.00 19 hours ago

Fairfield, NJ $160,000.00-$195,000.00 2 weeks ago

Azure Data Architect - Remote With Travel

Senior Data Analyst-Mt Sinai Hospital - Transplantation Services

New York, NY $65,885.00-$110,500.00 14 hours ago

Senior Data Solutions Developer - Private Markets (VP)

Healthcare Data Architect / Sr. Data Engineer

Senior Data Analyst – Middle Office & Investment Systems

Senior Software Engineer - Partner Experience Team, Bloomberg Connects

New York, NY $160,000.00-$240,000.00 1 week ago

Data Engineer Manager with Big Data Experience

New York, NY $150,000.00-$200,000.00 2 weeks ago

Senior Data Analyst – Middle Office & Investment Systems

Jersey City, NJ $150,000.00-$200,000.00 2 weeks ago

New York City Metropolitan Area $200,000.00-$350,000.00 1 week ago

Azure Cloud Data Architect - Purchase NY, Morristown NJ, Charlotte NC (Hybrid)

Senior Software Engineer - BLAW Contracts Drafting

New York, NY $160,000.00-$240,000.00 1 week ago

Senior Engineer Identity & Access Management

Parsippany, NJ $115,000.00-$155,000.00 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.