Data Analyst I - GIS & Utilities

Aquent is proud to partner with a leading organization at the forefront of the energy sector, dedicated to delivering essential services and driving innovation. This company is committed to leveraging data to enhance efficiency and optimize operations, creating a tangible impact on communities and shaping the future of energy management. Join a team where your expertise directly influences strategic decisions and operational excellence, playing a crucial role in how vital resources are managed and delivered.

Are you ready to dive deep into data and make a profound impact from day one? We are seeking a highly motivated and detail-oriented individual to join our client's dynamic team. In this pivotal role, you will be instrumental in safeguarding the integrity and maximizing the effectiveness of critical data systems, directly contributing to the strategic evolution of the organization's data infrastructure. Your work will empower teams with reliable, actionable insights, fostering smarter, data-driven decisions that propel the organization forward and underpin the essential services it provides to millions.

What You'll Do

• Collaborate closely with senior management and technical teams to define precise data requirements, execute business data strategies, and establish leading best practices for advanced data manipulation, storage, and comprehensive analysis.
• Design and develop logical and physical database descriptions, providing expert guidance on the specification of database identifiers within management systems or overseeing their implementation by others.
• Engineer, implement, automate, and diligently maintain robust, large-scale enterprise data ETL (Extract, Transform, Load) processes to ensure seamless data flow and accessibility.
• Proactively modify existing databases and database management systems, or direct specialized programmers and analysts in performing necessary updates and enhancements.
• Execute rigorous testing of programs and databases, meticulously correcting errors and implementing essential modifications to guarantee optimal performance, accuracy, and reliability.

What You'll Bring

Must-Have Qualifications:

• Bachelor's degree in a technical discipline such as Computer Science, Computer Engineering, or a closely related field.
• 0-2 years of relevant professional experience in data analysis or database management.
• Demonstrated experience across various database technologies.
• A solid and practical understanding of the ETL (Extract, Transform, Load) process.
• Proficiency in at least one scripting language (e.g., Python, PowerShell).
• Exceptional written and oral communication skills, with the ability to convey complex technical information clearly and concisely to diverse audiences.
• Strong troubleshooting and problem-solving capabilities, with a keen ability to identify and resolve complex data-related challenges.
• A proven track record of success in previous roles or projects, highlighting initiative and achievement.
• A genuine passion for working with data and a strong desire to contribute directly to business success through data-driven insights.
• Extensive experience utilizing GIS tools specifically for utility and spatial mapping applications.
• Proficiency in SQL for advanced querying, data manipulation, and database maintenance.
• Practical experience with data validation techniques, error tracking, and the execution/automation of ETL processes.

Nice-to-Have Qualifications:

• Experience with SAP.
• Proficiency in MS Excel for data analysis and reporting.
• Skills in Technical Writing for documentation and process creation.
• Knowledge of GPS systems and their applications.
• Familiarity with MS Access.
• Background supporting natural gas distribution, Distribution Integrity Management Program (DIMP), or enterprise utility databases.