W.R. Berkley - Parsippany-Troy Hills, NJ

posted 4 months ago

Full-time - Manager
Parsippany-Troy Hills, NJ
Management of Companies and Enterprises

About the position

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, extract-transform-load (ETL) solutions, and reporting mechanisms. The ideal candidate will possess a passion for transforming ambiguity into structured solutions, ensuring that our data management practices are robust and effective. This position will be based in our Hamilton, NJ office, with a hybrid work model of four days in the office and one day remote. In this role, you will lead a team of three data analysts and engineers, guiding them in the execution 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 driving the definition and delivery of initiatives that enhance our data infrastructure and reduce legacy technical debt. Key responsibilities include overseeing the design and deployment of MS SQL Server databases, developing and tuning table relationships, and ensuring the protection of personal and health information through appropriate encryption methods. You will also be responsible for creating and maintaining ETL packages using MS SQL Server Integration Services (SSIS) and managing the ETL processes to ensure data quality and availability. Your ability to translate business requirements into effective visualizations and reports will be vital in supporting our stakeholders and enhancing our data-driven decision-making processes.

Responsibilities

  • Lead and inspire a team of three data analysts/engineers.
  • Drive the definition, execution, and delivery of a strategic roadmap for data analytics and reporting.
  • Assess the current state of IT's catalog of databases, ETL solutions, and reports.
  • Direct day-to-day work assignments to the team, balancing project assignments and operational clean-up work.
  • Perform MS SQL Server database design and deployment activities.
  • Develop and tune table relationships, indexes, and standardize naming conventions.
  • Implement field-level encryption/decryption for personal information (PI) and personal health information (PHI).
  • Strengthen the overall data infrastructure foundation and reduce legacy technical debt.
  • Document solution requirements and follow formal change control procedures prior to deployment.
  • Create and maintain ETL packages using MS SQL Server Integration Services (SSIS).
  • Build and manage the Extract, Transform, and Load (ETL) processes.
  • Monitor data quality to ensure production data is accurate and available.
  • Translate business requirements into sustainable and efficient visualizations and reporting.
  • Perform data analysis to troubleshoot data-related issues and assist in their resolution.
  • Document work and update technical documentation and end-user aids.
  • Assist stakeholders with data-related technical issues.
  • Perform root-cause analysis and resolve data reporting issues in a timely manner.

Requirements

  • Bachelor's Degree in Information Technology, Business, or a similar field; or equivalent experience.
  • 10+ years of experience designing, implementing, and supporting database and reporting solutions.
  • 5+ years of experience directly supervising teams of 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.

Benefits

  • Competitive compensation plan
  • Robust benefits package for full-time regular employees
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service