Software Engineer, Data Team
Confluence Technologies3 months ago
Remote, United StatesMid Level
Responsibilities
- Build and evolve a multi-tenant Python data API and shared data platform.
- Migrate business and data logic from legacy SQL Server stored procedures into testable Python.
- Write parameterized SQL, optimize queries, analyze execution plans, and develop indexing strategies.
- Perform set-based processing, bulk and ETL data movement, and large-dataset performance tuning.
- Integrate heterogeneous data sources and warehouses behind a unified API.
- Deploy and operate services using Docker, infrastructure-as-code, Azure, and DevOps practices.
Requirements
- Bachelor’s degree in software engineering, software development, computer science, or a related field.
- Three years of software development experience.
- Strong proficiency in Python backend development, FastAPI, Pydantic, asynchronous programming, and T-SQL.
- Expert-level SQL Server and data engineering experience, including query optimization, execution-plan analysis, indexing, set-based processing, bulk data movement, and ETL.
- Experience or exposure to modern cloud data platforms and warehouses such as Snowflake.
- Comfort working with enterprise data and service layers and migrating stored-procedure logic into Python.
Benefits
- Generous time-off packages, including additional half days with each public holiday in the employee’s location.
- Global career development opportunities.
- Social events.
- Referral bonus scheme offering up to $3,000 per successful referral.
- Flexible working options; the role is US remote and aligned with the Eastern Standard Time Zone.
Categories
BackendData Engineering
About Confluence Technologies
Confluence Technologies builds software for the investment management industry, including data management, performance and risk analytics, and regulatory and investor reporting for asset managers, asset owners, and service providers. Founded in 1991 and headquartered in Pittsburgh, it is privately held under Clearlake Capital and expanded its analytics portfolio by acquiring StatPro in 2019. The company serves a global client base across front, middle, and back-office workflows.