Truelogic
Location
Bogota
Salary
Not specified
Posted
Recently
Job Type
Full Time
Required Skills
About the Role
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 is a leading, nationally recognized financial services company specializing in the U.S. mortgage market. Serving millions of customers, the organization operates through a modern, digital-first platform focused on efficiency, transparency, and customer experience. Its mission is to make homeownership more accessible by delivering reliable, competitive, and customer-centered lending solutions.
The Senior Database Developer will be responsible for the design, development, testing, and implementation of enterprise-level data warehouse systems and solutions. This role involves working closely with business users to gather requirements, understand internal and external data dependencies, and translate business needs into scalable data architectures. The position requires strong expertise in data warehousing, data modeling, and SQL development, as well as leadership across the full Systems Development Lifecycle to ensure high-performance, reliable, and secure data platforms.
Design, develop, and maintain relational and dimensional databases for data warehouses and data marts.
Create entity relationship diagrams, data dictionaries, and data mapping documentation.
Develop and implement solutions using advanced Transact-SQL, including stored procedures, ETL, and OLAP tools.
Monitor, tune, and optimize queries and data loads to ensure performance and reliability
Support users by addressing data integrity questions and resolving functional and technical issues.
Perform code inspections and refactor code to meet quality and performance standards.
Participate in data model reviews, walkthroughs, and performance analysis.
Assist with application and module performance optimization.
Perform other related duties as assigned.
Demonstrate behaviors aligned with the organization’s culture and values.
2+ years of experience with scripting or programming languages such as Python, Perl, PowerShell, C#, or Java.
Strong experience designing complex SQL queries and business components.
Experience developing OLAP cubes and working with data visualization technologies.
Hands-on experience with ETL processes and data warehouse environments.
Ability to perform routine DBA tasks, including access policies, data migrations, ETL operations, troubleshooting, and performance optimization.
Solid understanding of relational and dimensional data modeling.
Financial Services experience preferred, ideally within the mortgage industry.
Python scripting and/or SQL scripting.
OLAP cubes.
Data visualization.
DBA tasks (access, migrations, ETL, troubleshooting, optimization).
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.
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!
Benefits
