Sr. Data Analyst

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. 

At Argo Group, our team members are critical to our long-term success – so wherever in the world they work, everyone works together.  

We are seeking a Sr. Data Analyst to serve as a liaison between the IT Data Analyst team and the functional business units.  The role will report to the Director of Data and will be key in understanding the business needs and aligning them with data team’s strategy and architecture. 

This position will be located on-site, full-time in either our San Antonio, Omaha, Chicago, Richmond or New York office.

This role will lead a team of analysts responsible for translating business needs into requirements for technical teams to execute on.  It is imperative that this individual have a strong business acumen, experience interacting with leadership, and an in-depth understanding of insurance data.     

This role will lead a team whose responsibilities include determining source to target mappings for the loading of the Enterprise Warehouse, documentation of the technical requirements necessary to enrich data at the source to conform to Argo standards and ensuring that the data reconciles to current financials. The Sr. Data Analyst will also ensure that analysts are meeting objectives and completing assigned tasks in a timely manner and will maintain a backlog inventory of pending items for the team to focus on. This individual must have excellent communication skills. 

What does the Sr. Data Analyst's workday look like?  

• Identify, create and facilitate process design by conducting business and systems process analysis, focusing on quality improvement and data management ensuring reliability and validity of data. 
• Facilitating business requirement walkthrough meetings and partnering with the business on functional specification reviews 
• Collaborate closely with technical teams to implement the requirements 
• Write SQL Queries that will make our data evaluation process more flexible or scalable across data sets. 
• Diving into large data sets, uncovering insights, and providing impactful recommendations. 
• Perform analysis for documenting detailed data lineage (source to target mappings). 
• Identify data control requirements, i.e. Reconciliations and validations.  
• Reviews, documents, and categorizes current or as-is state of the business process or function including creating flow charts and process models and develop portions of the desired future or to-be state of those processes. 
• Organize complex problems into simple solutions and precise business and technical requirements 

What is required for the position? 

Required Skills 

• Structured data analysis and data requirements development experience is required. 
• Core responsibility will be to truly understand data and create data lineage necessary for data strategy. 
• Strong SQL and Excel skills with the ability to learn other analytics tools. 
• Document data and business process flows. 
• Experience in insurance industry is preferred. 
• Prior experience with database and model design is preferred.  
• Ability to communicate complex information to others in a way they can understand. 

Experience 

• Data analysis: 8+ years (required) 
• Bachelor’s degree from an accredited college or university in Business Administration, Computer Science, Mathematics, or Statistics, or equivalent work experience. 
• 5+ years’ experience with Snowflake/SQL databases. 
• 3-5 years of work experience in the Property & Casualty Insurance industry. 
• Familiarity with Agile and Scrum methodologies. 

Developing our employees professionally and personally strengthens our organization. Argo Group offers competitive pay and benefits that protect and enhance the lives of employees and their eligible dependents by way of health and wellness plans, life insuranc