Senior Enterprise Data Warehouse Architect

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 flexible 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 Architect designs and builds leading-edge data solutions and models. They are the custodians of our data models, working closely with engineering teams to shape and design new products and services that fit into an overall data architecture for Argo’s Ecosystem. 

This position requires a wide range of domain knowledge within the P&C Insurance industry, technical development, design, and multitasking skills. 

What’s Required For The Position 

• 10+ years professional work experience in delivering data and analytics solutions 
• At Minimum 3+ year of experience in P&C Insurance  
• At Minimum 3+ year of experience with data Modeling tools like Spark, Erwin Data Modeler  
• Experienced in Data Warehousing/Analytic end to end architecture 
• Comfortable with different modelling methodologies – 3NF, Dimensional and Data Vault 
• Abreast of the latest industry developments across data, including machine learning and modern algorithmic techniques at scale. 
• Strong communication and influencing skills used to drive the implementation of data design best practice at the Engineering and Product Manager levels within and across teams 
• Curiosity and drive to understand business processes and the data they generate in addition to the opportunities to structure and use this data to drive business value 
• Working with a variety of colleagues, including Product Owners and the Engineering community, to ensure the best data solutions are delivered. 
• Developing and enhancing business physical data models in line with new requirements 
• Draws conclusions and effectively communicates findings with both technical and non-technical team members. 
• Defining and owning modelling within a delivery team from a physical perspective on a day-to-day basis 
• Ensuring the data models developed meet the appropriate standards and principles 
• Creating solutions that meet business needs and move towards end state architecture 
• Ensuring data models are documented, communicated, updated and centrally managed in an appropriate manner. 
• Collaborates with Data Governance to define data/information standards for enterprise warehouse repository.
• Collaborates with Data Governance to help define metadata management to manage all enterprise information architecture project artifacts.
• Working with the broader architecture community of practice to support architects and teams in other domains; sharing personal learning and expertise, and sharing plans to promote alignment and innovation. 

If you have these preferred skills, that is even better: 

• Experience with modern data Modeling tools like Spark, Erwin Data Modeler  
• Experience with cloud data warehouse (like Snowflake, AWS-Redshift..) 
• Experience with Realtime integration and db Log replication architectures like Qlik (Attunity) replicate  
• Experience with Cloud native ETL tools like - Talend, Informatica 

 

The base salary range provided below will be commensurate with candidate experience.  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:$174,300—$207,400 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, Ltd. (NYSE: