Berkley Accident And Health (A W. R. Berkley Company) - Hamilton Township, NJ
posted about 2 months ago
Berkley Accident and Health is seeking a Sr. Manager, Databases and Reporting to join our Information Technology department. This newly created role is essential for addressing the challenges related to the consistency, reliability, security, and accuracy of our databases and reporting solutions. The ideal candidate will possess a passion for transforming ambiguity into structured processes and will have a keen eye for detail. This position will be based in our Hamilton, NJ office, requiring four days in the office and one day remote work each week. In this role, you will lead a team of three data analysts and engineers, driving the definition, execution, and delivery of a strategic roadmap focused on data analytics and reporting. You will collaborate closely with the AVP of Information Technology to assess the current state of our IT catalog, which includes existing databases, ETL solutions, and reports. Your leadership will be crucial in building and executing a roadmap that aligns with our desired future state. Key responsibilities include overseeing day-to-day work assignments for your team, ensuring a balance between project work and operational tasks. You will also be responsible for the design and deployment of MS SQL Server databases, including the development and optimization of table relationships and indexes, as well as implementing field-level encryption to protect sensitive data. Additionally, you will strengthen our data infrastructure while reducing legacy technical debt, ensuring that solution requirements are well documented and that formal change control procedures are adhered to prior to deployment. You will create and maintain ETL packages using MS SQL Server Integration Services (SSIS) and manage the ETL processes to ensure data quality and availability. Your role will also involve translating business requirements into effective visualizations and reports, troubleshooting data-related issues, and maintaining technical documentation and end-user job aids. Your ability to perform root-cause analysis and resolve data reporting issues promptly will be vital to the success of this position.