Truelogic Software

Senior Database Developer – Finance

Truelogic Software

full-time

Posted on:

Location Type: Remote

Location: Mexico

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

ETLJavaPerlPythonSQL

About the role

  • 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.

Requirements

  • 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).
Benefits
  • 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Transact-SQLSQLPythonPerlPowerShellC#JavaETLOLAPdata modeling
Soft Skills
problem solvingcommunicationcollaborationattention to detailanalytical thinking