The Requirements
To be a strong fit for the Oracle Programmer Analyst opportunity you will have:- A bachelor’s degree in Computer Science, Information Systems, Business Administration or related field or the equivalent combination of education and experience
- 5+ years of related experience in system development, business systems implementation / support and/or business analysis
- Hands-on knowledge of Oracle E-Business Suite (specifically with Oracle HR/Payroll and Finance) technical tools including Forms, Reports, SQL, and PL/SQL Quick question for you - click here
- Experience with database concepts and data modeling capabilities; data warehouse experience is strongly preferred Quick question for you - click here
- Experience working with a relational database, including in depth knowledge creating and maintaining reports in a relational database
- Excellent knowledge of SQL and Stored Procedure code whether it is being maintained or created from scratch
- Experience mapping multiple data sources from various data formats and normalizing the data into SQL Server databases
- Expertise at troubleshooting and tuning existing SQL and identify opportunities to improve the performance
- Comfort creating tables, indexes, views, triggers, stored procedures, functions and synonyms to add functionality to existing processes or make them run more efficiently
- The ability to:
- Design and write custom ETL processes from multiple data sources
- Work collaboratively with business and IT professionals
- Communicate clearly, confidently and effectively, both verbally and in writing
- Understand current processes and ask the necessary questions to identify where improvements can be made
- Facilitate meetings and workshops in person and remotely
- Think analytically, solve problems and recommend approaches and solutions
- Some experience with CRM platforms (preferably Salesforce.com) and cloud-based technologies
- Working knowledge of standard software tools for source code management, continuous integration, and development
The Role
Reporting to the IT Manager, as the Oracle Programmer Analyst, you will be responsible for providing database-centric solution development, designing, and maintaining reports, ETL processes and SQL tuning. You’ll utilize your experience and knowledge in the Oracle E-Business Suite -- specifically in the HR / Payroll and Financial areas -- to create reporting, design the data warehouse and extract data. You will help visualize the correct architecture and solutions that we need for the deliverables.One of your first initiatives will involve analyzing the reports for the Finance areas to ensure they are complete and accurate, and once that is completed you will move on to the HR/Payroll function. In addition to your work with the reports and data warehouses, we will also look to you to assist with our current needs in the area of Sarbanes-Oxley (SOX).
You will spend the majority of your time analyzing, designing, coding and other hands-on activities. You will also provide software support to the application user community.
More specifically, you will:
- Work independently as well as in a team environment with minimal supervision.
- Design,develop and test high quality database solutions on time that perform according to the specifications and requirements documented
- Develop and support reports using SQL, PL/SQL, and Pentaho Kettle
- Utilize expertise in database design of Oracle E-Business Suite to build efficient dashboards and reports
- Identify and recommend changes to our databases to make them run more efficiently
- Develop and maintain custom reports, dashboards, validation rules and custom workflow
- Participates in all aspects of the application life cycle; analysis, design, coding, testing and implementation.
- Code, test and implement solutions using most appropriate tools based on design determined through collaboration with Enterprise Architect and Development Manager
- Develop and support integration with other systems/applications/databases
- Follow corporate system development life cycle, corporate style standards, Sarbanes-Oxley, governance and other related policies
- Perform support of production applications by responding to service desk assignments, tracking problems/issues, and following up with customers
- Support internally developed applications by addressing defects and coding and testing enhancements to existing systems
- Work with business, IT Business Partner, Business Analyst to understand issues with software and develop solutions to resolve them
- Develop and support reports requested by the business on vendor platforms
- Perform other duties as assigned by your supervisor​
Why MENTOR
Professional development -- we place a high value on knowledge transfer and, just as we'll expect you to help others learn what you know, we'll also make sure others share their knowledge with you. In the larger picture, we are proactive about helping our employees identify areas for growth and then achieve that growth.Career options -- as The MENTOR Network continues to grow, we are always looking for proven performers to step up. Depending on your ambition and success in this role, you'll be ideally primed to evolve your career along multiple directions, including opportunities within the Oracle team, other areas of IT or program management.
Flexibility -- we offer flexible work schedules and once you prove yourself, you'll have the option to work from home one day per week.
Intriguing challenges and projects -- we have a number of interesting projects in the works and are providing our IT team opportunities to contribute to new projects. In fact, we're always looking at and evaluating new technologies and systems to implement. This team has grown significantly over the past few years in order to support the needs of the business.
Newly public company -- we are proud to announce that we have just gone public (under the name Civitas Solutions, Inc.,) and there will be significant opportunity to focus on improvements and make recommendations.
Great environment -- the core competency of The MENTOR Network is helping people flourish and develop. We apply that competency in our corporate culture as well, promoting a growth-oriented, creative environment peopled by creative thinkers with varying perspectives whose one common trait is a commitment to our mission. You'll find a strong sense of teamwork in a collegial, positive atmosphere.
Excellent compensation -- in addition to a competitive salary, we offer comprehensive benefits.
Keys to Success
Just as important as your technical skill will be your communication and interpersonal abilities. You’ll work with a variety of key stakeholders to gather requirements, audit evidence and collect other important information so we’re looking for a professional who can interface and build relationships with colleagues throughout the organization. You’ll join a team of four professionals with a focus on HR/Payroll as you also work cross-functionally with another sub-group with expertise in the Finance functions.At the MENTOR Network, we believe everyone has a right to voice their ideas and share knowledge that will benefit the greater good of the company. To thrive in this environment, you won't be afraid to introduce a fresh perspective, take calculated risks and challenge the status quo as you step off the beaten path to investigate creative solutions. You'll also showcase fierce self-initiative to "own" your assigned projects, follow up any lingering issues with diligence and manage expectations. And last but not least, you'll remain adaptable and effectively manage change in a dynamic environment.