Software Engineer, Data Team
Confluence Technologies14 days ago
Cape Town, South AfricaEntry Level / Mid Level
Responsibilities
- Build and evolve a multi-tenant data platform and Python data API.
- Develop backend services using layered router, service, and repository architecture.
- Migrate business and data logic from legacy SQL Server stored procedures into testable Python.
- Write parameterized SQL and use pandas for data computation and reshaping.
- Optimize queries, analyze execution plans, develop indexing strategies, and tune large-dataset performance.
- Support bulk and ETL data movement and reconciliation across heterogeneous data sources.
- Help integrate modern data platforms and warehouses, including Snowflake, through a unified API.
- Deploy and operate the platform using Docker, Azure, and infrastructure-as-code.
- Contribute to the architecture and long-term technical direction of the next-generation platform.
Requirements
- Bachelor’s degree in Software Engineering, Software Development, Computer Science, or a related field.
- 1–3 years of experience in software development.
- Strong proficiency in Python 3.12+ backend development, FastAPI, Pydantic v2, and T-SQL.
- Deep familiarity with enterprise application data and service layers.
- Expert-level SQL Server and data-engineering skills, including parameterized queries, query optimization, execution-plan analysis, indexing, set-based processing, bulk or ETL data movement, and performance tuning.
- Experience migrating logic from legacy stored procedures into Python.
- Exposure to modern cloud data platforms and warehouses such as Snowflake.
- Ability or interest to integrate multiple heterogeneous data sources through SQLAlchemy dialects.
- Sufficient Azure and DevOps capability to deploy and operate developed systems.
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.
- Flexible working options for all employees.
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.