Data Engineer

The Data Engineer will help develop, deploy, manage and maintain analytic data products within MS SQL Server, Snowflake, AWS cloud technology or other environments utilizing tools and languages including SQL, Python and Tableau. The role will require the data collection, analysis, preparation and processing of big data and the building of predictive models and analytic data solutions including their deployment and ongoing maintenance. Additionally, the role will require the management and maintenance of a legacy database application and several databases requiring skills and experience in MS SQL Server, database administration, OLAP (SSAS), data orchestration/ETL (SSIS) and the development, maintenance and support of databased applications.   To be successful in this role, the Data Engineer will need a solid understanding of data processing and data science processes, data wrangling and database management tools and have good problem-solving and analytical skillsets.  Additionally, experience with MS SQL Server as an administrator, developer, manager or maintainer of databases and database applications. 

This role will report to the Senior Manager of Data Analytics.
 

The roles and responsibilities of the Data Engineer will include, but are not limited to:

• Refine and improve core analytic products and services including Connex segmentation platform and predictive modeling capabilities.
• Manage and implement database updates on periodic refreshes to key data sets including the Simmons/MRI Survey of the American Consumer.
• Implement new analytic product updates including deployment of Connex Targets builds and its integration into production systems such as Connex Cluster Explorer.
• Load, process, and provide analysis on a wide range of data for analytic use within Enterprise databases such as Snowflake, SQL Server and AWS cloud environments.
• Assist and support execution of analytic projects including client Connex Interactive Profile projects and custom predictive models.
• Assist and support for the development and maintenance of the Connex product line including the Connex V8.0 development road map.
• Develop and refine interactive visual dashboards and applications using Tableau and other dashboarding and reporting tools.
• Execution of complex SQL queries supporting list counts, extracts and fulfillment.
• Assist with processing and automation of analytic data solutions including data ingestion, cleansing, enhancement, transformation, data preparation, model building, model deployment and model operations.

• Help build, deploy and manage predictive models leveraging best practices for the model management lifecycle.
• Contribute to analytic data product development including product. enhancements, exploring alternatives, and implementation of prototypes and PoCs.
• Work and collaborate with other Data Engineers, Data Scientists, Product Managers to effectively explore, define, build and deploy analytic solutions and products.
• Create necessary documentation for technical design, process and data flows, project tracking, training material, etc.
• Manage and administer MS SQL Server databases and OLAP applications for SaaS product
• Maintain and support database applications and provide technical support
• Service ad hoc data requests and extracts
• Manage operations for the database application including periodic batch jobs and email deployment campaigns.

Highly qualified applicants should have the following qualifications and skills:

• Detailed oriented with strong analytical skills.
• Solid background and experience with database management platforms, data processing, ETL and data wrangling.
• Proficiency with using SQL required, and other languages such as python desired.
• Good experience and familiarity with MS SQL Server is highly desirable including as DBA, database developer or operations and utilizing such components as T-SQL, SSAS (OLAP) and SSIS (data orchestration). 
• Good familiarity with data visualization tools such as Tableau, Excel, Microsoft BI.
• Good familiarity with data cleansing and data quality tools that perform address cleaning, parsing, deduping and matching.
• Proficiencies with office productivity suite Microsoft Office (particularly Excel) or other similar suite of tools.   
• Ability to create and produce data driven reports that clearly summarize results and insights.
• Previous workplace experience with at least 5 years of experience required with 3 or more years in similar field.
• College graduate or higher with a degree in data engineering, data analysis, data sciences and/or computational sciences or similarly related technical/analytical foundation. 

• Work independently and as a part of a team.

• Effective organization skills with the ability to simultaneously work on multiple projects, prioritize, and manage overall workload.
• Experience or familiarity in the application of machine learning algorithms and predictive analytics to building data and analytic solutions and products is desirable.
• Experience with building or maintaining analytic and predictive modeling solutions using cloud-based tools in AWS, Snowflake or 3rd party tools such as H2O Driverless AI is a plus.
• Experience using data science, data wrangling and python programming libraries such as scikit-learn, XGBoost, LightGBM, Snowpark or others is a plus.
• Experience as a member of an agile (Scrum/Kanban) product development or engineering team is a plus.

For over 50 years, Verisk has been the leading data analytics and technology partner to the global insurance industry by delivering value to our clients through expertise and scale. We empower communities and businesses to make better decisions on risk, faster.

At Verisk, you'll have the chance to use your voice and build a rewarding career that's as unique as you are, with work flexibility and the support, coaching, and training you need to succeed. 

For the eighth consecutive year, Verisk is proudly recognized as a Great Place to Work® for outstanding workplace culture in the US, fourth consecutive year in the UK, Spain, and India, and second consecutive year in Poland.  We value learning, caring and results and make inclusivity and diversity a top priority.  In addition to our Great Place to Work® Certification, we’ve been recognized by The Wall Street Journal as one of the Best-Managed Companies and by Forbes as a World’s Best Employer and Best Employer for Women, testaments to the value we place on workplace culture.

We’re 7,000 people strong.  We relentlessly and ethically pursue innovation. And we are looking for people like you to help us translate big data into big ideas. Join us and create an exceptional experience for yourself and a better tomorrow for future generations.

 Verisk Businesses

Underwriting Solutions — provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision

Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences

Property Estimating Solutions — offers property estimation software and tools for professionals in estimating all phases of building and repair to make day-to-day workflows the most efficient

Extreme Event Solutions — provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events.

Specialty Business Solutions — provides an integrated suite of software for full end-to-end management of insurance and reinsurance business, helping companies manage their businesses through efficiency, flexibility, and data governance

Marketing Solutions — delivers data and insights to improve the reach, timing,relevance, and compliance of every consumer engagement

Life Insurance Solutions – offers end-to-end, data insight-driven core capabilities for carriers, distribution, and direct customers across the entire policy lifecycle of life and annuities for both individual and group.

Verisk Maplecroft — provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become stronger

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. Verisk’s minimum hiring age is 18 except in countries with a higher age limit subject to applicable law.

https://www.verisk.com/company/careers/

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.

Verisk Employee Privacy Notice