The Sr. Business Intelligence Developer is responsible for the following:Responsible for quality data development. Maintain standard and ad hoc reports. Create and manage business intelligence (BI) and analytics solutions that turn data into knowledge. Leverage software tools that transform data into useful insights via reports, summaries, dashboards, graphs or charts. Develop, identify, design, build, test, optimize, and maintain Data Warehouse and customer relationship management portals using... more details
Sr. Business Intelligence Developer
Location NameCT, Greenwich
ID
2024-10702
Date Posted
20 hours ago(6/10/2024 1:01 PM)
Company
Berkley Risk Admin. Co., LLC
Primary Location
US-CT-Greenwich
Category
Information Technology
Company Details
Berkley Risk is a member company of W. R. Berkley Corporation, an A. M. Best A+ rated Fortune 500 holding company. Berkley is comprised of individual operating units that serve a defined insurance market segment. Berkley Risk is focused on providing self-insured entities program administration services and insurance operations which can include taking or sharing risk using Berkley paper. This capability allows us to customize both an insurance company option and a purely administrative option for our customers.
Responsibilities
The Sr. Business Intelligence Developer is responsible for the following:
Responsible for quality data development.
Maintain standard and ad hoc reports.
Create and manage business intelligence (BI) and analytics solutions that turn data into knowledge.
Leverage software tools that transform data into useful insights via reports, summaries, dashboards, graphs or charts.
Develop, identify, design, build, test, optimize, and maintain Data Warehouse and customer relationship management portals using MS tools.
Implement end-to end data integration projects, from policy systems to claim systems to data warehouse to reporting to reinsurance.
Work with high-performance data integration solutions that connect multiple data sources to extract and rapidly transform data to load into pre-designed data warehouses.
Create databases and schema objects including tables, indexes, and applied constraints.
Create OLAP cubes from relational data warehouses to develop measures, dimensions and business critical KPIs.
Import data from various sources (flat file, excel, raw file & various databases) and export to various destinations using SSIS.
Connect various applications to the database and write functions, stored procedures and triggers.
Design and implement new ETL processes and adapt current ETL processes to accommodate changes in source systems.
Work with business users to gather requirements and design an architecture for apps as a solution to those requirements.
Guide development teams to break down large and complex user stories into simplified versions for easy execution.
Work with pivot tables, graphs and reports and create VBA programs in MS Excel.
Convert data from legacy systems to new systems using ETL tools.
Perform quality assurance checks on new or enhanced reports and perform code reviews to ensure that high quality standards are met.
Collaborate with stakeholders and assist them with data-related technical issues.
Translate business requirements into sustainable and efficient visualizations and reports.
Participate in various ad hoc projects focused on system conversions, profitability, competitor analysis, and metrics.
Produce and maintain various monthly, quarterly and annual reports.
This position allows for 100% telecommuting from anywhere within the U.S.
Qualifications
5 years of experience as software developer, BI developer or related.
Special skills: Must have work experience with each of the following:
Database management systems, online analytical processing with OLAP and ETL frameworks;
Data warehouse design (dimensional modeling and data mining) for data coming from AS400 and Guidewire Suite (GWCC, GWPC, and GWBC);
Writing Oracle SQL and PLSQL queries and using OBIEE, Microsoft Power BI, Tableau, SSRS and SSIS tools;
Leverage knowledge of self-insured pooling/group concepts including underwriting models, accounting, finance, claims and business KPIs and metrics; and
5 years of experience supporting a major insurance ERP system.
Education
Bachelor’s degree in computer science, information systems or math.
Additional Company Details
The Company is an equal employment opportunity employer
We do not accept any unsolicited resumes from external recruiting agencies or 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.
https://www.berkleyrisk.com/
Additional Requirements
Travel: Occasional
Create Profile & Apply
Connect With Us!
Not ready to apply? Connect with us for general consideration.
Job Abstracts is an independent Job Search Engine. Job Abstracts is not an agent or representative and is not endorsed, sponsored or affiliated with any employer. Job Abstracts uses proprietary technology to keep the availability and accuracy of its job listings and their details. All trademarks, service marks, logos, domain names, and job descriptions are the property of their respective holder. Job Abstracts does not have its members apply for a job on the jobabstracts.com website. Additionally, Job Abstracts may provide a list of third-party job listings that may not be affiliated with any employer. Please make sure you understand and agree to the website's Terms & Conditions and Privacy Policies you are applying on as they may differ from ours and are not in our control.
We would like to take a second to Welcome You to Job Abstracts, the nation’s largest Pure Job Board. With over 3.1 million job listings from 15,000+ Companies & Organizations, we help job searchers find careers that match their interests. As an anonymous user, you have probably discovered how easy our system is to use. However, you have just scratched the surface of what we can offer.
We encourage you to Register so you can use our most powerful features: searching with multiple terms, setting up multiple locations, establishing favorite companies, and accessing your search history. If you find a job you like, you can apply directly for it, and then, keep notes on it. We will also keep a lookout for jobs that match your search terms and email you when we find something you may like.
You can register for free and the system is free to use. If you like our system so far, click on Register and unlock the power required by serious job searchers.
Any time you conduct a search, the system shows you job matches, ranked by their Relevance Score (RS).
The score is calculated by a proprietary algorithm that uses Intelligent Machine Learning.
The Relevance Score tells you how well the job opportunity matches your search term or terms.
When not logged in, the system is limited to one search term. Scores for single term matches are usually lower.
When you register, log in, and set up multiple terms prioritized by importance, the jobs found for you will receive a much higher Relevance Score.