Software Develop Consultant

Voya Financial • Atlanta, GA

2d • Remote

About The Position

Together we fight for everyone’s opportunity for a better financial future. We will do this together — with customers, partners and colleagues. We will fight for others, not against: We will stand up for and champion everyone’s access to opportunities. The status quo is not good enough … we believe every individual and every community deserves access to financial opportunities. We are determined to support both individuals and communities in reaching a better financial future. We know that reaching this future depends on our actions today. Like our Purpose Statement, Voya believes in being bold and committed to action. We are committed to a work environment where the differences that we are born with — and those we acquire throughout our lives — are understood, valued and intentionally pursued. We believe that our employees own our culture and have a responsibility to foster an environment where we all feel comfortable bringing our whole selves to work. Purposefully bringing our differences together to positively influence our culture, serve our clients and enrich our communities is essential to our vision. Are you ready to join a company with a strong purpose and a winning culture? Start your Voyage – Duties : Work with Oracle software solutions including Oracle Data Integrator (ODI) and Oracle Analytics Cloud to include advanced product concepts. Integrate Oracle Data Integrations (ODI) packages on OFSAA application into broader Risk & Finance data, reporting & analytics architecture by developing interfaces in PL/SQL functions, and dashboards and reports using Oracle Analytics Cloud. Install and configure Oracle Analytics Cloud (OAC) in Cloud using Remote Data Gateway. Design, develop and test analytics and reporting solutions that meets enterprise standards in Oracle Analytics Cloud and create a reporting data model and build the semantic layer metadata for reporting using OAC admin tool. Must perform admin support to migrate the RPD, presentation catalog, customized configuration files, users and application roles to higher environments. Develop ETL code using Oracle Data Integrator (ODI) and build mappings and packages to help the Data Warehouse build. Analyze user requirements and based on findings create Requirements specification document, system specification document and other software development lifecycle specific document and own SDLC design reviews. 100% telecommuting position. Will consider applicants resident in the continental U.S.

Requirements

• Requires a bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or a closely related field, and minimum five (5) years of experience working as a Software Engineer or related position.
• Experience must include: Utilizing Data Warehousing concepts and dimensional modeling including dimensions, hierarchies, and attributes as they apply to OAC/BI analytical tools
• Working with advanced PL/SQL functions, and troubleshooting, performance tuning and working with stored procedures supporting financial data warehouse
• Utilizing OBIEE 12c, Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), Oracle (12c and 19c), Oracle Business Intelligence Enterprise Edition (v10.1.3.4.1, V11.1.1.5), or Oracle (10g,11g)
• Utilizing Informatica (v7.2,v8.6), SQL Server 2005, Windows XP or Windows 7
• Working on complex data structures, dashboards and ad hoc reporting to support warehouse development and reporting needs.

Responsibilities

• Work with Oracle software solutions including Oracle Data Integrator (ODI) and Oracle Analytics Cloud to include advanced product concepts.
• Integrate Oracle Data Integrations (ODI) packages on OFSAA application into broader Risk & Finance data, reporting & analytics architecture by developing interfaces in PL/SQL functions, and dashboards and reports using Oracle Analytics Cloud.
• Install and configure Oracle Analytics Cloud (OAC) in Cloud using Remote Data Gateway.
• Design, develop and test analytics and reporting solutions that meets enterprise standards in Oracle Analytics Cloud and create a reporting data model and build the semantic layer metadata for reporting using OAC admin tool.
• Must perform admin support to migrate the RPD, presentation catalog, customized configuration files, users and application roles to higher environments.
• Develop ETL code using Oracle Data Integrator (ODI) and build mappings and packages to help the Data Warehouse build.
• Analyze user requirements and based on findings create Requirements specification document, system specification document and other software development lifecycle specific document and own SDLC design reviews.

Benefits

• Health, dental, vision and life insurance plans
• 401(k) Savings plan – with generous company matching contributions (up to 6%)
• Voya Retirement Plan – employer paid cash balance retirement plan (4%)
• Tuition reimbursement up to $5,250/year
• Paid time off – including 20 days paid time off, nine paid company holidays and a flexible Diversity Celebration Day.
• Paid volunteer time — 40 hours per calendar year

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees