Oracle Analytics Developer - Software Developer Sr

Lower Colorado River Authority - Austin, TX

Full-time - Mid Level

Austin, TX

Utilities

About the position

The Oracle Analytics Developer position at LCRA involves contributing to the development, integration, and implementation of Oracle Analytics solutions. This role is critical in leveraging Oracle BI & Analytics systems, particularly in integrating these solutions with ERP systems like PeopleSoft and Maximo, while working collaboratively within a dynamic team.

Responsibilities

• Play a critical role in technical development, integration, building, and testing within Oracle Analytics environments.
• Leverage Oracle Data Integrator (ODI) to design and implement efficient data integration and ETL/ELT processes, ensuring the accuracy and accessibility of data across systems.
• Utilize RPD (Repository) development skills to create and manage the metadata layer in Oracle BI, facilitating effective data modeling and analytics reporting.
• Engage in collaborative efforts with developers, DBAs, business partners, and application administrators to design and implement effective solutions.
• Guide the BI application lifecycle, encompassing design, configuration, deployment, and administration, aligned with LCRA's strategic goals.

Requirements

• Nine or more years of experience in developing and programming/coding software applications or relevant experience.
• Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent experience.
• 4+ years of Oracle analytics experience, particularly with OBIEE, OAS, OAC, OBIA, and ODI.
• Proficiency in designing and executing ETL/ELT processes with ODI, ensuring efficient data flow and integration.
• Experience in data modeling and repository (RPD) design within Oracle BI, enhancing data accessibility and reporting capabilities.
• Proficiency in working with large, complex ERP systems, notably PeopleSoft and Maximo, with a proven ability to integrate BI tools with these systems.
• Exceptional analytical, problem-solving, and communication skills.
• Thorough understanding of BI application design, configuration, deployment, and administration.

Nice-to-haves

• Experience with Oracle APEX is a plus.
• Experience with Oracle GoldenGate is a plus.
• Oracle Analytics Cloud certification or similar credentials are advantageous.

Benefits

• Competitive salary & medical, dental, vision and legal insurance
• Paid time off, including time for vacation, sick and family care leave
• 401(k) match up to 8% that includes a student loan 401(k) contribution program option
• Life and disability insurance
• Wellness program including wellness incentive
• Extensive learning & development programs