SQL Developer

Insight Global
Roanoke, United States of America
9 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 119K

Job location

Roanoke, United States of America

Tech stack

Query Performance
API
Big Data
Google BigQuery
Computer Programming
Data Validation
Information Engineering
Data Integration
ETL
Data Transformation
Database Queries
Github
Microsoft SQL Server
Performance Tuning
Systems Development Life Cycle
Software Engineering
SQL Stored Procedures
SQL Databases
SQL Server Agent
T-SQL
Indexer
Deployment Automation
Software Version Control
Data Pipelines

Job description

Building and optimizing SQL Server stored procedures, views, and complex queries. Designing and developing ETL processes using non-Informatica approaches, whether that's custom frameworks, scripting, or other enterprise-approved tooling. You'll implement data transformation and processing logic for high-volume datasets, integrate data from multiple sources like files, APIs, and upstream systems, and handle data validation, reconciliation, and performance tuning. You'll also support testing, deployment, and production validation of data pipelines, working alongside engineering and business teams to turn requirements into scalable solutions.

Requirements

3+ years in software development or data engineering, with strong hands-on experience in Microsoft SQL Server and T-SQL, stored procedure development and optimization, SQL Server Agent job development, and non-Informatica ETL development. You should be comfortable with data transformation and aggregation logic, query performance tuning and indexing, and large-scale data processing workloads. Familiarity with version control (GitHub), standard SDLC practices, and BigQuery query development. Programming experience for ETL processing, experience integrating data from multiple source systems, CI/CD pipelines and automated deployments, and an understanding of the financial services industry are big plusses.

Apply for this position