Argo Group is a leader in specialty insurance with a vibrant culture built on respect, equality, wellness and opportunity. We’re an innovative organization that’s small enough to be agile and big enough to make a difference in our industry.  

Our collaborative workplace is continuously evolving to ensure all employees feel: 

  • Comfortable bringing their whole selves to work. 
  • Confident that they will be treated respectfully. 
  • Recognized for their performance and provided with equal opportunities to succeed. 

At Argo, skill meets opportunity. If you’re wired to raise your hand and ask, “Where can I help?”, you’ll thrive with us. 

The Senior Data Engineer is a full-time/permanent position located on-site in our New York office.

The ideal candidate will have a proven track record in implementing data ingestion and transformation pipelines for large scale organizations. The candidate should have 8+ years of experience and love being a problem solver, translating requirements into data metrics and schemas that are easy to understand. We are seeking someone with deep technical skills in a variety of technologies like Snowflake, Talend, AWS storage integration solutions and DevOps. Candidate should also have strong interpersonal skills, enabling them to guide people through conversations to collect the information as needed.

Who You Are

You're someone who wants to see the impact of your work making a difference every day by driving outcomes and results to stakeholders and solving client needs. Your friends describe you as thorough, analytical, and detail-oriented, and someone who gets things done. You are someone with high standards who leads by example, and who will take pride in Argo like we do. Most of all, you love solving difficult business & technical challenges to make a difference in the lives of other people.

Qualifications:

Core Skills:  SQL • ETL •Talend • Snowflake • Scripting • Git • Batch and streaming technologies.

  • 8+ years’ experience in Data Warehousing and Data Engineering.
  • 3+ years’ strong experience with Snowflake, Talend.
  • Strong SQL and PL/SQL skills and ability to write queries and data extracts.
  • Experience working with different file formats like Parquet, Avro, JSON etc.
  • Good understanding of Snowflake database architecture and ability to design and build optimal data processing pipelines.
  • Demonstrated skill in designing highly scalable ETL processes with complex data transformations, data formats including data cleansing, data quality assessment, error handling and monitoring.
  • Expertise in building and managing large volume data processing (both streaming and batch) platform is a must.
  • Design, develop, manage, and monitor complex ETL data pipelines and support it through all environment runways.
  • Experience with Python/JavaScript or other scripting languages is a plus.
  • Proficient utilizing platforms and technologies which support DevOps and SDLC leveraging CI/CD principles and best practices.
  • Ability to work with developers to build CI/CD pipelines, Self-service Build tools, to automate deployment processes.
  • Working knowledge and experience of using orchestration frameworks like Airflow, UC4, and AWS Step functions will be good.
  • Knowledge of Containerization (Docker/Kubernetes) is a plus.
  • Provide Support and troubleshooting for data platforms. Must be willing to provide escalated on-call Support for complicated and/or critical incidents.
  • Work well within an Agile or have sound Agile Scrum Team Knowledge.
  • Manage and prioritize multiple assignments.
  • Ability to work individually and as a team.
  • Provide technical guidance and mentoring for other team members.
  • Good communication and cross functional skills. 

 

 

The base salary range provided below is for hires in those geographic areas only and will be commensurate with candidate experience. Pay ranges for candidates in other locations may differ based on the cost of labor in that location. In addition to base salary, all employees are eligible for an annual bonus based on company and individual performance as well as a generous benefits package.

New York City Pay Range:
$133,600—$159,000 USD

PLEASE NOTE:  At this time, Argo Group will not sponsor an applicant for employment authorization for this position.

If you have a disability under the Americans with Disabilities Act or a similar law and you wish to discuss potential accommodations related to applying for employment at Argo Group, please contact our Benefits Department at 210-321-8400. 

To all recruitment agencies:  Unless you have been requested to work on this position, or other positions with Argo Group, please do not forward any resumes to Argo Group employees.   Argo Group is not responsible for any fees related to unsolicited resumes.

Argo Group International Holdings, Inc. (“Argo” or the “Company”) is a wholly owned subsidiary of Brookfield Wealth Solutions, Ltd. (“BWS”), a New York and Toronto-listed public company. Argo, with over $8 billion of assets on its balance sheet, is a leading underwriter of specialty insurance products in the property and casualty (P&C) market, working with independent agents, wholesale brokers, and retail brokerage partners to deliver collaborative solutions for niche markets.

BWS is a leading wealth solutions provider, focused on securing the financial futures of individuals and institutions through a range of wealth protection and retirement services, and tailored capital solutions. BWS is backed by Brookfield Corporation, a leading global investment firm whose asset management business manages more than $1 trillion in assets as of September 30, 2024.

We are an Equal Opportunity Employer. We do not discriminate on the basis of age, ancestry, color, gender, gender expression, gender identity, genetic information, marital status, national origin or citizenship (including language use restrictions), denial of family and medical care leave, disability (mental and physical) , including HIV and AIDS, medical condition (including cancer and genetic characteristics), race, religious creed (including religious dress and grooming practices), sex (including pregnancy, child birth, breastfeeding, and medical conditions related to pregnancy, child birth or breastfeeding), sexual orientation, military or veteran status, or other status protected by laws or regulations in the locations where we operate. We do not tolerate discrimination or harassment based on any of these characteristics. 

The collection of your personal information is subject to our HR Privacy Notice

Our Benefits

Developing our employees professionally and personally strengthens our organization.
Argo Group offers an attractive Total Rewards package that includes:

  • A culture that recognizes performance and empowers employees to excel, offering competitive compensation and merit driven profit sharing.

  • Workplace policies that support employee well-being include flex time and floating holidays.

  • Comprehensive health, wellness, and financial planning options that employees can tailor to meet their personal and family needs.  In addition to traditional health and wellness plans, benefits include dental, disability, life insurance, medical, and vision insurance, matching 401(k) retirement savings, generous paid time off (21 days of PTO, 11 paid company holidays, 3 floating holidays and a paid voluntary day), paid caregiver and parental leave, paid bereavement, jury duty/court appearances, and military (up to 14 days) leave, employee assistance program (EAP), and an array of voluntary benefits.  

  • Argo Academy, a digital and instructor-led platform that offers continuous learning and professional development – Training magazine lists Argo among the Training "Top 125" Companies.   Argo encourages career mobility and continuing education to pursue and maintain professional and industry designations, in addition to traditional university and higher education programs.

  • An inclusive culture that develops and sponsors diverse teams, encourages cross-functional engagement and collaboration, builds community through employee resource groups (ERGs), and provides an environment that welcomes ongoing dialogue, creative innovation, professional and personal development.

  • Active community outreach and volunteer programs.

  • A generous Employee Referral program that results in approximately 25% of all new hires annually.

Apply for this Job

* Required
resume chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox Google Drive
(File types: pdf, doc, docx, txt, rtf)
Cancel

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Argo Group’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Enter the verification code sent to to confirm you are not a robot, then submit your application.

This application was flagged as potential bot traffic. To resubmit your application, turn off any VPNs, clear the browser's cache and cookies, or try another browser. If you still can't submit it, contact our support team through the help center.