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.

We 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 state
• Direct 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 work
• Perform 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 transit
• Strengthen the overall data infrastructure foundation while reducing legacy technical debt
• Ensure solution requirements are well documented, formal change control procedures are followed prior to deployment, and source code is appropriately registered in the company repository
• Create and maintain ETL packages using MS SQL Server Integration Services (SSIS)
• Apply and maintain appropriate role-based permissions for databases and reports
• Build and manage the Extract, Transform, and Load (ETL) processes
• Implement processes and systems to monitor data quality, ensuring production data is accurate and available
• Translate business requirements into sustainable and efficient visualizations and reporting
• Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
• Document work and updates technical documentation and end-user job aids
• Assist stakeholders with data-related technical issues
• Perform root-cause analysis, identify, and resolve data reporting issues in a timely fashion

 

• Bachelor's Degree in Information Technology, Business, or similar field; or equivalent experience
• 10+ years experience designing, implementing, and supporting database and reporting solutions
• 5+ years experience directly supervising teams sized at 3-5 employees/contractors
• Significant 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

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 not Offered for this Role