Data Engineer, Data Solutions

NISA Investment Advisors, LLC; St. Louis (MO); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Onsite cafeteria

Gym

Wellness program

Educational assistance

Job summary

NISA Investment Advisors, LLC is seeking a Data Engineer in the Data Solutions team to create, update, and support ETL/ELT data pipelines for a variety of stakeholders across the enterprise. The role involves defining and developing data solutions, testing, and supporting production incidents in a fast-paced environment.

The candidate should have 5+ years of ETL/ELT experience, strong SQL and programming skills (Python/C#), and experience with AWS, Airflow, Databricks or PySpark.

Qualifications

• Bachelor’s degree in Computer Science or related field or equivalent work experience.
• 5+ years of ETL/ELT experience.
• 3+ years of SQL experience.
• Experience with Python, C#, or similar high-level languages.
• Experience with AWS, Lambda, S3, Airflow.
• Professional work experience with Databricks or PySpark.
• Demonstrated ability to work in a fast-paced team environment and adapt to changing priorities.
• Strong analytic and problem-solving skills and attention to detail.
• Excellent customer support skills.

Responsibilities

• Create, update and support ETL/ELT data pipelines for multiple stakeholders.
• Define, design, develop, unit test and support new/existing data solutions to meet business needs.
• Support and manage high-severity production incident resolution and perform code reviews.
• Participate in on-call rotations and troubleshoot data integration issues.

Skills

ETL/ELT

SQL

Python

C#

AWS

Airflow

Databricks

PySpark

Teamwork

Analytical skills

Customer support

Education

Bachelor's degree in Computer Science or related field

Tools

Databricks

PySpark

Airflow

Job description

Overview

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.

Responsibilities

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.

Qualifications

• 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

Preferred Experience

• 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

NISA’s culture encourages collaboration and innovation. We seek self-motivated, intellectually curious individuals willing to push themselves and others in an environment that celebrates fresh thinking. We equip employees with the resources needed to excel and we encourage personal development. NISA is dedicated to internally cultivating and rewarding talent. Employees at NISA are provided with a wide range of benefits, including a complimentary onsite cafeteria, gym, health and wellness program, and educational assistance program.

NISA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.