Truelogic Software Logo

Truelogic Software

Senior Data Platform Engineer – Financial Services

Reposted Yesterday
In-Office or Remote
Hiring Remotely in Latham, NY
Senior level
In-Office or Remote
Hiring Remotely in Latham, NY
Senior level
Lead design, optimization, and management of enterprise data platform infrastructure with a focus on advanced SQL Server environments. Manage HA/DR, perform T-SQL development and performance tuning, enforce DB security, build scalable Python-based data pipelines and AWS IaC, integrate REST APIs, and architect AI/ML-ready data workflows.
The summary above was generated by AI
About Truelogic

At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals.

Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference.

By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future.

Our Client

A leading financial services organization operating a large-scale mortgage and investment platform, delivering technology-driven solutions that support complex pricing, trading, and servicing operations across the U.S. mortgage market.


Job Summary

The Senior Data Platform Engineer – SQL Server Specialist will lead the design, optimization, and management of enterprise data platform infrastructure, with a strong focus on advanced SQL Server environments. This role supports mission-critical systems including pricing analytics, trading workflows, hedging models, and operational data platforms.

The ideal candidate combines deep database expertise with modern cloud engineering and AI-enabled development practices, building scalable, high-performance data solutions that power both traditional analytics and AI/ML initiatives across the organization.

Responsibilities

SQL Server Administration & Architecture

  • Manage High Availability solutions including Always On Availability Groups, Failover Clustering, and HA/DR strategies.

  • Perform advanced T-SQL development (CTEs, Window Functions) and expert-level performance tuning (execution plans, indexing strategies).

  • Implement enterprise-grade database security including TDE, Row-Level Security (RLS), and RBAC governance controls.

Data Engineering & Cloud Integration

  • Design and build scalable data pipelines using Python 3, Pandas, SQLAlchemy, and orchestration tools (e.g., Airflow).

  • Manage AWS-based data infrastructure using Infrastructure as Code (Terraform/CDK) and serverless architectures.

  • Develop and integrate RESTful APIs (FastAPI/Flask) to support microservices and enterprise data exchange.

AI & Platform Innovation

  • Leverage AI-assisted development tools (e.g., GitHub Copilot, Cursor) to accelerate engineering workflows.

  • Architect data pipelines optimized for AI/ML workloads, including feature engineering and model deployment support.

Qualifications and Job Requirements
  • 5+ years of software development experience, including 4+ years of deep SQL Server expertise.

  • Expert knowledge of OLTP/OLAP systems, ETL/ELT patterns, replication, and enterprise database architecture.

  • Strong Python proficiency with solid OOP principles and experience with orchestration frameworks (e.g., Airflow).

  • Experience implementing CI/CD pipelines and DataOps best practices.

  • Proficiency with Git-based workflows and automated testing (unit and integration).

  • Strong communication skills with the ability to translate complex technical concepts into business-aligned solutions.

  • Experience working in Agile/Scrum environments using Jira or similar tools.

  • Demonstrated adaptability and interest in AI-driven engineering and cloud-native database strategies.

What We Offer
  • 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection.

  • Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings.

  • Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed.

  • Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock.

  • Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies.

Why You’ll Like Working Here
  • A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally.

  • Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America.

  • Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field.

Apply now!

Top Skills

Airflow
Always On Availability Groups
AWS
Cdk
Ci/Cd
Cursor
Dataops
Elt
ETL
Failover Clustering
Fastapi
Flask
Git
Github Copilot
Integration Testing
JIRA
Olap
Oltp
Pandas
Python 3
Rbac
Replication
Restful Apis
Row-Level Security
Serverless
SQL Server
Sqlalchemy
T-Sql
Tde
Terraform
Unit Testing

Similar Jobs

An Hour Ago
Remote or Hybrid
USA
70K-110K Annually
Mid level
70K-110K Annually
Mid level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Technical Account Manager, you will onboard customers, drive technical support, engage with clients, and lead project implementations while advocating for customer success.
Top Skills: ItilLinuxmacOSPmpWindows Server
An Hour Ago
In-Office or Remote
25 Locations
113K-148K Annually
Senior level
113K-148K Annually
Senior level
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
The Senior Associate, Partner Marketing will drive partner-oriented marketing strategies to increase adoption and engagement for Circle's products, managing multiple partner relationships and co-marketing campaigns.
Top Skills: BlockchainCryptoDigital AssetsFintechGoogle WorkspacemacOSPaymentsSlack
5 Hours Ago
Remote or Hybrid
USA
Mid level
Mid level
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Patent Attorney will manage patent portfolios, assist with patent prosecution, conduct invention mining, and utilize AI-driven workflows to enhance team efficiency.
Top Skills: AILegal TechnologyPatent ProsecutionSpreadsheets

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account