Berkley Accident and Health is a risk management company that designs innovative solutions to address the unique challenges of each client. With our entrepreneurial culture and a strong emphasis on analytics, we can help employers better manage their risk. We offer a broad range of products, including employer stop loss, benefit captives, provider stop loss, HMO reinsurance, and specialty accident. The key to Berkley’s success is our nimble approach to risk – our ability to quickly understand, think through, and devise a plan that addresses each client’s challenges, coupled with the strong backing of a Fortune 500 company. Our parent company, W. R. Berkley Corporation, is one of the largest and best managed property/casualty insurers in the United States.
The company is an equal employment opportunity employer.
ResponsibilitiesWe have an opportunity for a Sr. Manager, Databases and Reporting to join our team! We are adding this new role to our Information Technology department for a candidate who is passionate for building structure out of ambiguity with a keen eye for accuracy. This new position will be instrumental in helping close deficiency gaps that pertain to consistency, reliability, security, and accuracy of databases, extract-transform-load (ETL) solutions, and both graphical and paginated reports.
You will lead and inspire a team of three data analysts/engineers, and be accountable to drive the definition, execution, and delivery of a strategic roadmap pertaining to data analytics and reporting.
This position will be based in our Hamilton, NJ office (4 days in the office, 1 day remote)
We have a welcoming culture valuing our employees – we trademarked the phrase Everything Counts, Everyone Matters® to describe the Berkley commitment to our people and how we do business. We believe that every person in the organization is important and every accomplishment makes a difference in our results. Come join us!
Key functions include but are not limited to:
Work closely with the AVP of Information Technology to broadly assess current state of IT’s catalog of existing databases, ETL solutions, and reports, and then build and execute upon a roadmap that achieves the desired future stateDirect day-to-day work assignments to a team of three data analysts/engineers that aligns to the overall IT portfolio of work, ensuring an appropriate balance between project assignments and operational clean-up workPerform MS SQL Server database(s) design and deployment activities, including the development and tuning of table relationships, indexes, standardizing table and field naming conventions, and appropriately applying field-level encryption/decryption to protect personal information (PI) / personal health information (PHI) data at rest and in transitStrengthen the overall data infrastructure foundation while reducing legacy technical debtEnsure solution requirements are well documented, formal change control procedures are followed prior to deployment, and source code is appropriately registered in the company repositoryCreate and maintain ETL packages using MS SQL Server Integration Services (SSIS)Apply and maintain appropriate role-based permissions for databases and reportsBuild and manage the Extract, Transform, and Load (ETL) processesImplement processes and systems to monitor data quality, ensuring production data is accurate and availableTranslate business requirements into sustainable and efficient visualizations and reportingPerform data analysis required to troubleshoot data related issues and assist in the resolution of data issuesDocument work and updates technical documentation and end-user job aidsAssist stakeholders with data-related technical issuesPerform root-cause analysis, identify, and resolve data reporting issues in a timely fashionQualifications Bachelor's Degree in Information Technology, Business, or similar field; or equivalent experience10+ years experience designing, implementing, and supporting database and reporting solutions5+ years experience directly supervising teams sized at 3-5 employees/contractorsSignificant experience with Microsoft SQL Server, Structured Query Language (SQL), and Transact-SQL (T-SQL)Significant experience with Microsoft SQL Server Integration Services (SSIS)Significant experience with Microsoft Power BI, Microsoft SQL Server Reporting Services (SSRS), and Microsoft Excel Additional Company Details We do not accept any unsolicited resumes from external recruiting firms.
The company offers a competitive compensation plan and robust benefits package for full time regular employees.
The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Sponsorship Details Sponsorship not Offered for this Role Connect With Us! Not ready to apply? Connect with us for general consideration.