Senior Data Warehouse Developer

Location Designation: Hybrid - 3 days per week 

This position primarily involves a hybrid work schedule - working remotely: Monday & Friday / on site: Tuesday, Wednesday and Thursday. 

As part of New York Life Direct, you'll join a team revolutionizing the life insurance experience for AARP members. We're the industry leader in direct-to-consumer life insurance, offering streamlined coverage directly to individuals, bypassing traditional agent models. Your work will directly impact lives by making life insurance accessible, affordable, and understandable for millions of Americans.

What You’ll Do:

Ready to join our team and dive into an exciting role? We are a team of data-minded professionals responsible for the care and growth of our data warehouse and the business intelligence toolset.

Your mission? Enable data analysts and managers to extract insights from our data ecosystem.

Working closely with our business analysts, stakeholders, and Architects you will design Oracle data warehouse components and associated ETLs.

Your goal? Drive delivery of strategic and BAU initiatives by ensuring our data warehouse components are reliable, efficient, and adaptable as technology and business needs continue to evolve.

As an integral part of an on-call rotation you'll support production jobs, troubleshoot application issues, and guide users through the data warehouse systems.

Sound interesting? Let's team up and make waves in the world of data and business intelligence!

What you'll bring:

• Bachelor's degree in Computer Science, Information Systems, or equivalent
• 3+ years of relevant experience
• Willingness to learn and adapt to new technologies
• Very strong knowledge and proficiency with SQL
• Experience in Oracle 19c
• Hands on experience using SQL client tools Toad, SQL Workbench, SQL Management Studio
• Proven history of developing and debugging complex SQL and Oracle database configurations
• Familiarity with relational and dimensional database modeling
• Effective communication and teamwork abilities

Bonus points for these:

• Knowledge of BI tools like MicroStrategy, Tableau, and Power BI
• Experience with Python 3+
• Proficiency with IDEs such as Visual Studio for SSIS development and source code management tools like TFS/ Git
• Experience with Agile methodologies
• Hands on experience working on Windows Server and Linux platforms
• Database certifications in Oracle and/or SQL Server