📁
Technology and Digital
💼
Westfield Insurance
📅
210000FL Requisition #

BUILD YOUR FUTURE…WHILE PROTECTING THEIRS.

 

You will be challenged. Rewarded. And valued for your unique experience, background and perspective.

 

Join a team where hard work pays off and original thinking is celebrated. As you build your future at Westfield, you will quickly learn that protecting our customer’s future is at the heart of what we do. We deliver on our promise to help restore lives and rebuild businesses when the unexpected happens. Building relationships has been part of our culture since 1848.  Be a part of a team that recognizes and appreciates those who take initiative, seek opportunity, and strive for innovation in a changing world.

 

Westfield’s IT organization enables the company’s strategic priorities in collaboration with our business partners.  By continually transforming and evolving with the business, we deliver new solutions to meet their needs, using trailblazing technologies and integration with top industry software products.  Through our innovative work, made possible by the stability of our 170+ year history, we are able to provide our agents and customers with insights and solutions to protect them and help them prosper.

 

Data Engineer 2 Job Summary

Location:  Westfield Center, OH Home Office or open to remote worker within our national operating territory

 

As a member of the Enterprise Information Management and Analytics (EIMA) team within the IT department, a Data Engineer will have direct impact on important initiatives that enable our business by architecting, designing, and implementing advanced analytics capabilities.  Working in an agile team environment, the Data Engineer partners with other engineers, members of business units and IT to bring their vision to the table and implement positive change in taking the company's data analytics to the next level. 

 

Primary responsibilities include designing, building and managing custom data pipelines and (ETL) processes in support of data initiatives. They will have broad skills in database design, be comfortable dealing with large and complex data sets, have experience building self-service dashboards, be comfortable using visualization tools, and be able to apply their skills to generate insights that help solve business challenges. 

 

The Data Engineer is expected to be an excellent communicator that challenges themselves and has a strong desire to continually improve their knowledge and skills.  The level 2 Data Engineer works under general supervision and is a peer mentor to less experienced Data Engineers.

 

Essential Functions (primary functions and/or reasons the job exists in order of importance)

  1. Populate data warehouses, data marts, and build data pipelines to meet demand for data across the organization using traditional data integration technologies including, ETL, data replication/CDC, message-oriented data movement and API development.
  2. Optimize data availability with intention to refine and enhance AI/ML models and algorithms in partnership with data analysts, data scientists, and other data consumers across IT and the business. 
  3. Drive continuous improvement in performance of data warehouses and partner with others across IT to ensure both timely availability and security of data.
  4. Support daily operations via analyzing and correcting incidents and defects in a timely and accurate fashion. 

 

Desired Qualifications/Experience/Certification/Education (in order of importance)

  1. 6+ years of work experience in data management disciplines including data integration, modeling, data security, and data quality, and/or other areas directly relevant to data engineering responsibilities and tasks.
  2. 3+ years of experience working in agile teams.
  3. Highly skilled at SQL programming.
  4. Highly skilled at ETL tools and methods.  Experience with DataStage is a must, experience with Python and other ETL tools is important.
  5. Highly skilled at data analysis with the goal of discovering useful information, informing conclusions, and supporting decision-making. 
  6. Skilled at performing complex operations against large, heterogeneous datasets and at consuming and working with large volumes of unstructured data in formats such as XML, JSON, etc.,
  7. Skilled in working with relational databases (Netezza, DB2, SQL Server) and nonrelational databases, (NoSQL/Hadoop oriented databases like MongoDB, and Azure), in multiple deployment environments including cloud, on-premises, and hybrid.
  8. Skilled at building conceptual, logical and physical data models.  Experience with ErWin or other modeling tools is important. 
  9. Skilled in API development with various protocols (e.g. SOAP, REST).  Experience with Mulesoft platform a plus.
  10. Skilled in working with both open-source and commercial message queuing technologies (e.g. MQ, RabbitMQ, Kafka), and stream analytics technologies (e.g. Apache Kafka KSQL, Apache Spark Streaming).
  11. Knowledgeable in writing simple scripts to automate manual, repeatable tasks. Familiarity with scripting languages (e.g. Python, Powershell, Bash) a plus.
  12. Knowledgeable at data visualization using tools such as Cognos, Tableau, and OutSystems a plus.
  13. Knowledgeable with DevOps and containerization tools (e.g. Kubernetes, Docker, Git, Azure DevOps, Jenkins, UCD, Puppet, Chef, Ansible, etc.) a plus.
  14. Bachelor’s degree in Information Technology, Computer Science, Engineering, Mathematics or related field or commensurate experience.

 

Physical Requirements (specific to the role)

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. 

  • Ability to work effectively for 40+ hours per week (including sitting, standing, and working on a computer for extended periods of time).
  • Ability to communicate effectively in a collaborative work environment utilizing various technologies such as:  telephone, computer, web, voice, teleconferencing, e-mail, etc.
  • Ability to respond to emergency service calls at any time outside of normally assigned work hours.
  • Ability to travel as required.

 

This job description describes the general nature and level of work performed in this role. It is not intended to be an exhaustive list of all duties, skills, responsibilities, knowledge, etc. These may be subject to change and additional functions may be assigned as needed by management.

 

We are an equal opportunity employer/minority/female/disability/protected veteran.

 

#LI-AF1

#LI-Remote

Applications for positions posted on Westfield Careers must be filed on-line through the Westfield Careers portal.  If you are a disabled person who requires a reasonable accommodation to complete an online application, please contact HR Assist by email at hrassist@westfieldgrp.com.


We are an equal opportunity employer/minority/female/disability/protected veteran.

Previous Job Searches

Create/Manage a Profile

When you join our Talent Community, you can choose to be alerted to new career opportunities that are a potential match for you as they become available.

My Profile

My Submissions

When you apply for individual job opportunities, you can keep track of them here.

My Submissions

Similar Listings

Westfield Insurance

Westfield Center, Ohio

📁 Technology and Digital

Requisition #: 210000FK

Westfield Insurance

Westfield Center, Ohio

📁 Technology and Digital

Requisition #: 210000FH

Westfield Insurance

Westfield Center, Ohio

📁 Technology and Digital

Requisition #: 210000E6