ISO, a Verisk business, has been a leading source of information about property/casualty insurance risk since 1971. For a broad spectrum of commercial and personal lines of insurance, ISO provides statistical, actuarial, underwriting, and claims information and analytics; compliance and fraud identification tools; policy language; information about specific locations; and technical services. ISO serves insurers, reinsurers, agents and brokers, insurance regulators, risk managers, and other participants in the property/casualty insurance marketplace. To learn more about ISO please visit us at:  www.verisk.com/iso. We are proud to be a part of the Verisk family of companies! 

At the heart of what we do is help clients manage risk. Verisk (Nasdaq: VRSK) provides data and insights to our customers in insurance, energy and the financial services markets so they can make faster and more informed decisions.   

Our global team uses AI, machine learning, automation, and other emerging technologies to collect and analyze billions of records. We provide advanced decision-support to prevent credit, lending, and cyber risks. In addition, we monitor and advise companies on complex global matters such as climate change, catastrophes, and geopolitical issues.  

But why we do our work is what sets us apart. It stems from a commitment to making the world better, safer and stronger.  

It’s the reason Verisk is part of the UN Global Compact sustainability initiative. It’s why we made a commitment to balancing 100 percent of our carbon emissions. It’s the aim of our “returnship” program for experienced professionals rejoining the workforce after time away. And, it’s what drives our annual Innovation Day, where we identify our next first-to-market innovations to solve our customers’ problems.   

At its core, Verisk uses data to minimize risk and maximize value. But far bigger, is why we do what we do. 

At Verisk you can build an exciting career with meaningful work; create positive and lasting impact on business; and find the support, coaching, and training you need to advance your career. We have received the Great Place to Work® Certification for the fourth consecutive year. We’ve been recognized by Forbes as a World’s Best Employer and a Best Employer for Women, testaments to our culture of engagement and the value we place on an inclusive and diverse workforce. 

The ETL Data Engineer will provide Business Intelligence thought-leadership and guide the organization in leveraging its information assets to improve analytics, decision-making and overall business performance. In this hands-on role, he/she will be responsible for end-to-end solutions including requirements analysis, logical modeling, physical data object design, ETL process creation, and performance tuning in both on-premises and cloud environments. In addition, he/she will help the team evaluate new technologies and frameworks to drive innovation and satisfy the growing needs of internal and external customers

Responsibilities:

• Develop logical and physical data models to support business reporting and analytics
• Design Kimball style Facts and Dimensions for Data Warehouse
• Design denormalized data structures for MDM
• Document models and modeling standards
• Design, build, deploy and monitor ETL processes.
• Design ETL processes to load Data Warehouse and MDM table
• Integrate Tokenization into ETL processes to secure sensitive data
• Enhance Entity Resolution ETL processing for MDM
• Monitor ETL processes and data quality
• Document ETL processes and standards

• BS or MS degree in Computer Science or Information Technology.
• 2+ years of Data Warehousing experience.
• 2+ years of experience designing, developing, deploying, and maintaining ETL solutions.
• Strong knowledge of performance tuning concepts (set theory, query design, index tuning etc.) and the ability to write efficient, highly performant SQL.
• Strong knowledge of OLTP and OLAP database data modeling (2+ years)
• Strong knowledge of Dimensional Modeling following Kimball methodologies (2+ years)
• Strong knowledge of how to work with all types of data sources (RDBMS, NoSQL, REST API’s, flat files etc.)
• Working knowledge of Tokenization practices.
• Working knowledge of coding standards/best practices with the ability to follow established coding patterns.
• Working knowledge of object-oriented programing and design patterns.
• Working knowledge of programming languages such as Python, JavaScript, C#, Java.
• Proficiency with database technologies MySQL (Aurora), MSSQL, Oracle, S3, Redshift, Snowflake or equivalent.
• Proficiency with ETL tools (SSIS, Pentaho, etc.)
• Proficiency with version control systems (GIT) 
• Proficiency with database modeling tools (SqlDBM, Toad Data Modeler, Oracle Data Modeler, etc.)
• Ability to work within the Agile methodology and manage work to critical project timelines in a fast-paced environment.
• Experience building/working with MDM solutions is a plus.
• Experience using AWS serverless services such as lambda, S3, DynamoDB, and Step Functions is a plus.
• Proficiency with automated deployment software such as Bamboo and Octopus Deploy is a plus.
• Experience with one or more Business Intelligence platforms such as Spotfire, Tableau, Power BI is a plus.
• Familiarity with machine learning model training is a plus.
• Insurance industry experience is a plus.

#LI-JE1

Verisk Analytics is an equal opportunity employer.

All members of the Verisk Analytics family of companies are equal opportunity employers. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran's status, age or disability.

http://www.verisk.com/careers.html

Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine or email address, or directly to Verisk employees, will be considered Verisk property. Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.

Consumer Privacy Notice