Software Engineer, Data Team

Style Analytics; Pittsburgh (Allegheny County); On-site; USD 90,000 - 135,000; Full time

Benefits offered by this job

Time Off

Global Career Development

Social Events

Referral Bonus

Plus many more

Job summary

Confluence in Pittsburgh, PA is seeking a Software Engineer with a data‑engineering focus to join the Data Team. You’ll work on the data API, migrate logic from legacy procedures to Python, and shape the next‑generation data platform with SQL, pandas, and SQLAlchemy behind a unified API.

You’ll collaborate across the data platform, emphasize data correctness, performance, and large‑dataset movement, using Azure and DevOps for deployment and operation.

Qualifications

• Bachelor’s degree in Software Engineering/development, Computer Science, or related field.
• 1-3 years of experience in software development.
• Strong proficiency in Python (3.12+) backend development — FastAPI, Pydantic v2, async/await — and T-SQL, with deep comfort in the data and service layers of an enterprise application.
• Expert‑level SQL Server and data engineering: parameterized query authoring, query optimization and execution‑plan analysis, indexing strategy, set‑based processing, and bulk / ETL data movement and large‑dataset performance tuning — plus comfort migrating logic out of legacy stored procedures into Python.
• Exposure to modern cloud data platforms and warehouses (e.g. Snowflake) and an interest in integrating multiple, heterogeneous data sources — each just another SQLAlchemy dialect — behind a unified API.

Responsibilities

• Migrate legacy logic to Python for data retrieval and computation.
• Develop and maintain a Python data API backed by SQLAlchemy.
• Collaborate across the data platform to define architecture and direction for the next‑gen platform.
• Focus on data correctness, performance, and large‑scale data movement across heterogeneous sources.

Skills

Python backend development

FastAPI

SQL Server

Data engineering

Snowflake integration

Azure & DevOps

Education

Bachelor's degree in Software Engineering/Computer Science

Tools

Docker

SQLAlchemy

Job description

Why Confluence?

At Confluence, we’ve always been driven by a commitment to innovation, precision, and partnership in the investment data space. Our global footprint now spans multiple countries, giving our employees the opportunity to get exposure to other countries and cultures. And it stands to reason that none of this would have been possible without the hundreds of hard‑working employees who work at Confluence.

Location: Pittsburgh, PA

Data Team Overview

The Data Team is building the next-generation data platform — a multi-tenant platform that will become the shared data layer behind our applications. At the heart of that platform is a Python data API built on a layered router → service → repository architecture, containerized with Docker and deployed entirely through infrastructure‑as‑code.

Today the platform is SQL Server‑heavy, and part of this role is migrating business and data logic out of legacy stored procedures into testable Python — parameterized SQL for retrieval, pandas for computation and reshaping. As we evolve, we intend to grow well beyond a single database — incorporating additional and modern data sources (for example, Snowflake, which the API’s SQLAlchemy‑based connection registry is already designed to add) and the patterns needed to serve them through a unified API. This is a foundational, shaping role: you will help define the architecture and direction of that next‑generation platform, not just maintain what exists.

We are seeking a Software Engineer with a strong data‑engineering focus to join the Data Team. The role is primarily focused on the data API, but it is a team role rather than a single‑service one — you will work across the data platform as it grows. This is backend‑ and data‑centric work: you will spend more time on data correctness, performance, and the movement and reconciliation of large datasets across heterogeneous sources than on any single framework or UI library. We value depth in the core technologies and engineering fundamentals over expertise in any specific component, and we expect enough Azure and DevOps capability to deploy and operate what you build.

Qualifications

• Bachelor’s degree in Software Engineering/development, Computer Science, or related field.
• 1‑3 years of experience in software development.
• Strong proficiency in Python (3.12+) backend development — FastAPI, Pydantic v2, async/await — and T‑SQL, with deep comfort in the data and service layers of an enterprise application.
• Expert‑level SQL Server and data engineering: parameterized query authoring, query optimization and execution‑plan analysis, indexing strategy, set‑based processing, and bulk / ETL data movement and large‑dataset performance tuning — plus comfort migrating logic out of legacy stored procedures into Python.
• Exposure to modern cloud data platforms and warehouses (e.g. Snowflake) and an interest in integrating multiple, heterogeneous data sources — each just another SQLAlchemy dialect — behind a unified API.

Benefits

• Generous Time Off packages including additional half days with each public holiday in your location.
• Global Career Development opportunities
• Social Events
• Referral Bonus scheme - Upto $3,000 per successful referral
• Plus many more!

More about the Location

We offer flexible working options for all employees.

Values

Integrity

Face reality with honesty, courage and accountability

Imagination

Deal creatively with challenges and envision what the world could be

Discipline

Build good habits into reflexes which become a part of our life

Service

Committed to the success of others

AI Friendly Interview Process

We recognise that AI tools are becoming a standard part of how many people work. Candidates are welcome to use AI throughout our interview process.

If you choose to use AI during an interview or assessment, we may ask you to share your screen so that we can better understand your thinking, decision making and approach to using the technology.

Our aim is to assess your skills, experience, judgement and problem solving abilities, including how you make use of modern tools in a professional setting.

Pre‑Employment Screening Disclaimer

As part of our recruitment process, we carry out identity checks on all candidates. Offers of employment are conditional upon the completion of satisfactory background checks prior to the commencement of work. These checks may include verification of identity, right to work in the UK, employment history, and other relevant pre‑employment screening.

Please note that additional checks may be required depending on the nature of the role and the jurisdiction in which the role is based or operates. These may include, but are not limited to, criminal record checks or financial background checks where applicable.

If you believe that this job posting is noncompliant, please email us at [e-mail].

As a leading global technology solutions provider to the investment management industry, Confluence helps clients solve complex investment data challenges across the front, middle and back office. Headquartered in Pittsburgh, PA, Confluence services over 1000 clients in 40 countries, with locations across Europe, North America, South Africa, Australia and Asia.