Transcend Softech LLC

SQL Developer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a senior SQL Developer with 10+ years of experience, focusing on SQL query optimization and ETL processes. Contract length is unspecified, with a pay rate of "unknown." Location is Dallas or 100% remote. Financial services experience preferred.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
800
-
πŸ—“οΈ - Date
August 4, 2026
πŸ•’ - Duration
Unknown
-
🏝️ - Location
Remote
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Dallas, TX
-
🧠 - Skills detailed
#Data Profiling #Data Integration #Microsoft Power BI #Datasets #SSIS (SQL Server Integration Services) #BI (Business Intelligence) #"ETL (Extract #Transform #Load)" #SQL Queries #Consulting #SQL Server #SQL (Structured Query Language)
Role description
(Only US Citizens - As per clients visa restrictions) We need a senior (10+ years, 15 preferred) SQL Developer to Design, develop, and optimize complex SQL queries, stored procedures, functions, and views to support business and reporting needs and partner closely with SSIS developers to support and troubleshoot ETL packages, data flows, and integration processes. They will also collaborate with Power BI developers to ensure data models and underlying SQL structures support efficient, accurate reporting and dashboarding. Required Candidate Location: Dallas or $100% Remote (Only US Citizens - As per clients visa restrictions) β€’ β€’ β€’ All submittals must Include: 1. Driver’s license or State ID 1. Link to the candidates LinkedIn account. 1. Below submittal Format β€’ β€’ β€’ Experience required on a resume and for submittal: 1. How many years working with: SQL Developer 1. How many years working with: SSIS 1. How many years working with: support and troubleshoot ETL packages, data flows, and integration processes 1. How many years working with: Optimizing complex T-SQL (SQL Server preferred) 1. How many years working with: Banking or Capital Markets or Financial services Preferred – MUST HAVE VERY LARGE, WELL KNOWN ENTERPRISE EXPERIENCE β€’ β€’ β€’ β€’ CANDIDATES MUST HAVE GOOD TENURE AND/OR LONG PROJECTS. Key Responsibilities β€’ Design, develop, and optimize complex SQL queries, stored procedures, functions, and views to support business and reporting needs β€’ Partner closely with SSIS developers to support and troubleshoot ETL packages, data flows, and integration processes β€’ Collaborate with Power BI developers to ensure data models and underlying SQL structures support efficient, accurate reporting and dashboarding β€’ Perform data profiling, validation, and quality checks across source and target systems β€’ Tune queries and indexes for performance across large, complex datasets β€’ Translate business requirements into technical specifications in partnership with stakeholders across the business and technology teams β€’ Document data flows, schema changes, and technical processes for ongoing maintainability β€’ Troubleshoot and resolve data discrepancies, performance issues, and pipeline failures Required Qualifications β€’ Strong hands-on experience writing and optimizing complex T-SQL (SQL Server preferred) β€’ Demonstrated experience working alongside SSIS developers on ETL/data integration processes β€’ Demonstrated experience working alongside Power BI developers, with an understanding of how data models feed reporting layers β€’ Strong communication skills, with the ability to clearly explain technical concepts to both technical and non-technical stakeholders β€’ Ability to work independently in a long-term consulting capacity, managing competing priorities across multiple stakeholders Preferred Qualifications β€’ Financial services experience (asset management, hedge fund, private credit, or related) is a strong plus β€’ Familiarity with data warehousing concepts and best practices β€’ Experience supporting front-, middle-, or back-office reporting functions within financial services