Data Engineer II

Company Description

We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.

Job Description

Data Warehouse Dimensional Modeler is a mid-to-senior level position that will provide data pipeline expertise and business intelligence leadership to guide the development and implementation of data products and reporting solutions within the Verisk Claims Solutions division. The successful candidate has experience developing data pipelines using cloud services and designing data structures that support data products and reporting systems. In this hands-on role, he/she will be responsible for collaborating with product owners, tackling technical problems, helping define best practices, and contributing in design/code reviews. In addition, the candidate will help create innovative solutions to satisfy the growing needs of internal and external customers.

About the Day-to-Day Responsibilities of the Role

·       Data Table Design – Design, review, and build Kimball data models for data products and business intelligence reporting systems like Power BI and ThoughtSpot.

·       Pipeline Development - Design and develop data pipelines using AWS services like Glue, Step Functions, Lambda, SNS, SQS and S3 in conjunction with computing platforms like Snowflake and Databricks.

·       Collaboration – Work closely with product owners to understand and refine new feature requests. Work closely with data engineering team to design, review, and develop new data pipelines.

·       Communication - Ability to communicate technical ideas in terms product owners and non-technical users can understand.

·       Best Practice - Ensure standard practices are followed for logging, monitoring, alerting and data security.

·       Data Security – Understand Verisk data security policies and controls and design and implement ways to comply with the policies.

Qualifications

·       BS or MS degree in Computer Science, Information Technology, or related field.

·       3+ years of Data Modeling experience  (Tableau, Power BI, ThoughtSpot, Kimball).

·       3+ years of experience designing and developing cloud data pipelines (ETL/ELT solutions).

·       3+ years of Data Warehousing experience.

·       Experience using Python for automating processes, working with APIs, and/or transforming data.

·       Experience building data pipelines using a variety of data sources (RDBMs, NoSQL, REST API’s, AWS SQS, and files).

·       Experience working with Snowflake (or equivalent).

·       Experience working with tokenized PII is a plus.

·       Working knowledge of development standards/best practices with the ability to follow established design patterns.

·       Proficiency with version control systems (GIT) 

·       Proficiency with database modeling tools (SqlDBM, etc.)

·       Insurance industry experience is a plus.

#LI-AO1

Additional Information

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 fifth 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.  Verisk’s Statement on Racial Equity and Diversity supports our commitment to these values and affecting positive and lasting change in the communities where we live and work.

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

At Verisk, the health and safety of our people is our number one priority.  Effective November 15, 2021, and subject to applicable law, all prospective hires for office based roles or roles that support any of our businesses’ government contracts will be required to demonstrate that they are fully vaccinated against COVID-19 by their start date, or qualify for a legally-required medical or religious accommodation to this vaccination requirement, as a condition of employment. Hired candidates who do not demonstrate that they are fully vaccinated against COVID-19 by their start date, and who have not been approved for a legally-required medical or religious accommodation will no longer meet the requirements for employment and their offers of employment will be immediately rescinded, in accordance with applicable law.