Data Systems Analyst: SQL, ETL & Integrations

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

Job summary

Doggett Equipment Services Group is seeking a Data System Analyst to develop, maintain, and optimize SQL scripts and stored procedures for enterprise business systems in our Houston operations. You will support SQL Server and IBM AS/400 (DB2) databases, design data validation processes, and create ad hoc reports and data extracts to support business operations.

The role involves building integrations between internal systems and third‑party applications, automating recurring data tasks,

Qualifications

• Five or more years supporting enterprise business systems.
• Experience writing SQL scripts and queries.
• Experience with SQL Server and/or IBM AS/400 (DB2).
• Strong analytical and troubleshooting capabilities.
• Experience with large data imports, exports, and validations.
• Excellent written and verbal communication skills.

Responsibilities

• Develop, maintain, and optimize SQL scripts, stored procedures, and queries.
• Support SQL Server and IBM AS/400 databases used by business applications.
• Design and maintain processes for importing, exporting, and validating large datasets.
• Create and maintain ad hoc reports and data extracts.
• Develop and support integrations between internal systems and third‑party applications.
• Automate recurring business processes using database tools and scripting.
• Troubleshoot data synchronization and integration issues.
• Coordinate software installations, upgrades, testing, and maintenance.
• Translate business requirements into technical solutions.
• Investigate issues, identify root causes, and implement corrective actions.
• Collaborate with vendors and internal teams to resolve technical issues.
• Participate in testing of new functionality and system enhancements.
• Create technical documentation, user guides, and implementation procedures.
• Provide technical support and training to end users.
• Maintain documentation for system configurations and processes.
• Ensure compliance with security and change management procedures.

Skills

Analytical skills

Troubleshooting

Communication skills

Multitasking

Teamwork

Education

Bachelor's degree in Computer Science/IS/IT

Tools

SSIS

Informatica

ETL

REST APIs

XML/JSON

PowerBI

Tableau

SQL Server

DB2/AS400

Job description

Doggett Equipment Services Group is seeking a Data System Analyst to develop, maintain, and optimize SQL scripts and stored procedures for enterprise business systems in our Houston operations. You will support SQL Server and IBM AS/400 (DB2) databases, design data validation processes, and create ad hoc reports and data extracts to support business operations.

The role involves building integrations between internal systems and third‑party applications, automating recurring data tasks,