Data Analyst I - GIS & Utilities [AQ-21945]

Aquent; Houston (TX); In loco; USD 65.000 - 85.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health, vision, and dental benefits

Retirement plan with company match

Free online training via Aquent Gym

Descrizione del lavoro

Aquent is seeking a detail-oriented data professional for onsite work in Houston, TX. You will leverage GIS tools and SQL to support utility data initiatives and maintain robust ETL processes that ensure data accuracy.

Responsibilities include designing databases, validating data, and collaborating with cross-functional teams to enable data-driven decisions that improve operations in the energy sector.

Competenze

• Bachelor's degree in a technical field such as Computer Science or Computer Engineering.
• 0-2 years of applicable experience in data analysis or database management.
• Experience with GIS tools for utility/spatial mapping and SQL querying.

Mansioni

• Collaborate with stakeholders to define data requirements and data strategies.
• Develop and maintain large-scale ETL processes for enterprise data.
• Design and modify databases, guiding implementation tasks for team members.
• Test programs and databases, identify issues, and implement fixes for accuracy.
• Ensure data integrity and support data-driven decision making.

Conoscenze

GIS proficiency

SQL

ETL processes

Scripting

Data QA/QC

Formazione

Bachelor’s degree in Computer Science / Computer Engineering or related

Strumenti

SAP

MS Excel

MS Access

GPS systems

Descrizione del lavoro

• Work Authorization: W2 / Independent Candidates Only — NO C2C / C2H sub-contracting. Candidates must be fully authorized to work in the USA.
• Location: Onsite requirement in Houston, TX. Local candidates only – no relocation.
• GIS & SQL Proficiency: Strong experience using GIS tools for utility/spatial mapping alongside SQL for querying and database maintenance.
• Data Integrity & QA/QC: Experience with data validation, error tracking, and executing/automating ETL processes.
• Industry Experience: Background supporting natural gas distribution, DIMP, or enterprise utility databases (e.g., CenterPoint Energy systems) highly preferred.
  

• Work Authorization: W2 / Independent Candidates Only — NO C2C / C2H sub-contracting. Candidates must be fully authorized to work in the USA.
• Location: Onsite requirement in Houston, TX. Local candidates only – no relocation.
• GIS & SQL Proficiency: Strong experience using GIS tools for utility/spatial mapping alongside SQL for querying and database maintenance.
• Data Integrity & QA/QC: Experience with data validation, error tracking, and executing/automating ETL processes.
• Industry Experience: Background supporting natural gas distribution, DIMP, or enterprise utility databases (e.g., CenterPoint Energy systems) highly preferred.
  

Aquent is proud to partner with a leading organization dedicated to delivering essential services and innovating within the energy sector. This company is at the forefront of leveraging data to drive efficiency and enhance operations, making a tangible impact on communities and the future of energy. Join a team where your contributions directly influence strategic decisions and operational excellence, shaping how critical resources are managed and delivered.

Are you passionate about unlocking insights from data and eager to make a significant impact from day one? We are seeking a driven and detail-oriented individual to join our client's dynamic team. In this role, you will be instrumental in ensuring the integrity and effectiveness of crucial data systems, directly contributing to the strategic evolution of their data infrastructure. Your work will empower teams with reliable information, enabling smarter, data-driven decisions that propel the organization forward.

What You’ll Do

• 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.

What You’ll Bring

Required 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.

Required Skills

• Proven experience with various database technologies.
• Solid understanding of the ETL (Extract, Transform, Load) process.
• Proficiency in at least one scripting language.
• Exceptional written and oral communication skills, capable of conveying complex information clearly.
• Strong troubleshooting and problem-solving abilities, with a knack for identifying and resolving data-related challenges.
• 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.

Bonus Points

• Experience with SAP.
• Proficiency in MS Excel.
• Skills in Technical Writing.
• Knowledge of GPS & GIS systems.
• Familiarity with MS Access.
• Proficiency in SQL.

About Aquent Talent

Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands.

Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits!

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.