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