Job Location: Hamilton Square, NJ
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.
We have an exciting opportunity for a Data Analyst to join our team! At Berkley Accident and Health, we help employers, membership groups, and healthcare organizations to better understand and manage their risk. In this business facing role, you will be responsible for building and maintaining our data warehouse, in addition to creating and managing business intelligence (BI) and analytics solutions that turn data into knowledge, ultimately helping an organization make better decisions.
This role will be based in our Hamilton Square, NJ office. We offer a hybrid work schedule with 3 days in the office; and 2 days remote.
We have a welcoming culture valuing our employees – we actually 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!
What you’ll do:
- Assemble large, complex sets of data that meet non-functional and functional business requirements
- Build and manage database tables and relationships, foreign/primary keys, and normalizing table structures
- Build and manage the Extract, Transform, and Load (ETL) processes and implement solutions
- 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
- Identify, design, and implement internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
- Perform quality assurance checks on new or enhanced reports
- Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues
- Document work and updating technical documentation and end-user job aids
- Work with stakeholders and assist them with data-related technical issues
- Perform root-cause analysis, identify and resolve data reporting issues in a timely fashion
- Perform end-user deskside services upon request by Level 1 Helpdesk team
What we’re looking for:
- Bachelor’s Degree in IT or similar field
- 7-10+ years prior database work experience; including Data Engineering/IT/Data Analytic experience
- Strong experience working with MS SQL Server including Integration Services (SSIS) and Reporting Services (SSRS)
- Structured Query Language (SQL)
- Excel knowledge
- Experience troubleshooting issues by formulating a structured methodology to achieve root-cause analysis
- Since this is a business facing role, you must have strong communication skills to interact effectively with various users and serve as a liaison between users and IT
- Organization, interpersonal, patience, and self-motivation skills
- Must have independent judgement and decision making abilities
- Must be comfortable with ambiguity, frequent change, or unpredictability
Submit CV To All Data Science Job Consultants Across United States For Free