Southern Company EEP IT Business Analyst II in Naperville, Illinois
EEP IT Business Analyst II
This position is responsible for the configuration, implementation, and maintenance of business applications and will engage with internal/external stakeholders to meet the technical needs of the Energy Efficiency Department. The position will act as the Subject Matter Expert (SME) for various technical processes/systems and business requirements.
BS in Computer Science, Finance, Accounting, or equivalent work experience.
MBA or Master’s Degree
Technical Skills: Data analysis, Access (Intermediate proficiency), Excel (intermediate proficiency), Visio, MS SQL Server and SSRS/SSIS
Interpersonal Skills: Critical thinking, problem solving, analytical, and written and verbal communication.
Position Related Experience: 3-4 years of job-related experience.
OR any combination of education and work experience which permits the candidate to meet position work requirements.
MAJOR JOB RESPONSIBILITIES:
Identify and develop process improvements and methods to evaluate and validate results.
Develop and implement resolutions aimed at data quality enhancements.
Exhibits strong written and verbal communication skills.
Evaluate and identify process improvements
Possesses strong quantitative analysis skills.
Ensure tasks and deliverables are completed on time to minimize business impacts.
Coordinate with internal and external stakeholders to ensure data accuracy and quality
Consistently engages with Energy Efficiency Department to strengthen communication and support business needs.
Oversee the elements of vendor management for the Energy Efficiency IT department and serve as the central point person between various operational functions and cross-functional teams to carry out various activities including, but not limited to: reconciliation/auditing, feedback, system configuration,
Team oriented with excellent interpersonal skills and the ability to collaborate effectively with coworkers and management team
Salesforce administration including but not limited to setting up/deactivating users; adding/modifying new fields/objects/page layouts/etc.
Manage the Energy Efficiency’s Salesforce platform and perform hands-on technical implementations and deliver functional solutions
Manage Salesforce page layouts, security permissions, and code development/deployment (Apex and VisualForce)
Manage the SharePoint administration, including but not limited to, setting up/deactivating users; granting permissions; creation of new subsites/document libraries as requested
Design and implementing solutions related to all aspects of data analytics, including mining, generation, and data visualization.
Develop/test/deploy updates as needed in multiple development and production environments
Utilize Microsoft Management Studio and SQL Server to develop complex SQL’s to query the energyENGINE database
Implement Business Intelligence solutions (e.g. Power BI, Tableau) to develop innovative methods to visualize data
Develop and run complex queries for ad hoc business data requests.
Develop solutions to complex analytical/data-driven problems.
Support system enhancements and new technology solution projects on behalf of the business.
Manage and configure the STARS 1099 Database, IBM Watson/Silverpop, and SmartSheet systems/platforms
Utilize SQL programming and report-writing development life cycle to include planning, design, documentation, programming and testing experience.
Develop and implement recommendations for future enhancements
Conduct quarterly security and audit reviews
Participate in system implementations to support the overall EEP department
Operate as a self-starter, be able to work independently, and proactively seek innovative approaches.
Create visual reports (e.g. tables, charts, graphs) for department KPI’s and other metrics.
Lead IT department special projects as assigned
Employee receives clear instructions from supervisor regarding what to do and how to do it.
Tasks follow set guidelines or procedures.
Employee must consider alternative courses of action and then make a decision after considering the options.
Employee has the authority to make significant choices and decisions, without specific guidance or direction from the supervisor.
Explanation: This position will manage all Salesforce update requests and determine the appropriate action for development and implementation. There is significant independent data analysis and validation when developing complex queries for ad hoc business requests. The position requires daily interaction with internal and external partners that varies from day-to-day. Due to the interaction with data files, they will determine the best course of action to assure data validation and error resolution.
Tasks are straight-forward, routine, and often repetitive.
Tasks are varied and fairly complex.
Assignments are quite varied and highly complex.
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: Administrative & Clerical
Job Type: Standard
Primary Location: Illinois-Metro Chicago-Naperville
Operating Company: Southern Company Gas
Job Type: Standard
Travel (Up to...): No
G O Naperville - 1844 W Ferry Rd. (1844NapervilleCODE)
1844 W Ferry Rd.
Req ID: GAS2002346