Software Engineer, Data Team
The Software Engineer on the Data Team at Confidential Client will focus on developing and evolving a next-generation multi-tenant data platform, primarily working on a Python-based data API and migrating legacy SQL Server logic into modern, testable Python code. This role emphasizes backend data engineering, performance optimization, and integration of heterogeneous data sources, contributing to the architectural direction and operational deployment of the platform in a hybrid remote work environment.
About Careertakes
👉 Important disclosure: Careertakes is a third-party recruiting platform supporting this hiring process. If selected, you will be employed directly by our client, Financial Services.
Applicants for this role may also receive access to additional matched opportunities through the Careertakes platform.
Role overview
Confidential Client is building a next‑generation multi‑tenant data platform and is hiring a Software Engineer (Data Team) to help design and deliver a robust Python-based data API and the surrounding data infrastructure. This is a backend- and data-focused role: you will work across the platform on data correctness, performance, migration from legacy stored procedures, and integrating heterogeneous data sources.
What You’ll Do
- Implement and maintain a Python 3.12+ backend API (FastAPI, Pydantic v2) for data access and transformation.
- Migrate business and data logic out of legacy T‑SQL/stored procedures into parameterized SQL and testable Python (pandas where appropriate).
- Author efficient parameterized queries, tune execution plans, and design indexing strategies to handle large datasets.
- Design and implement ETL / bulk data movement workflows for high-volume reconciliation and performance.
- Contribute to the platform architecture: router → service → repository layers, containerized with Docker and deployed via infrastructure-as-code.
- Integrate additional data sources (e.g., Snowflake) via SQLAlchemy dialects and help define patterns to serve them through a unified API.
- Collaborate with product and operations teams to deploy, monitor, and iterate (Azure and DevOps practices expected).
- Write tests, review peers’ code, and help establish reliable operational runbooks.
Minimum qualifications
- Bachelor's degree in Computer Science, Software Engineering, or related field.
- 1–3 years of professional software development experience.
- Strong proficiency in Python (3.12+), including async/await patterns.
- Experience with FastAPI and Pydantic (v2).
- Deep T‑SQL and Microsoft SQL Server expertise: query tuning, execution‑plan analysis, set‑based processing, indexing, and stored‑procedure migration.
- Experience with ETL patterns, bulk data movement, and working with large datasets.
- Practical familiarity with Docker and infrastructure-as-code deployment workflows.
- Comfortable with Azure or equivalent cloud platform and basic DevOps responsibilities.
Nice-to-have
- Hands-on experience with Snowflake or other modern cloud data warehouses.
- Familiarity with SQLAlchemy dialects and building abstractions for multiple data backends.
- Experience using pandas for data computation and reshaping at scale.
- Prior work on multi-tenant platforms or financial-services data systems.
- Knowledge of monitoring, observability, and performance profiling tools.
What we offer
- Competitive benefits and generous time-off policies.
- Global career development and exposure to multi-country projects.
- Social programs, referral bonuses, and additional employee perks.
- Flexible working arrangements.
Location & compliance
This position is based in Pittsburgh, PA. Confidential Client offers flexible working options and will comply with applicable state and federal employment laws. Applicants must have the legal right to work in the United States; pre-employment screening and background checks may be required.
Values
Confidential Client looks for candidates who demonstrate:
- Integrity — face reality with honesty and accountability
- Imagination — tackle challenges creatively
- Discipline — build reliable habits and sound engineering practices
- Service — commit to the success of colleagues and customers
Equal Opportunity & Hiring Transparency
Careertakes and our client are Equal Opportunity Employers committed to building a diverse and inclusive workforce. We prohibit discrimination or harassment of any kind. To support a fair and efficient hiring process, AI tools may be used to assist with application review or resume screening. These tools do not replace human decision-making. Final hiring decisions are made by people.
If you have questions about how your data is used, please contact us directly.
Negotiate a higher salary! Check the salary ranges for this job type in your area.
View My Salary Range