Sr. Data Engineer

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