Senior Data Platform Engineer – Financial Services | Mexico at Truelogic

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!