Programmer/Analyst - SQL & ETL - SSIS

Logix Guru
Dallas, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Dallas, United States of America

Tech stack

Amazon Web Services (AWS)
Azure
C Sharp (Programming Language)
Information Systems
Databases
Data Integration
ETL
Relational Databases
Database Schema
Github
Groovy
Python
Microsoft SQL Server
Visual Basic
Performance Tuning
Query Optimization
Standard Sql
Software Engineering
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
T-SQL
Scripting (Bash/Python/Go/Ruby)
Freeform SQL
Information Technology
Software Version Control
ServiceNow
Control M

Job description

This role involves designing, developing, and maintaining complex SQL queries, stored procedures, and database objects, as well as building and optimizing ETL workflows using SSIS to support data integration and transformation., * Design, develop, and maintain complex SQL queries, stored procedures, and database objects

  • Build and optimize ETL workflows using SSIS to support data integration and transformation
  • Monitor and support production jobs, troubleshoot issues, and ensure timely resolution
  • Collaborate with business and technical teams to gather requirements and deliver solutions
  • Perform root cause analysis and implement preventive measures for recurring issues
  • Participate in performance tuning and optimization of database systems
  • Document technical processes and maintain system knowledge base

Requirements

We are seeking a seasoned Programmer/Analyst with strong SQL and ETL development expertise to join our team. The ideal candidate will have at least 5 years of experience in application development and support, with a focus on MS SQL Server and SSIS-based ETL processes. This role also requires hands-on experience in production support, ensuring the reliability and performance of critical financial applications., * 5+ years of experience in application development and support

  • Proficiency in MS SQL Server, including T-SQL, performance tuning, and query optimization
  • 3+ years of hands-on experience with ETL development using SSIS
  • 2+ years experience with C#
  • 1+ year experience in VB.net
  • 1+ year of Python
  • Batch and Groovy Scripting
  • Knowledge of AWS
  • Strong understanding of relational database design and data modeling
  • Experience in production support, including incident management and job monitoring
  • Excellent problem-solving and communication skills
  • Bachelor's degree in Computer Science, Information Systems, or related field or equivalent professional experience., * Experience with scheduling tools (e.g., Zena, Control-M, or similar)
  • Familiarity with version control systems like GitHub
  • Exposure to cloud platforms (e.g., AWS or Azure)
  • Knowledge of ServiceNow or similar ITSM tools

Benefits & conditions

Pay range and compensation package

Apply for this position