Application Developer I

Southern Company - Naperville, IL

Full-time - Entry Level

Naperville, IL

5,001-10,000 employees

Utilities

About the position

The Application Developer I position within the Analytics Platform Team at Southern Company focuses on developing and maintaining analytics platforms specifically for the Finance domain. This role involves all aspects of application development, data lifecycle management, production support, and the integration of Artificial Intelligence (AI) to enhance data analytics capabilities. The developer will work on ETL processes, data modeling, and ensuring data security and compliance, while continuously learning and implementing AI-driven solutions.

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.

Requirements

• 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.

Nice-to-haves

• Experience with Microsoft Azure (Fabric, Databricks) is a plus.
• Domain knowledge in Oracle Cloud Financials (Payables, Expenses, Receivables, General Ledger) and Oracle Projects (PPM) is highly desirable.

Benefits

• Health insurance coverage
• 401k retirement savings plan
• Paid holidays
• Flexible scheduling
• Professional development opportunities