Senior Database Analyst

Group1001, and its affiliated companies, is strongly committed to providing a supportive work environment where employee differences are valued. Diversity is an essential ingredient in making Group 1001 a welcoming place to work and is fundamental in building a high-performance team. Diversity embodies all the differences that make us unique individuals.  All employees share the responsibility for maintaining a workplace culture of dignity, respect, understanding and appreciation of individual and group differences.

Job Summary:

The Senior Data Analyst position is a member of the highly collaborative Solutions Delivery Team responsible for the delivery of an integrated data warehouse and data transformation programs. The Analyst will focus on the ongoing design, development, and management of a new P&C data warehouse, including ongoing daily support of production process, development, and maintenance of the current data model for the data warehouse, and key support of reporting strategy, data governance standards and data quality.  The position is a hands-on role responsible for analyzing and understanding business needs to translate needs into developed requirements and approach, and facilitate the implementation of the solution, with a key focus on continued development and improvement of the data model as well as and testing and support.

Main Accountabilities:

• Involvement in the design and ongoing support of the data model for specific data subjects, analyzing the data, development of the requirements, including the initial technical design and working with developers through implementation. Must maintain focus on designing solutions that balance system flexibility, accuracy, and fast processing time.
• Coordinates the technical development with IT for all database applications, including data transformation programs, data warehouse, and operational data stores, and delivering solutions on time and within budget.
• Coordinates with technical and non-technical resources, both external and internal, to standardize data feed delivery format and schedules.
• Design reporting solutions including ad-hoc reporting, scheduled reporting, and self-service.
• Implements data quality rules to ensure that all data sources are consistent and accurate.
• Leads testing of all database applications, data warehouse, and data transformation programs.
• Manages the development and implementation of the data governance capabilities into the database solutions and coordinates efforts with Data Governance team.
• Develops detailed prototypes to help flush out requirements and provide the end-users improvements in their process.
• Works directly with business users and IT to assist in support of the systems and solutions. Balances the timely support of the production environment with the longer-term delivery of ongoing maintenance and enhancements.
• Use critical thinking skills to perform analysis to assess quality and meaning of data

Qualifications:

• Bachelor’s degree in Math, Computer Science, Finance, or Accounting/Investment Accounting or experience commensurate with degree preferred.
• Preference for advanced degree in mathematics, statistics, computer science or a related field or someone with exams with the Casualty Actuarial Society.
• 3 years of data analyst / data management experience, preferably in the Property and Casualty insurance industry.
• Working knowledge database development and modeling (SQL Server or Oracle)
• Proficient with SQL.
• Experience with VB, Java, R, and/or C Sharp preferred
• Experience working the Power BI
• Highly organized with good time management skills.
• Demonstrated ability to proactively identify and solve problems and issues of all types
• Ability to succeed in a collaborative work environment and work cross-functionally.
• Excellent oral, written and listening abilities to clearly articulate complex information to others