Sr. Data Engineer

Argo Group International Holdings, Inc . and American National, US based specialty P&C companies, (together known as BP&C, Inc.) are wholly owned subsidiaries of Brookfield Wealth Solutions, Ltd. ("BWS"), a New York and Toronto-listed public company. 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.

Job Description

As a Senior Data Engineer, 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 withSnowflake, 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 optimaldataprocessing 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 volumedataprocessing (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 leveragingCI / CDprinciples 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 fordataplatforms. 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 TeamKnowledge.
• 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.

PLEASE NOTE :

Applicants must be legally authorized to work in the United States. At this time, we are not able to sponsor or assume sponsorship of employment visas.

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

Notice to Recruitment Agencies :

Resumes submitted for this or any other position without prior authorization from Human Resources will be considered unsolicited. BWS and / or its affiliates will not be responsible for any fees associated with unsolicited submissions.

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

Benefits and Compensation

We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program-including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities.