Application Developer II

Southern Company - Naperville, IL

Full-time - Mid Level

Naperville, IL

5,001-10,000 employees

Utilities

About the position

The Application Developer II position within the Analytic Platforms Team is crucial for developing and maintaining analytics platforms that support decision-making in the Human Capital Management (HCM) domain. The role involves application development, data lifecycle management, production support, and the integration of AI technologies to enhance data analytics capabilities. The developer will work closely with stakeholders to deliver solutions that meet business requirements while ensuring data security, quality, and compliance.

Responsibilities

• Design, develop, and test robust ETL processes for data warehousing and analytics solutions.
• Ensure accurate extraction, transformation, and loading of data into the data warehouse/data lake.
• Provide ongoing production support for data warehouse/data lake processes.
• Collaborate with data architects, data analysts, and stakeholders to design efficient data models.
• Uphold data security protocols and maintain data quality standards.
• Continuously optimize ETL processes for improved performance and reliability.
• Integrate AI technologies to enhance data analytics capabilities.
• Design and implement BI solutions using tools like Oracle BI Publisher and Microsoft Power BI.
• Support and maintain business intelligence solutions, including reports and dashboards.

Requirements

• B.S. or M.S. in Computer Science, Information Technology, Data Science, or a related field.
• 3 to 5 years of experience in BI/ETL development, data warehousing, and data lifecycle management.
• Experience with high volume, complex relational databases and star schemas.
• Strong understanding of database concepts for data modeling and mapping.
• Proficiency in writing complex SQL queries for data analysis.
• Competence in utilizing ETL tools such as Informatica and Oracle Data Integrator (ODI).
• Strong knowledge of ETL design best practices and data warehousing.

Nice-to-haves

• Experience with Microsoft Azure (Fabric, Databricks) is a plus.
• Domain knowledge in Oracle Cloud HCM (Core HR, Payroll, Time and Labor, Absence, and Workforce Compensation) is highly desirable.

Benefits

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