Software Engineer, Data Team

Confluence is a global technology solutions provider focused on investment data challenges for the investment management industry. The Software Engineer will help build and shape a next-generation, multi-tenant data platform, primarily through backend and data-centric work on a Python data API. The role involves migrating legacy data logic into testable Python, integrating heterogeneous data sources, and supporting data correctness, performance, deployment, and operations.

Responsibilities:

• The Data Team is building the next-generation data platform — a multi-tenant platform that will become the shared data layer behind our applications
• 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
• You will help define the architecture and direction of that next-generation platform, not just maintain what exists
• 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
• 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 expect enough Azure and DevOps capability to deploy and operate what you build

Requirements:

• Bachelor's degree in Software Engineering/development, Computer Science, or related field
• 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. (Breadth and fundamentals matter more than any specific library or framework.)
• 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