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 top mortgage lender with over 4 million lifetime customers. Will be part of the team that is responsible for design, development, testing, and implementation of a set enterprise level data warehouse systems and solutions.
Job Summary
The Senior Database Developer will be responsible for the design, development, testing, and implementation of a set of enterprise-level data warehouse systems and solutions. As the Database Developer, you will talk to users in gathering requirements and understand various internal/external dependencies that are very dynamic in nature and also require leadership across the full Systems Development Lifecycle as well as expertise in Data Warehousing architecture data modeling, and coding.
Responsibilities
Design, develop and maintain relational and dimensional databases supporting the data warehouse and data marts
Create entity relationship diagrams, data dictionaries and mapping documents
Utilize advanced transact-SQL, including stored procedures, ETL and OLAP tools to implement solutions
Support implemented solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
Perform code inspections and re-factor code to meet standards
Participate in data model reviews, walkthroughs, application and module performance analysis
Qualifications and Job Requirements
2+ years in scripting languages such as perl, python, powershell or programming languages such as C# or Java
Experience in developing OLAP cubes and data visualization technologies
Ability to perform routine DBA tasks including setting up access policy, data migrations, ETL operations, troubleshooting, and performance optimization
Programming experience with emphasis on designing complex SQL queries and business components
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!