Oracle PL/SQL Developer

Location : St. Louis MO 

City : Chesterfield 

State : Missouri (US-MO) 

Country : United States (US) 

Requisition Number : 27732 

Bunge has an exciting opportunity available for a Oracle PL/SQL Developer.  In this role you will be part of a global 
team working on challenging, meaningful projects impacting core business activities. 

 Since 1818, Bunge has been connecting farmers to consumers to deliver essential food, feed, and fuel to the world.  Looking to the future, our ambition is to continuously reinvent ourselves, leveraging data to be at the forefront of analytics, technology and talent to accomplish our purpose in a better, faster and simpler way.  Bunge is committed to operating and thriving in the digital world – creating world class agile teams where teammates are empowered and encouraged to collaborate and test and learn to succeed.
 
At Bunge, people don’t just come here to work, they come here to grow – solving challenges that directly impact the world with a diverse team of thinkers and doers. Bunge offers a strong compensation and benefits package, generous paid time off program, flexible work arrangements, and opportunity to progress.  Our hybrid work environment provides a balance of in office and remote work.
Most importantly, in all we do we live our values:

• Act as One Team by fostering inclusion, collaboration, and respect
• Drive for Excellence by being agile, innovative and efficient
• Do What's Right by acting safely, ethically, and sustainably

Overview:
Oracle PL/SQL Developer will join distributed Data Warehouse Maintenance and Support Team. This role will be responsible for designing and maintaining the Global BI database to ensure its stability, reliability and performance, implement improvements and provide day-to-day support for data warehouse stakeholders. The role will work closely with development teams to understand the existing solutions, identify the root cause of the observed and reported issues and come up with the solutions to meet stakeholders’ needs. The role will be improving ETL/ELT pipelines, SQL queries and helping stakeholders with SQL queries optimizations; analyse, monitor, and optimize existing solutions; ensure compliance of deliverables to quality standards. 

Essential functions:

• Interact with Project Management, Business Stakeholders, Business Analysts, Architects, Developers and Database Administrators to clarify the needs
• Monitor database processes execution and address processing errors and delays
• Analyse jobs execution patterns and suggest improvements
• Design and implement data warehouse ETL/ELT process improvements
• Analyse the incidents and issues identified in the processing or raised by the stakeholders, identify the root cause and implement fix
• Coordinate bug fixes and improvements implementations with the business and technical stakeholders and development teams
• Support stakeholders in building optimal SQL queries
• Optimize existing solutions
• Manage the queue of the data warehouse related incidents in ServiceNow
• Plan and keep track of development activities in project management software (e.g. Jira)
• Attend and represent changes to environments in change management meetings.

Qualifications/Requirements:

• 3 years of experience with Oracle SQL and PL-SQL programming, 5 preferred
• Experience developing and maintaining data warehouses in big data solutions 
• Familiarity with Oracle build-in dictionaries and packages
• Good knowledge of Oracle analytical functions 
• Expertise in relational and multidimensional databases as well as in queries optimization 
• Experience with processing big data sources in Oracle
• Experience with integrating various data sources
• Experience in monitoring Oracle DB (jobs, execution of queries, etc.)
• Focused on customer satisfaction
• Willingness to learn new tools and technologies
• Worked with BI tools such as Tableau, Power BI, Looker, Shiny (Preferred)
• Conceptual knowledge of data and analytics, such as dimensional modeling, ETL, reporting tools, data governance, data warehousing, structured and unstructured data.
• Experience working on a collaborative Agile product team 
• Flexibility to changes in work direction as the project develops
• Excellent communication, listening, and influencing skills
• Demonstrated strong number sense, intellectually curious and willing to adjust position based on additional information 
• Strong work ethic; ability to work at an abstract level and gain consensus 

Bunge (NYSE: BG) is a world leader in sourcing, processing and supplying oilseed and grain products and ingredients. Founded in 1818, Bunge’s expansive network feeds and fuels a growing world, creating sustainable products and opportunities for more than 70,000 farmers and the consumers they serve across the globe. The company is headquartered in St. Louis, Missouri and has 25,000 employees worldwide who stand behind more than 350 port terminals, oilseed processing plants, grain facilities, and food and ingredient production and packaging facilities around the world.

Bunge is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, transgender status, national origin, citizenship, age, disability or military or veteran status, or any other legally protected status.  Bunge is an Equal Opportunity Employer. Minorities/Women/Veterans/Disabled