Data Engineer

Experience Required

5 years

Minimum Education Required

Bachelor Degree

Compensation

$166,754.00 - $171,754.00 / Yearly

Hours Per Week

40

Number Of Positions

1

Shift

First Shift (Day)

Job Description

Insurance Services Office, Inc. seeks a Data Engineer in Jersey City, NJ.

Duties:

• Expand and optimize our data pipeline architecture.

• Support our software developers, data analysts and data scientists on various data initiatives.

• Lead creation of data architecture that produces our data assets to enable our data platform.

• Work closely with business leaders, architects, engineers, data scientists and wide range of stakeholders throughout the organization to build and execute our strategic data architecture

vision.

• Understand SQL queries.

• Ability to fine tune queries based on various RDBMS performance parameters such as indexes, partitioning, Explain plans and cost optimizers.

• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS technologies stack

• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

• Work with data scientists and industry leaders to understand data needs and design appropriate data models.

• Participate in the design and development of the AWS-based data platform and data analytics.

Employer accepts a Bachelor's degree in Computer Science, Software Engineering, Analytics or a related field plus 5 years of related experience.

Requires 5 years of experience in the following:

• Design and implementation of data ETL frameworks for secured Data Lakes.

• Creating and maintaining optimal data pipeline architecture.

• Examine complex data to optimize the efficiency and quality of the data being collected, resolve data quality problems, and collaborate with database developers to improve systems and database designs.

• Building data applications using all of the following: AWS Glue, Lake Formation, Athena, AWS Batch, AWS Lambda, Python, Linux shell, and Batch scripting.

• Experience in one of the following AWS Database services: Redshift, RDS, DynamoDB, or Aurora.

• Experience in writing one of the following advanced SQL scripts: Self joins, windows function, correlated subqueries, or CTEs

In the alternative, the employer will accept a Master’s degree in Computer Science, Software Engineering, Analytics or a related field plus 2 years of experience.

Requires 2 years of experience in the following:

• Design and implementation of data ETL frameworks for secured Data Lakes.

• Creating and maintaining optimal data pipeline architecture.

• Examine complex data to optimize the efficiency and quality of the data being collected, resolve data quality problems, and collaborate with database developers to improve systems and database designs.

• Building data applications using all of the following: AWS Glue, Lake Formation, Athena, AWS Batch, AWS Lambda, Python, Linux shell, and Batch scripting.

• Experience in one of the following AWS Database services: Redshift, RDS, DynamoDB, or Aurora.

• Experience in writing one of the following advanced SQL scripts: Self joins, windows function, correlated subqueries, or CTEs

Benefits offered include health, vision, and dental plans; 401K program with employer matching; pre-tax transit, parking, and health savings account options; telemedicine; flexible spending accounts; life and disability insurance; global well-being and thrive wellness programs; employee stock purchase plan; legal services; and more

$166,754 to $171,754 per year. Must also have authority to work permanently in the U.S. Applicants who are interested in this position may apply to jobpostingtoday.com Ref# 48692

Place of Work

On-site

Requisition ID

48692

Job Type

Full Time