Why This Role Stands Out
This role offers a fantastic opportunity to leverage your advanced SQL and Python skills to build critical enterprise integrations, fostering significant career growth within a reputable company. If you excel at translating complex business logic into efficient code and enjoy impactful technical challenges, you'll thrive here and should definitely consider applying.
Quick Overview
Job Description
Role : Senior SQL Integrations Developer
Location: Plano, TX (Onsite)
Duration: Long-term Contract
Job Overview
Our client is seeking a hands-on Senior Developer with deep SQL expertise to join their Integration Team. This role designs, builds, and optimizes data transformations that power enterprise integrations and business applications — translating complex business rules into performant SQL logic across ERP, order management, warehouse, and e-commerce systems, and automating processes with Python.
Key Responsibilities
- Design and develop complex SQL transformations supporting enterprise integrations between core systems (ERP, order management, warehouse management, product data, and e-commerce platforms)
- Implement business logic in SQL — stored procedures, views, functions, and transformation layers
- Develop and maintain Python scripts for data movement, validation, automation, file processing, and API-based integrations
- Perform query and database performance tuning: analyze execution plans, optimize indexing, refactor inefficient queries
- Support ETL/ELT pipelines across on-prem (DB2/iSeries, SQL Server) and cloud (Azure) environments
- Partner with integration developers to define data mappings, transformation rules, and reconciliation logic
- Conduct data profiling, root-cause analysis, and data quality remediation for production issues
- Document data models, transformation logic, and technical designs
- Collaborate with business analysts, QA, and cross-functional IT teams in onsite/offshore model
Required Skills
- 7+ years of hands-on SQL development: complex joins, window functions, CTEs, stored procedures, set-based transformation logic
- 2+ years of Python scripting (pandas, pyodbc/SQLAlchemy, REST API consumption)
- Expertise in performance tuning: execution plans, index design, statistics management, query refactoring on large datasets
- Experience with at least one enterprise RDBMS at scale (SQL Server, DB2, Oracle, or PostgreSQL)
- Strong data analysis and problem-solving skills across multiple systems
Similar jobs
- UT
AWS QuickSight Developer - 100% onsite role and in person interview in MD - Locals preferred
NewUnisoft Technology Inc
Silver Spring, MD🇺🇸On-site23 hours agoSQLAWSETL+1Technology - VS
Sr. Python Full Stack
NewVision Square
Charlotte, NC🇺🇸On-site23 hours agoDjangoDockerFastAPI+26 - MT
Power Platform Developer
NewMavensoft Technologies, LLC
Atlanta, GA🇺🇸On-site23 hours agoSQLSQL ServerAzure+4Technology - RI
Senior Java Developer
NewRaas Infotek LLC
Virginia Beach, VA🇺🇸Hybrid23 hours agoMicroservicesSQLSpring+5Technology - TS
Java Fullstack Developer
NewTechSpace Solutions Inc.
Herndon, VA🇺🇸Hybrid23 hours agoMicroservicesAngularJava+1Technology - CS
W2 -Role-Applied AI Engineer GenAI / Full Stack-Hybrid @ NYC-Need Locals Only
NewCyber Sphere LLC
New York, NY🇺🇸On-site23 hours agoAngularJavaLLM+2Technology