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