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.
This position will primarily focus on analytic activities within the Finance domain, including application development and data lifecycle management, production support for vendor-managed and custom solutions, and solution delivery of new enhancements and bug fixes. Responsibilities include data modeling, ensuring data security, quality, and compliance, understanding data warehouse concepts, and continuous performance optimization. The role also involves integrating Artificial Intelligence (AI) to enhance data analytics capabilities and automate processes.
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.
- Proficiency in SQL for querying and manipulating data in relational databases and/or star schemas; experience with database management systems such as Oracle and SQL Server.
- Familiarity with data warehouse concepts and ETL design best practices.
- Experience with tuning 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
- 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.
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.
Behavioral Attributes
- Takes personal ownership of career development.
- Demonstrates values such as Safety First, Intentional Inclusion, Integrity, and Superior Performance.
- Continuous learner with a high level of interest in learning and applying new technologies and concepts.
- Result-oriented, able to act with speed and decisiveness; takes initiative to meet commitments.
- Focus on quality, reliability, and efficiency.
- Effective in organizing tasks, managing multiple priorities, 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.
Company Overview
Southern Company (NYSE: SO) is a leading energy provider serving 9 million residential and commercial customers across the Southeast and beyond. We are committed to providing clean, safe, reliable, and affordable energy with excellent service.
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
#J-18808-Ljbffr