Microsoft ETL Developer

Search Services - Houston, TX

Full-time

Houston, TX

Administrative and Support Services

About the position

A dynamic and expanding software company headquartered in Houston is seeking a seasoned SQL Developer to join their team in a full-time, hybrid capacity. In this role, you will play a crucial part in the ongoing development, growth, and support of the product(s) footprints. Reporting to the VP of Development, you will be responsible for developing and maintaining scripts for exporting data from various payroll and HR software systems, transforming this data, and importing it into the product. Your expertise will be essential in optimizing and maintaining both existing and new SQL database queries and stored procedures. You will also be tasked with coding, testing, debugging, and implementing changes to data-driven applications and libraries that support complex systems. Analyzing, debugging, and resolving production issues related to application performance, system latency, and infrastructure and network products will be a key part of your responsibilities. The role requires a demonstrated ability to solve real-world problems using efficient and well-crafted algorithms, and you will engage in tasks beyond writing boilerplate code or user interfaces, showing a deep interest in complex system development. Additionally, you will provide development and production support alongside other team members, generate reports, and create interfaces for data conversion and reporting. Collaboration with managers to understand feature specifications and estimate project timelines will also be part of your duties, as well as developing conversion, interface, and reporting programs.

Responsibilities

• Develop and maintain scripts for exporting data from various payroll and HR software systems, transforming this data, and importing it into the product.
• Optimize and maintain both existing and new SQL database queries and stored procedures.
• Code, test, debug, and implement changes to data-driven applications and libraries, supporting complex systems.
• Analyze, debug, and resolve production issues related to application performance, system latency, and infrastructure and network products.
• Demonstrate the ability to solve real-world problems using efficient and well-crafted algorithms.
• Engage in tasks beyond writing boilerplate code or user interfaces, showing a deep interest in complex system development.
• Provide development and production support alongside other team members.
• Generate reports and create interfaces for data conversion and reporting.
• Collaborate with managers to understand feature specifications and estimate project timelines.
• Develop conversion, interface, and reporting programs.

Requirements

• High school diploma required; post-secondary education or equivalent experience required.
• Bachelor's degree in computer science, finance, or engineering is a plus.
• 3-5 years of experience with MSSQL Server in an enterprise environment.
• Proficiency in Microsoft SQL, including stored procedures and Transact-SQL.
• Extensive knowledge of SSIS, SSMS and SSRS.
• Understanding of complex query design and best practices to prevent performance issues and deadlocking.
• Experience in programming and troubleshooting query performance across multiple environments.
• Ability to design scalable complex systems.