JOB TITLE: Application Developer II
LEVEL: 5
JOB SUMMARY:
The Analytic Platforms 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 Human Capital Management domain (HCM) which include all aspects of application development and data lifecycle, production support for vendor managed and custom solutions, 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.
Education and Experience
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.
Key Responsibilities
Design, develop, and test robust ETL processes to facilitate data warehousing and analytics solutions.
Ensure accurate extraction, transformation, and loading of data into the data warehouse/data lake while adhering to established standards and guidelines.
Provide ongoing production support for data warehouse/data lake processes, promptly addressing any issues or discrepancies that arise.
Work closely with data architects, data analysts and stakeholders to design and implement efficient data models that align with business requirements.
Uphold data security protocols, maintain data quality standards, and ensure compliance with industry regulations.
Continuously optimize ETL processes for improved performance, reduced load times, scalability, and reliability.
Integrate artificial intelligence (AI) technologies to enhance data analytics capabilities and automate repetitive tasks.
Design and implement BI solutions using tools such as Oracle BI Publisher, Microsoft Power BI, or Oracle Analytics Cloud (OAC), ensuring alignment with business requirements and best practices.
Provide support and maintain business intelligence solutions, including reports, dashboards, and analytics tools, to enable data-driven decision-making.
RPD design/development/deployment, reports and dashboards.
Knowledge, Skills & Abilities
Experience with high volume, complex relational databases, and star schemas.
Strong understanding of database concepts for data modeling and mapping including referential integrity, indexes, keys, common dimensions, master data and metadata.
Strong understanding of dimensional modeling (star schema).
Proficiency in writing complex SQL queries for data analysis and troubleshooting.
Competence in utilizing ETL tools such as Informatica, Oracle Data Integrator (ODI), and Oracle Cloud Infrastructure Data Integration (OCI DI).
Strong knowledge of ETL design best practices and data warehousing is required; to include performance optimization.
Proficiency in performance tuning of complex ODI scenarios and SQL queries for optimal performance.
Strong experience with Oracle Data Integrator (ODI) 12c in development, administration, and workflow orchestration to schedule and monitor ODI load plans/scenarios. Experience with OCI DI is a plus.
Experience with Business Intelligence Cloud Connector (BICC).
Strong knowledge of BI design best practices and data warehousing is required.
Proficient with performance optimization and tuning of BI reports.
Advanced data visualization and dashboard design skills.
Experience with Analytic Platforms such as Oracle Analytics Cloud (OAC) to include Data Visualization, OBIA, Microsoft Power BI, OTBI.
Strong experience with OBIEE/OAC security (users, object, and data level).
Business Intelligence and data warehouse development experience using OBIA/OAC with expertise in RPD design/development/deployment, reports and dashboards.
Experience with Microsoft Azure (Fabric, Databricks) is a plus.
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.
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: 7938
Job Category: Information Technology
Job Schedule: Full time
Company: Southern Company Services
#J-18808-Ljbffr