Data Analyst

Data Analyst

Description

JOB DUTIES & RESPONSIBILITIES

The Data Analyst will develop an understanding of current data state, workflows and processes and develop solutions for integrations, transformations and deliverables. This will include data analysis, data mining, technical support and database maintenance to meet internal and external customers' requirements. This role requires demonstrated ability to solve complex problems and recommend the best track for data development and processing. Project work will involve process improvement, quality control, data creation from spatial and tabular sources, conversion, migration and maintenance.

Representative Duties and Responsibilities:

• Technical project tasks, including database design, advanced GIS analysis and modeling
• Performs data mining activities to meet customer requirements/specifications
• Provides specialized queries, maps and reports to meet customer requirements/specifications
• Performs application testing and documentation of defects
• Interfaces with users; documents requested/needed changes
• Interfaces with Information Services (IS) GIS Support group to drive development and data model changes
• Performs weekly analysis on mission critical GIS data to audit and sustain data integrity
• Develop methods and perform quality assurance/quality control on GIS and non-spatial data to meet quality goals
• Serves as Subject Matter Expert on GIS projects and solution definition workshops
• Identifies training requirements; creates and maintains training and procedural documentation
• Identifies new GIS technologies/processes/applications to improve inter-/intra- departmental functions
• Creates and maintains existing automated processes using Model Builder/Python scripting or other tools
• Processes, prepares and converts data to enter into GIS from a variety of data formats
• Analyzes current business processes and recommends best practice solutions

Education and Experience:

Required:

• Bachelor's degree in geography (GIS), engineering, computer science, or related field and 3 - 5 years of experience with industry-standard GIS and verifiable Data Mining and Python scripting experience (2 year demonstrable required). GIS certificate and 2 years of related work experience in lieu of a degree in related discipline

Or

• Equivalent academic education and experience

Preferred:

• Master's degree in geography (GIS), geosciences, engineering, computer science, or related field

Related Work Experience:

Required:

• Experience with Esri geodatabase design, structure and management - including the manipulation of tabular data in GIS, and joining/linking related data
• Intermediate knowledge of SQL and relational databases
• Thorough understanding of Esri ArcGIS Enterprise, ArcSDE, versioning, and geoprocessing
• Experience incorporating nonspatial Enterprise databases with GIS to fulfill ad hoc analysis requests
• Knowledge of batch files and Python scripts to assist in repetitive daily activities
• Ability to quickly learn new skills and abilities database technologies, data modeling, and scripting as needed
• Development and maintenance of existing Python scripts, FME workbenches and Esri's ModelBuilder models

Preferred:

• General knowledge of natural gas distribution facilities, Company policies, procedures and gas operation methods and standards
• Knowledge of GAS datasets and disparate databases
• Knowledge of publishing with ArcGIS Server, ArcGIS Pro, ArcGIS Online and Portal for ArcGIS, including data versioning, multiuser and replication
• Experience with Natural Gas Utility
• Experience using Esri Data Reviewer and Workflow Manager Extensions
• Experience converting data between CAD and GIS
• Strong understanding of content and document management applications

Applicant may possess a combination of equivalent education and work experience.

Specific Skills & Knowledge:

Required:

• Esri ArcGIS 10.6x - advanced proficiency
• MS Office suite (Access, Excel, Word, PowerPoint, Visio) - advanced proficiency
• Esri ArcGIS Enterprise - intermediate proficiency
• Geometric Network - intermediate proficiency
• Model Builder - intermediate proficiency
• Python - intermediate proficiency
• SQL RDBMS - intermediate proficiency
• AutoCAD/CADD - basic proficiency
• Visual Basic/VBA - basic proficiency
• SharePoint - basic proficiency
• Excellent verbal and written communication skills
• Excellent geoprocessing and spatial analysis skills
• Strong requirements review, analytical, and problem solving skills
• Application testing script development and performance of testing
• Ability to quickly learn new skills and abilities, database technologies, data modeling, and scripting as needed
• Strong analytical, root cause analysis, and problem-solving skills with ability to elicit and efficiently document business rules and research technical issues
• Experience working in a fast paced, highly collaborative environment with cross-disciplinary teams (Analysts, Developers, Architects and Data Scientists) and business groups (technical and non-technical)
• Ability to quickly learn and apply new technologies
• Ability to function independently and as a team member
• Ability to handle multiple assignments and changing priorities
• Ability to work effectively with limited direct supervision

Preferred:

• PowerBI or Tableau visual tools
• Experience using Azure or other cloud-hosted solutions
• Experience with ETL (extract, transform, load) tools
• Schneider Electric ArcFM
• Current GIS industry trends (remote sensing, GPS technology, etc.) - intermediate understanding
• FME, Data Interoperability- intermediate proficiency
• Utility Pipeline Data Model (UPDM) - intermediate proficiency
• Utility Network (UN) - intermediate proficiency

Working Conditions/Physical Requirements:

Travel - 5-10%

Keyboarding - 50%

Disclaimer: This information describes the general nature and level of work performed by employees in this job. The description is not designed to be a comprehensive inventory of duties, responsibilities and qualifications required of employees in the job. Reasonable accommodation may be made to qualified disabled individuals for performance of essential duties and responsibilities.

Southern Company Gas provides for the energy needs of millions of U.S. households and businesses. As the largest natural gas-only distribution company in the United States, with more than 150 years of history behind us, we're working to ensure that Americans have access to an abundant, safely delivered supply of natural gas for decades to come. We offer our customers a wide range of energy services under one umbrella: seven regulated utilities as well as non-regulated businesses that offer retail, wholesale and storage services.

Southern Company (NYSE: SO) is a leading energy company serving 9 million customers through its subsidiaries as of Jan. 1, 2019. The company provides clean, safe, reliable and affordable energy through electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company serving wholesale customers across America, a leading distributed energy infrastructure company, a fiber optics network and telecommunications services . Southern Company brands are known for excellent customer service, high reliability and affordable prices below the national average. For more than a century, we have been building the future of energy and developing the full portfolio of energy resources, including carbon-free nuclear, advanced carbon capture technologies, natural gas, renewables, energy efficiency and storage technology. Through an industry-leading commitment to innovation and a low-carbon future, Southern Company and its subsidiaries develop the customized energy solutions our customers and communities require to drive growth and prosperity. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and govern our business to the benefit of our world. Our corporate culture and hiring practices have been recognized nationally by the U.S. Department of Defense, G.I. Jobs magazine, DiversityInc, Black Enterprise, Forbes and the Women's Choice Award. To learn more, visit www.southerncompany.com.

Southern Company is an equal opportunity employer where an applicant's qualifications are considered without regard to race, color, religion, sex, national origin, age, disability, veteran status, genetic information, sexual orientation, gender identity or expression, or any other basis prohibited by law.

Job Field: Finance

Job Type: Standard

Primary Location: Georgia-Metro Atlanta-Atlanta

Operating Company: Southern Company Gas

Job Type: Standard

Travel (Up to): Yes, 25 % of the Time

Work Location(s):

AGLR Corporate Office - 10 Peachtree Place NE (10AtlantaCODE)

10 Peachtree Place NE

Atlanta, 30309

Req ID: ASC2000031