Job Summary

We are seeking the right person join our Data Warehouse team!

Are you...

Interested in working on a challenging, exciting, and highly visible data warehouse development project from the ground up?

• Someone with sound technical skills who knows how to communicate your ideas to others?
• Able to understand how data can make a significant impact in the running of a business?
• Tired of being behind-the-scenes, and are looking for a position that makes a difference?
• Ready to be a part of a collaborative team environment where what you do is really valued?

 ...then you might be the person we are looking for!

The right person for the job will enjoy being at the very beginnings of building a data warehouse project, interacting with senior managers who appreciate your contribution and will use the data warehouse to make decisions that affect the business.

Builders Mutual Insurance Company is not only one of the most successful companies in the Triangle, but we have been ranked as one of the best places to work in the Triangle for the past two consecutive years.

In the next 12-18 months, the goals for this position are to:

•  Write the processes that will extract data from the source (AS400) system into the data warehouse dimensional model in SQL Server 2005, using Microsoft SQL Server Integration Services and SQL Procedures.
• Use Microsoft SQL Server Reporting Services and Analysis Services to present the data as well as help to develop other innovative ways to present the data.
•  Take a lead technical role in the transition of the current data warehouse extract from monthly to daily including tasks such as:

1. developing new ETL processes
2. working with source system vendors to ensure correct mappings
3. develop balancing process and controls

•  Be a technical mentor for our end users and information management team in addition to  conducting formal training to our user community on how to:

1. develop ad hoc reports
2. execute parameter-driven reports
3. navigate OLAP cubes

Job Qualifications

The ideal candidate will have:

• BA/BS degree with at least 10 years of information technology experience
• At least 3 years of which should have been in data warehouse development or an equivalent combination of education and experience, preferably in the insurance industry
• Experience with Microsoft business intelligence toolset using SQL Server 2005 (or earlier versions) is required, as are proficient SQL skills for query execution in support of data analysis
• Experience with .NET programming and multidimensional modeling and development are required.

Job Preferences

• Property and Casualty insurance or other insurance experience
  
• Data analysis experience
  
• Experience in programming stored procedures
  

Additional Information

Directly related experience, or a combination of directly related education and experience may be considered in place of the above requirements.

Resumes may be reviewed in the order they are received.

Builders Mutual Insurance Company is an Equal Opportunity Employer.

Salary grade: 22

Job Summary

Goals for this position:

• Update, as necessary, testing assets including test plan template and test procedure template; develop other test assets, such as test matrix.
• Create test plan and test scripts for 3-5 major projects including systems migration project and expansion into additional states. Test plans and test scripts meet project schedule and may be implemented with no more than 4 major revisions per project.
• For 3-5 projects, apply and manage the requirements process including creating a project charter, soliciting and documenting requirements and enabling traceability between requirements and testing plans. Deliverables, such as project charter and requirements documents, meet project schedule, requirements are effectively used for test process and stakeholders have signed-off.
• Create, implement and maintain automated test scripts for a project.
• Research, manage and lead resolution of 40-50 production incidents.

Job Qualifications

• BA/BS degree in Computer Science required with at least 3 years experience with business support operations and automated testing tools in a property and casualty insurance setting, or an equivalent combination of education and experience.
• Successful track record translating business requirements and system specifications into technical specifications and test plans
• Ability to facilitate teams and lead decision-making processes in a collaborative environment
• Proven understanding of project management processes
• Ability to communicate well and make effective presentations
• Working knowledge of diagramming techniques such as Functional Decomposition, Data Flows, Activity Diagrams
• Experience writing functional specifications
• Solid command of scripting language (VBA or similar)
• Effective communication and presentation skills
• Strong analytical and problem-solving skills
• Understanding of requirements and development life cycles
• Strong facility to creating, maintaining and running automated test scripts

Job Preferences

• Experience with creation and maintenance of QA processes and procedures.
• Basic understanding of Structured Query Language (SQL)
• CSC Point System experience
• Understanding of databases and the ability to interpret data models

Additional Information

Related experience, or a combination of directly related education and experience may be considered in place of the above requirements.

Resumes may be reviewed in the order they are received.

Builders Mutual Insurance Company is an Equal Opportunity Employer.

Salary Grade: 21

Job Summary

Job Qualifications

• Minimum of a high school diploma, BA/BS in Accounting, Finance or related field preferred or an equivalent combination of education and experience.

•  Knowledge of general business, insurance principles and accounting.

• Strong computer (MS Office, Lotus Notes) and customer service skills required.

• Strong preference for bilingual (English/Spanish) incumbents.

Additional Information

Related experience, or a combination of directly related education and experience may be considered in place of the above requirements.

Resumes may be reviewed in the order they are received.

Builders Mutual Insurance Company is an Equal Opportunity Employer.

Salary Grade: 17/18

Job Summary

The Risk Management Consultant is responsible for conducting surveys with policyholders and prospective policyholders in the Eastern North Carolina territory.  Based on our customer demographics, candidates should be fluent in both English and Spanish.  Field inspections will focus on underwriting eligibility and ways to improve overall loss results of the risk.

 Position Goals

1. Within the first 60 days, complete the Risk Management training/orientation program.

2. In conjunction with Risk Management manager, identify and meet with 10 largest accounts in territory to review service schedule and needs. This should be done during initial 120 days.

3. Initial file quality review will be conducted on 100% of surveys written. A performance level of 90% adequacy should be achieved within first 6 months.

4. Attend several local HBA meetings and conduct agent visits to develop partnership in the local territory.  Spend one day with Territory Manager on agency visits.

Duties

• Identify and survey accounts in assigned region.
• Schedule and conduct work that produces a minimum of 25 units of work per month.
• Prepare and submit survey reports within required time frames.
• Conduct periodic safety talks in areas of proficiency as requested by local home builders associations, clients, and supervisor.
• Provide BMIC marketing information to potential clients.
• Conduct his/her business in a professional manner so as to conserve and protect the corporate funds of BMIC.
• Perform other duties as assigned

Job Qualifications

• BA/BS in a Science/Technology field and at lest five years safety/risk management experience preferred, or an equivalent combination of education and experience.
• Fluent in both English and Spanish.
• Strong computer (MS Office, Lotus Notes) and customer service skills required; mainframe experience preferred.
• Excellent customer service skills, and verbal and written presentation skills required, as well as the ability to plan and manage time effectively.

Additional Information

Directly related experience, or a combination of directly related education and experience may be considered in place of the above requirements.

Resumes may be reviewed in the order they are received.

Builders Mutual Insurance Company is an Equal Opportunity Employer.

Salary grade: 20