Data Systems Analyst: SQL, ETL & System Integrations

Doggett Equipment Services Group; Houston (TX); On-site; USD 85,000 - 120,000; Full time

Job summary

Doggett Equipment Services Group is seeking a Data System Analyst to support and optimize enterprise business systems in a fast-paced environment in Houston. You will develop and maintain SQL scripts, ETL processes, and data validation procedures to ensure data integrity across our applications.

The role requires strong SQL Server/DB2 experience, troubleshooting skills, and the ability to translate business requirements into technical solutions.

Qualifications

• Five+ years of experience supporting enterprise business systems.
• Five+ years of experience writing SQL scripts and queries.
• Experience with Microsoft SQL Server and/or IBM AS/400 (DB2) databases.
• Strong analytical and troubleshooting skills.
• Experience importing, exporting, and validating large datasets.
• Excellent written and verbal communication skills.
• Ability to manage multiple priorities independently and in a team.

Responsibilities

• Develop, maintain, and optimize SQL scripts, stored procedures, and database queries.
• Support SQL Server and IBM AS/400 databases used by the company's business applications.
• Design and maintain processes for importing, exporting, and validating large volumes of business data.
• Create and maintain ad hoc reports and data extracts to support business operations.
• Develop and support integrations between internal systems and third-party applications.
• Automate recurring business processes using database tools, scripting, and integration technologies.
• Troubleshoot data synchronization and integration issues.
• Coordinate software installations, upgrades, testing, and ongoing system maintenance.
• Analyze business requirements and translate them into technical solutions.
• Investigate application issues, identify root causes, and implement corrective actions.
• Collaborate with software vendors and internal departments to resolve technical issues.
• Participate in testing of new functionality, upgrades, and system enhancements.
• Create technical documentation, user guides, and implementation procedures.
• Provide technical support and training to end users as needed.
• Maintain documentation for system configurations and business processes.
• Ensure business systems comply with company policies for protecting employee and customer information.
• Follow established security and change management procedures.

Skills

SQL scripting

Analytical skills

Written and verbal communication

Independent and team work

Education

Bachelor's degree in Computer Information Systems/CS/IT

Tools

SSIS

Informatica

ETL

REST APIs

XML/JSON

PowerBI/Tableau

Microsoft SQL Server

Excel

Job description

Doggett Equipment Services Group is seeking a Data System Analyst to support and optimize enterprise business systems in a fast-paced environment in Houston. You will develop and maintain SQL scripts, ETL processes, and data validation procedures to ensure data integrity across our applications.

The role requires strong SQL Server/DB2 experience, troubleshooting skills, and the ability to translate business requirements into technical solutions.