Data Engineer, Data Solutions

NISA Investment Advisors, LLC•Clayton, MO

8d•Onsite

About The Position

NISA Investment Advisors, LLC (NISA) partners with world-leading organizations to design, develop, and manage highly customized, risk-controlled investment strategies across fixed income, equities, and derivatives. With $482 billion assets under management ($299 billion in physical assets and $184 billion in derivatives notional value), NISA actively manages risk for institutional investors, providing clarity to complicated challenges and stability in ever-evolving markets. At NISA, we foster a culture that supports both personal and professional growth, providing opportunities to learn from experienced professionals while contributing meaningful work from the outset. We seek candidates who demonstrate strong quantitative and analytical skills, intellectual curiosity, and a collaborative mindset to join our growing teams. The Data Engineer, Data Solutions is a member of NISA’s Data Engineering team responsible for creating, updating and supporting ETL/ELT data pipelines for a variety of stakeholders across the enterprise. They will define, design, develop, unit test and support new and existing solutions to meet complicated and time-sensitive business requirements. In addition, the Data Engineer supports and manages high-severity production incident resolution, performs code reviews, and participates in on-call rotations. They should be comfortable working in a fast-paced team environment and have the skills to troubleshoot and resolve data integration issues independently.

Requirements

Bachelor’s degree in Computer Science or a related field or relevant work experience required
5+ years of experience with ETL/ELT
3+ years of experience with SQL
Experience with Python, C#, or similar high-level language
Experience with AWS, AWS Lambda, S3, Airflow, and related technologies
Professional work experience with Databricks or PySpark
Demonstrated team player who works well in a fast-paced environment and can adapt to changing priorities, demands, and timelines
Strong analytical and innovative problem-solving skills, along with a solid attention to detail.
Excellent customer support skills

Nice To Haves

Microsoft SQL Server database development
PostgreSQL database development
SSIS development
Working knowledge of Airflow or a similar business automation tool
Developing software/databases in an Agile environment

Responsibilities

Creating, updating and supporting ETL/ELT data pipelines for a variety of stakeholders across the enterprise.
Defining, designing, developing, unit testing and supporting new and existing solutions to meet complicated and time-sensitive business requirements.
Supporting and managing high-severity production incident resolution.
Performing code reviews.
Participating in on-call rotations.
Troubleshooting and resolving data integration issues independently.