Principal ETL Developer Internet & Ecommerce - Portsmouth, NH at Geebo

Principal ETL Developer

Company Name:
Liberty Mutual
Title: Principal ETL Developer
Location: NH-Portsmouth
Other Locations: US-MA-Boston
Advance your Information Technology (IT) career at Liberty Mutual Insurance - A Fortune 100 Company.
At Liberty Mutual Insurance, doing the right thing is essential to all that we do. Our commitment to building and sustaining a talented and diverse workforce has helped us to become a global leader in property and casualty insurance. Our financial strength and profitability rely on the skills, knowledge, and creativity of more than 50,000 employees worldwide. As number 81 on Fortune Magazine's list of the 100 largest corporations in the U.S., we have the resources and training our employees need to drive our business forward and be successful in an ever-evolving, complex world.
Liberty Mutual Global Specialty IT, Inforamtion Management is actively searching for a Principal ETL Developer. Global Specialty IT provides support and operations for all global specialty lines including Liberty International Underwriters (LIU), Liberty Specialty Markets (LSM), Liberty Mutual Surety (LMS), and A&H (Accident and Health) across 19 countries, through one unified IT team. In this position, you will play an integral role in the transformation, storage, and delivery of analytical data to end users that will be used to make key business decisions.
In this role you will provide technical consulting on complex to highly complex financial project. Devises or modifies procedures to solve medium to highly complex problems. Leads projects or subprojects of medium to high technical complexity and responsible for directing and monitoring the work of team members. Responsible for system analysis, design, coding, testing, debugging, and documentation. Responsible for quality assurance review. Provides coaching and guidance to team.

Requires expertise in writing, performance tuning, and troubleshooting of T-SQL stored procedures, functions, and views.

Performs complex to highly complex source code development.
Assists in complex to highly complex unit test case development.
Assists in the development of production support documentation.
Provides functional/system integration testing support.
Performs Quality Assurance architecture and design guide review.
Contributes complex to highly complex technical alternatives.
Conducts complex to highly complex impact analysis.
Develops complex to highly complex component design.
Provides complex to highly complex system/application architecture.
Develops Build and Deployment guide.
Provides accurate estimates of work effort (task, time, etc.)
Qualifications:

Bachelor''s or Master''s degree in technical or business discipline or equivalent experience, technical degree preferred.

Generally 8 years of professional experience.

Advanced Level knowledge of Microsoft Integration Services (2005, 2008, and 2012).

Thorough knowledge of database concepts, strategies, methodologies, and best practices.

Thorough understanding of data cleansing terminology and practices.

Experience in working in fast paced development environment with extremely tight deadlines.

Must possess the ability to multitask and work on multiple projects simultaneously.

Must have proven track record of both working independent and as a team lead and subject matter expert on small to large scale projects.

Thorough knowledge of a business function(s) and I/T industry business issues; extensive knowledge of business operations, strategies and objectives.

Strong negotiation, facilitation and consensus building skills. Strong oral and written communication skills; presentation skills.

Microsoft SQL Server replication and Change Data Capture experience a plus.

Understanding of C# object oriented development a plus.

Experience with insurance and underwriting data a plus.
Benefits:
We recognize that talented people are attracted to companies that provide competitive pay, comprehensive benefits packages and outstanding advancement opportunities. For this reason we offer a Comprehensive Benefits Plan that includes the following:
401K and Company paid pension plan
Medical coverage
Dental coverage
Paid time-off
Pay-for-Performance
Discounts on automobile and homeowner''s insurance
Discount fitness memberships
Flexible spending accounts
Tuition reimbursement
Vision care coverage
Work/Life resources
Credit Union membership
Employee and Dependent life insurance
Disability insurance
Accidental death & dismemberment insurance
Overview:
We believe strongly that commercial success can be achieved in a manner consistent with principles and ideals that bind us together as one company, that set us apart from our competitors, and that in the end will allow us to say we have succeeded commercially by doing the right thing the right way.
We believe that the Company''s success is inextricably linked to our employees'' satisfaction and success: satisfaction that they work for an industry leader committed to improving safety, satisfaction that they work for a company that does the right thing, and satisfaction that the company will reward them for their contributions and provide opportunities for personal growth and success.
We believe our employees take pride in knowing that they help people live safer more secure lives everyday.
Responsibility. What''s your policy?
InvestmentsEstimated Salary: $20 to $28 per hour based on qualifications.

Don't Be a Victim of Fraud

  • Electronic Scams
  • Home-based jobs
  • Fake Rentals
  • Bad Buyers
  • Non-Existent Merchandise
  • Secondhand Items
  • More...

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.