Vacancy expired!
This position involves a hybrid work schedule - working remotely: Monday & Friday / on site: Tuesday, Wednesday and Thursday.
When you join New York Life, you're joining a company that values career development, collaboration, innovation, and inclusiveness. We want employees to feel proud about being part of a company that is committed to doing the right thing. You'll have the opportunity to grow your career while developing personally and professionally through various resources and programs. New York Life is a relationship-based company and appreciates how both virtual and in-person interactions support our culture. The Data Warehouse Developer is part of an agile team focused on creating and sustaining an accurate, integrated, and authoritative business information analysis capability with powerful, easy-to-use, and highly available tools. This person works to improve and extend the abilities of data analysts and managers to easily interpret large amounts of complex data to identify actionable business insights, make better business decisions, and discover strategic opportunities. This is a highly technical role that includes understanding business data analysis requirements, building new data warehouse components to ingest and transform business operations data, and designing and delivering business intelligence assets. In addition to technical skills, effective communication is a key success factor as changes in scope, effort, and timeline to meet business objectives is a constant requirement. The NYL Direct data warehouse platform is a complex environment requiring expertise with the Oracle database management systems and SQL Server Integration Services (SSIS). Responsibilities for this position include:- Work with business analysts and stakeholders to understand requirements for data analysis, data structures, information delivery and reporting.
- Perform data analysis and develop source-to-target data mapping.
- Work with data architects to design Oracle data warehouse components including database tables, views, stored procedures, data marts, etc.
- Develop extract-transform-load (ETL) processes using SSIS to extract data from various data sources, transform and normalize it as necessary, and ingest it into the Oracle data warehouse.
- Test, deploy and promote database objects to system environments following standard methodologies.
- Use sound software engineering principles to ensure that data warehouse components are modifiable, efficient, reliable, understandable, and fault tolerant.
- Perform system maintenance and support including modifying existing data warehouse code as needed.
- Provide production support for production jobs and processes by working with operators, network administrators, technical support staff, application development teams, and 3rd party vendors to implement tactical solutions and maintain high availability of data warehouse systems.
- Work with technical support staff to determine root cause of production database application issues.
- Support business users and other stakeholders with the use of data warehouse systems, user acceptance testing, etc.
- Create and maintain documentation for data warehouse components, technical specifications, and other technical documentation for use by the team and other stakeholders.
- Bachelor of Science degree in Computer Science, Information Systems, or equivalent.
- Five to seven years of relevant experience.
- Ability to manage workload and priorities in a fast-paced, multi-tasking environment.
- Experience working in an Agile software development methodology (e.g., Scrum, Kanban).
- Proficient skills with Oracle, SQL Server, and SSIS.
- Experience with relational and dimensional databases.
- Experience with integrated development environments (IDE) such as Visual Studio.
- Experience with source code management tools such as TFS and Git.
- Strong PC experience including Windows and the MS Office suite.
- Strong oral and written communications.
- Ability to effectively function as a member of a team.
- Ability to share learned knowledge to increase support level of database systems.
- Willingness to learn through on-the-job experience and to support new technology.
- Willingness to perform additional, unplanned project work as assigned.
- Database certifications in Oracle, SQL Server.
- Familiar with CA ERWin data modeling software.
- ID: #43686474
- State: Florida Tampa bay area 33601 Tampa bay area USA
- City: Tampa bay area
- Salary: USD TBD TBD
- Job type: Permanent
- Showed: 2022-06-29
- Deadline: 2022-08-27
- Category: Et cetera