JOB TITLE: Application Developer I
LEVEL: 4
JOB SUMMARY:
The Analytics Platform Team plays a pivotal role in the Technology Organization by developing and maintaining robust analytics platforms to empower decision-makers with timely and accurate information, enabling them to make informed decisions.
This position will primarily be focused on analytic activities within the Finance domain which include all aspects of application development and data lifecycle, production support for vendor-managed and custom solutions, and solution delivery of new enhancements and bug fixes. It also includes data modeling, ensuring data security, quality, and compliance, understanding of data warehouse concepts, and continuous performance optimization. Additionally, the role involves integrating Artificial Intelligence (AI) to enhance data analytics capabilities, automate processes, and provide advanced insights. The developer will be responsible for continuously learning and implementing AI-driven solutions, leveraging machine learning models.
Education and Experience
Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
1 to 3 years of experience in ETL development and data warehousing.
Knowledge of database concepts such as views, tables, star schemas, data normalization and indexing; with practical experience.
Proficiency in SQL for querying and manipulating data in relational databases and/or star schemas; database management systems such as Oracle, SQL Server.
Familiarity with data warehouse concepts.
Knowledge of ETL design best practices.
Experience with tuning of complex ODI scenarios and SQL queries for optimal performance.
Experience with Microsoft Azure (Fabric, Databricks) is a plus.
Key Responsibilities
Develop, test, and maintain ETL processes to support data warehousing and analytics solutions.
Ensure data is accurately extracted, transformed, and loaded into the data warehouse.
Provide production support for data warehouse processes and resolve issues promptly.
Ensure data security, quality, and compliance with industry standards.
Optimize ETL processes for performance and scalability.
Integrate AI to enhance data analytics capabilities and automate processes.
Develop and implement AI-driven solutions.
Collaborate with stakeholders to optimize analytics outcomes.
Provide time/effort estimates and contribute to project planning.
Knowledge, Skills & Abilities
Technical Skills
1 to 3 years of experience in ETL development, data warehousing and data lifecycle management.
Competence in utilizing ETL tools such as Informatica, Oracle Data Integrator (ODI) 12c, and Oracle Cloud Infrastructure Data Integration (OCI DI).
Experience with Business Intelligence Cloud Connector (BICC).
Basic understanding of Artificial Intelligence (AI) and Machine Learning (ML) concepts and tools.
Data Management
Understanding of data lifecycle concepts, including data collection, processing, and visualization.
Knowledge of data modeling techniques and data warehouse concepts.
Understanding of data security and compliance principles.
Domain knowledge in Oracle Cloud Financials (Payables, Expenses, Receivables, General Ledger) and Oracle Projects (PPM) is highly desirable. This includes the ability to work with respective Oracle Cloud Financials SMEs and analyze data from these modules to effectively design, develop, and maintain analytic solutions that meet the specific needs of our Finance stakeholders.
Communication and Collaboration
Strong communication and interpersonal skills.
Effective collaboration within a team.
Ability to build and effectively manage relationships.
Collaborate with stakeholders to gather requirements and translate them into clear and concise technical requirements.
Problem Solving and adaptability
Strong analytical and problem-solving skills.
Ability to interpret and analyze data to generate insights.
Skills in assessing and improving data quality through profiling, cleansing, and validation.
Self-motivation to work effectively with limited direct supervision.
Adaptability to ambiguous or changing requirements.
Ability to manage production support and project related activities simultaneously.
Soft Skills
Strong communication skills to collaborate with team members and stakeholders.
Attention to detail and a commitment to quality and accuracy.
Ability to manage time effectively and handle multiple tasks simultaneously.
Aptitude and willingness to learn new technologies.
Ability to evaluate situations, processes, and data critically to make informed decisions.
Knowledge of the different phases in the Software Development Life Cycle (SDLC), including requirements analysis, design, implementation, testing, deployment, and maintenance.
Ability to execute tasks provided by management or senior team members.
Project Support
Understanding of project management principles.
Ability to provide time/effort estimates for tasks.
Willingness to learn and contribute to project planning and execution.
Artificial Intelligence
Foundational understanding of AI and Machine Learning.
Willingness to learn about AI-driven solutions and their implementation.
Behavioral Attributes
Takes personal ownership of career development.
Demonstrates - Our Values - - Safety First, Intentional Inclusion (We are One Team), Act with Integrity, Superior Performance.
Continuous learner with a high level of interest in learning and applying new technologies and concepts.
Result Oriented, can act with speed and decisiveness; take initiative and does what it takes to meet commitments.
Focus on quality, reliability, and efficiency.
Effective in organizing tasks, managing multiple priorities, meeting schedules, and delivering on commitments.
Methodical approach to solving problems.
Other
Candidate must be available weekends and after normal business hours for on-call support. Some travel may be required within the Southern Company footprint.
Southern Company (NYSE: SO) is a leading energy provider serving 9 million residential and commercial customers across the Southeast and beyond through its family of companies. Providing clean, safe, reliable and affordable energy with excellent service is our mission. The company has electric operating companies in three states, natural gas distribution companies in four states, a competitive generation company, a leading distributed energy infrastructure company with national capabilities, a fiber optics network, and telecommunications services. Through an industry-leading commitment to innovation, resilience, and sustainability, we are taking action to meet our customers' and communities' needs while advancing our commitment to net zero emissions by 2050. Our uncompromising values ensure we put the needs of those we serve at the center of everything we do and are the key to our sustained success. We are transforming energy into economic, environmental and social progress for tomorrow. Our corporate culture and hiring practices have earned the company national awards and recognition from numerous organizations, including Forbes, Military Times, DiversityInc, Black Enterprise, J.D. Power, Fortune, Human Rights Campaign and more. 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 Identification: 7937
Job Category: Information Technology
Job Schedule: Full time
Company: Southern Company Services
