Senior Data Engineer

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

Become a member of the growing EES software development team responsible for EES’s flagship SaaS Solution. Our data-rich products deploy a host of cutting-edge technologies to build high-performance and scalable products in AWS Cloud. As an experienced software engineer you will be responsible for designing and building solutions and components using Python, PostgreSQL , AWS technologies (Redshift, Aurora, Glue etc.) and other technologies for enterprise scale multi-user applications.

Responsibilities

· Contribute to the distributed database schema design geared for scalability and performance using MPP database engines (Redshift) and relational transactional engines (Aurora)

· Strong experience with PostgreSQL (version 4 or higher) including database design, query optimization, and performance tuning.

· Proficiency in AWS (Amazon Web Services) with a focus on services like EC2, S3, RDS, and IAM. Experience in deploying and managing applications on AWS.

· Excellent programming skills in Python with the ability to develop, maintain, and debug Python-based applications.

· Troubleshoot and resolve database-related issues.

· Stay up to date with the latest industry trends and technologies related to PostgreSQL, AWS, and Python.

· Design and implement risk management business functionality and in-database analytics.

· Identify complex data problems and review related information to develop and evaluate options and design and implement solutions.

· Design and develop functional and responsive web applications by collaborating with other engineers in the Agile team.

· Strong working knowledge of SQL Server 2012/2016 with proficiency in performance tuning, troubleshooting, and writing T-SQL stored procedures in a commercial application centric environment.

· Strong understanding of RDBMS concepts

· Experience with or good understanding of Big Data concepts

· Good knowledge of AWS data platforms like Aurora/Redshift/RDS.

· Expertise in object-oriented programming

· Strong problem-solving skills Fast learner and keen to learn.

· Excellent listening skills Good written and verbal communication skills Enthusiasm, energy, and creativity

#LI-AO1

Qualifications

· B.S. in Math, EE, CS or Software Engineering; M.S preferred.

· 5+ years of hands-on experience in development of commercial-grade software products.

· 5+ years of SQL Server development, programming with T-SQL

· 3+ years of Experience with AWS technologies (Redshift, RDS, S3, Glue,)

· 3+ years of hands-on experience with Strong understanding of AWS services and infrastructure, deploying and managing applications on AWS.

· 4+ years proven work experience of with PostgreSQL, proving expertise in database design, administration, and performance optimization. ability to troubleshoot and resolve complex database-related issues.

· 1+ years of proven experience in Python in developing and supporting Python-based applications.

· Strong understanding of Agile process and best practices

· Strong knowledge of the latest technologies and trends.

· Ability to develop use-cases for business requirements.

· Ability to collaborate effectively with project stakeholders outside of Dev. group, especially with Product Management on feature requirements and project schedules.

· Ability to provide effective technical leadership and oversight to development team on a project, ensuring that software developed is in adherence to established architecture, design, quality standards, as well as delivery schedul

Additional Information

In 2022, Verisk received Great Place to Work® Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India. We’re also one of the 38 companies on the UK’s Best Workplaces™ list and one of 18 companies on Spain’s Best Workplaces™ list.

For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact. From our historic roots in risk assessment, we’ve grown to provide analytic insights that help transform industries focused on some of the world’s most critical areas. Today, the insurance industry relies on Verisk to be, and to make the world, more productive, resilient, and sustainable.

Verisk works in collaboration with our customers and at the intersection of people, data, and advanced technologies. Through proprietary platformed analytics, advanced mode