Skip Navigation

ETL Developer

Apply Later Job ID 97254 - 3 Job Location Fairfield, Ohio
We deliver our customers peace of mind every day by helping them protect what they value most. Our passion for placing the customer at the center of everything we do is driving a transformational shift at Liberty Mutual. Operating as a tech startup within a Fortune 100 company, we are leading a digital disruption that will redefine how people experience insurance.
About the job:
In this role you will use your Informatica and SAS experience coupled with business and technical knowledge to handle the ETL development of customer data from third parties into Liberty Mutual formats and delivery back out to Customers/Carriers. 
In this high visibility customer facing role, you will interact with customers and brokers to implement the data translation programs.  This is NOT a backroom, heads down programming role.  Therefore, strong communication and interpersonal skills are necessary.
You will work with our external customer’s business and technical contacts, evaluate business requirements and model data and/or system requirements and create ETL programs using Informatica and SAS data transformation tools for both inbound and outbound data.  You will analyze and document business problems, develop test plans, and test and approve new system behaviors.  You will coordinate upgrades and rollouts of moderate scope and work with product owners and scrum masters to develop and deliver these solutions.
Responsibilities:
  • Develop ETL programs using Informatica and SAS.
  • Develop data analysis and reporting programs.
  • Develop and implement business-testing strategies.
  • Evaluate customer business requirements, and models data and/or system requirements.
  • Analyze and document business problems
  • May lead development projects or sub-projects.
  • May coordinate upgrades and rollouts of projects.
Qualifications:
  • Bachelors or Master’s Degree in technical or business discipline and 5 years related experience, or equivalent combination of education and work experience.
  • Knowledge of business operations, objectives, and strategies as well as business process and information flow.
  • Understanding complex ETL, data conversion and extract strategies.
  • General knowledge of diverse data management technologies and new and current architectures.
  • Advanced ETL programming skills and experience in SAS in order to create, import, transform, format, export, and analyze data files.
  • Intermediate experience in Informatica.
  • Intermediate to advanced SQL skill (structured query language)
  • Intermediate Excel skills and working knowledge of data analysis and BI tools such as Microstrategy, Hyperion, MS Access
  • Ability to communicate complex, technical information to a varied audience of technical and non-technical contacts is essential.  Works with customers and internal groups throughout the day to service requests, troubleshoot, and resolve issues on a daily basis.
  • The ability to create, read, and understand a data mapping document
  • Requirements writing
  • Test plan development and execution
  • Problem solving
  • Multi-tasking
We believe that a great job should keep you happy both at work—and in life. That’s why we offer:
  • Workplace Flexibility 
  • Wellness Perks
  • Collaborative workspaces
  • Sit/stand desks
  • Career development, programs and classes
  • Diversity & Inclusion programs
  • Commuter Benefits
  • Adoption Assistance
  • College Savings Plan
  • Education reimbursement
  • Hackathon Events
Liberty Mutual was named as a ‘2016 Great Place to Work’ by Great Place to Work US.
For more info about our benefits - Benefits Information
Learn more about Tech at Liberty Mutual –Search Our Jobs
Check out our Tech at Liberty Mutual YouTube playlist - Show me the Videos

Job: Technology
Primary Location: United States-Ohio-Fairfield
Schedule: Full-time
Salary: $74,600-$94,000
Education Level: Bachelor's Degree (±16 years)
Apply Later