Data Systems Analyst: SQL & Data Integration Specialist

Doggett Equipment Services Group; Houston (TX); Hybrid; USD 85,000 - 115,000; Full time

Job summary

Doggett Equipment Services Group is seeking a Data System Analyst to support and optimize enterprise data systems in the Houston area. The role focuses on SQL development, data integration, and reporting to enable business operations.

You will collaborate with IT and business teams to implement ETL processes, ensure data quality, and provide end-user training. A strong foundation in SQL Server/DB2, exceptional communication, and the ability to manage multiple priorities are essential.

Qualifications

• Five or more years of experience supporting enterprise business systems.
• Five or more years of experience writing SQL scripts and queries.
• Experience with Microsoft SQL Server and/or IBM AS/400 (DB2).
• 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 queries.
• Support SQL Server and IBM AS/400 databases used by the company's applications.
• Design and maintain processes for importing, exporting, and validating large data volumes.
• Create and maintain ad hoc reports and data extracts.
• Develop and support integrations between internal systems and third-party apps.
• Automate recurring business processes using database tools and scripting.
• Troubleshoot data synchronization and integration issues.
• Coordinate software installations, upgrades, testing, and maintenance.
• Analyze business requirements and translate them into technical solutions.
• Investigate application issues and implement corrective actions.
• Collaborate with software vendors and internal departments to resolve issues.
• Participate in testing of new functionality and system upgrades.
• Create technical documentation, user guides, and implementation procedures.
• Provide technical support and training to end users.
• Maintain documentation for system configurations and business processes.
• Ensure compliance with company data security and change management policies.

Skills

SQL scripting

Analytical skills

Troubleshooting

Written and verbal communication

Multitasking

Education

Bachelor's degree in a related field

SQL Server / Microsoft certifications

Tools

SSIS

Informatica

ETL processes

REST APIs

XML/JSON

PowerBI

Job description

Doggett Equipment Services Group is seeking a Data System Analyst to support and optimize enterprise data systems in the Houston area. The role focuses on SQL development, data integration, and reporting to enable business operations.

You will collaborate with IT and business teams to implement ETL processes, ensure data quality, and provide end-user training. A strong foundation in SQL Server/DB2, exceptional communication, and the ability to manage multiple priorities are essential.