Data Analyst I
Aquent
Houston, TX0–2 yrs2d agovia LinkedIn
About the Role
This role is for a Data Analyst I – GIS & Utilities. The position is onsite in Houston, TX, and is for local candidates only.
Key Responsibilities
- Collaborate with senior management, technical, and client teams to define data requirements, implement business data strategies, and establish best practices for advanced data manipulation, storage, and analysis.
- Develop and code logical and physical database descriptions, guiding the specification of database identifiers within management systems or directing others in their implementation.
- Design, implement, automate, and maintain robust large-scale enterprise data ETL (Extract, Transform, Load) processes.
- Modify existing databases and database management systems, or direct programmers and analysts in making necessary changes.
- Conduct thorough testing of programs and databases, correcting errors and implementing essential modifications to ensure optimal performance and accuracy.
Requirements & Tech Stack
- GIS tools for utility/spatial mapping.
- SQL for querying and database maintenance.
- Experience with data validation, error tracking, and executing/automating ETL processes.
- Proficiency in at least one scripting language.
- Proven experience with various database technologies.
- Solid understanding of the ETL (Extract, Transform, Load) process.
- Exceptional written and oral communication skills.
- Strong troubleshooting and problem-solving abilities.
- A demonstrated history of success in previous roles or projects.
- A genuine desire to work with data and contribute to business success through data-driven decision-making.
Qualifications
- A Bachelor’s degree in a technical field such as Computer Science, Computer Engineering, or a closely related discipline.
- 0-2 years of applicable experience in data analysis or database management.
Industry & Bonus Experience
- Background supporting natural gas distribution, DIMP, or enterprise utility databases (e.g., CenterPoint Energy systems) highly preferred.
- Experience with SAP.
- Proficiency in MS Excel.
- Skills in Technical Writing.
- Knowledge of GPS & GIS systems.
- Familiarity with MS Access.
- Proficiency in SQL.
Work Authorization: W2 / Independent Candidates Only. Candidates must be fully authorized to work in the USA.