The job below is no longer available.
You might also like
in Boston, MA
$50est. per hour Ascensus • 5h agoUrgently hiring 2.4 mi Use left and right arrow keys to navigate- $23
est. per hour BlueRock Therapeutics • 5h agoUrgently hiring 1 mi Use left and right arrow keys to navigate - U.S. Army • 21h ago
Urgently hiring 4.3 mi Use left and right arrow keys to navigate - U.S. Army • 21h ago
Urgently hiring 0.5 mi Use left and right arrow keys to navigate
Oracle Programmer Analyst
•30 days ago
| Hours | Full-time, Part-time |
|---|---|
| Location | Boston, MA Boston, Massachusetts |
About this job
Oracle Programmer Analyst-15000120 Job Information Technology Primary Location United States-MA-MABoston Organization Corporate (Network) The MENTOR Network is currently seeking an Oracle Programmer Analyst to join our growing Information Technology team. We are looking for an experienced analyst to transition our HR and Finance applications to cloud based services, create a data warehouse, and develop a complete set of HR reports. This is a great opportunity to partner with various business groups (HR, Finance, Payroll), discuss individual needs, collect requirements, and contribute to decisions on the growth of the organization.
Description
Qualifications Requirements:
External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job functions either unaided or with assistance of a reasonable accommodations to be determined on a case by case basis.
Founded in 1980, The MENTOR Network is a national network of local human services providers with ~28,000 employees serving ~25,000 consumers in 36 states. We offer an array of quality, community-based services to adults and children with intellectual and developmental disabilities, acquired brain injury and other catastrophic injuries and illnesses and to youth with emotional, behavioral and medically complex challenges as well as their families.
Description
Provide database-centric solution development, designing, and maintaining reports, ETL processes and SQL tuning. Provide software support to the application user community.
ESSENTIAL JOB FUNCTIONSTo perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below.
- 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
- Performs other duties as assigned by your supervisor
Qualifications Requirements:
Education and Experience:
- Bachelor’s Degree in Computer Science, Information Systems, Business Administration or related field. Three years of related experience in system development and business analysis preferred.
- 5 plus years of progressive experience with business systems implementation and support
- Bachelor’s Degree in Computer Science, Information Systems, Business Administration or related field
- Experience with database concepts and data modeling capabilities
- Must have experience working with a relational database
- 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
- Excellent at troubleshooting and tuning existing SQL and identify opportunities to improve the performance.
- Comfortable creating tables, indexes, views, triggers, stored procedures, functions and synonyms to add functionality to existing processes or make them run more efficiently.
- Ability or desire to design and write custom ETL processes from multiple data sources
- Ability to work collaboratively with business and IT professionals
- Ability to communicate clearly, confidently and effectively, both verbally and in writing
- Ability to facilitate meetings and workshops in person and remotely
- Ability to think analytically, solve problems and recommend approaches and solutions
- Some experience with Oracle HR/Payroll Applications
- Some experience with CRM platforms and cloud-based technologies
- Working knowledge of standard software tools for source code management, continuous integration, and development
External and internal applicants, as well as position incumbents who become disabled, must be able to perform the essential job functions either unaided or with assistance of a reasonable accommodations to be determined on a case by case basis.
Founded in 1980, The MENTOR Network is a national network of local human services providers with ~28,000 employees serving ~25,000 consumers in 36 states. We offer an array of quality, community-based services to adults and children with intellectual and developmental disabilities, acquired brain injury and other catastrophic injuries and illnesses and to youth with emotional, behavioral and medically complex challenges as well as their families.
EOE/AAE