Loading...
SeniorFull-timePythonJavaC#Git
Salary Range
$132,600 - $179,400 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
We are seeking a Database Developer to join our team at Truelogic, a leading provider of nearshore staff augmentation services. This role involves designing, developing, and maintaining enterprise-level data warehouse systems and solutions for a nationally recognized financial services company.
Key Responsibilities
- →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
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
- ★Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD
- ★Paid Time Off: We value your well-being with our paid time off policies
- ★Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done
- ★Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies
