Data Analyst I

About the Role

This role is a pivotal position focused on ensuring the integrity and effectiveness of crucial data systems within a leading organization in the energy sector. The position contributes to the strategic evolution of their data infrastructure, empowering teams with reliable information for data-driven decisions.

Key Responsibilities

• Collaborate with senior management and technical 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

• Bachelor’s degree in a technical field such as Computer Science, Computer Engineering, or a closely related discipline.
• Proven experience with various database technologies.
• Solid understanding of the ETL (Extract, Transform, Load) process.
• Proficiency in at least one scripting language.
• Strong experience using GIS tools for utility/spatial mapping.
• Proficiency in SQL for querying and database maintenance.
• Experience with data validation, error tracking, and executing/automating ETL processes.
• 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.

Nice-to-Have Qualifications

• Experience with SAP.
• Proficiency in MS Excel.
• Skills in Technical Writing.
• Knowledge of GPS systems.
• Familiarity with MS Access.
• Background supporting natural gas distribution, DIMP, or enterprise utility databases.