- SALARY:NONE
- New York
New York
Job Requisition ID90252
Hybrid - 3 days per week
Location Designation
New York, NY
Location
$160,915/year
Offered Wage
Interfaces with Data Modelers to export, transform, and load (ETL) data elements from existing data sources for use in the creation of new, user-friendly tables in the companys cloud data hub. Analyzes internal data architecture and data integrations to identify inefficiencies. Recommends best practices related to modeling business data and business intelligence (BI) solutions. Defines metadata and functional data model requirements. Engages with Application and Essaying teams across the organization to understand data requirements, flows, entities, and relationships. Monitors data quality and ensures data is properly translated for consumption by end business users. Works with Senior Developers to prototype new data solutions that support business teams in their ad hoc reporting responsibilities. Interfaces with business teams to understand business strategies, requirements, and pain points addressed by data and business solutions. Supports the definition of test scenarios and prepares test scripts to support business and technology teams in end-to-end Quality Assurance (QA) essaying efforts.
Duties
Education & Experience Requirements
Masters degree in Computer Science, Electrical Engineering or related field (willing to accept foreign education equivalent) plus three (3) years of experience as a Data Engineer (or closely related occupation) engineering and supporting data pipelines to channel data into multi-terabyte scale data warehouses.
Or, alternatively
Bachelors degree in Computer Science, Electrical Engineering or related field (willing to accept foreign education equivalent) and five (5) years of experience as a Data Engineer (or closely related occupation) engineering and supporting data pipelines to channel data into multi-terabyte scale data warehouses.
Required Skills
Experience must include 3 years in each of the following skills
- Building data pipelines and processing systems to extract, transform, load and integrate structured and unstructured data from various sources using industry standard ETL tools
- Performing reverse engineering and coding complex legacy database functions, procedures, and queries using Oracle PL/SQL
- Architecting and supporting enterprise data warehouses, databases, and operational data stores leveraging TOAD, Erwin, and SQL workbench slow changing dimension (SCD) 4 and hybrid SCDs 5-, 6-, and 7-dimensional modeling Many-to-Many relationship modeling and data vault modeling
- Programming applications on premise and in the cloud leveraging SQL, Python, Amazon Web Services (AWS), and Redshift and,
- Migrating, designing, and implementing cloud-based solutions into insurance/reinsurance and financial services domains.
Eligible for Employee Referral Program.
This notice is being provided as a result of the filing of an application for permanent alien labor certification for the relevant job opportunity. Any person may provide documentary evidence bearing on the application to the Certifying Officer, U.S. Department of Labor, Employment and Training Administration, Office of Foreign Labor Certification, 200 Constitution Avenue NW, Room N-5311, Washington, DC 20210.
Exempt
Overtime eligible
No
Discretionary bonus eligible
No
Sales bonus eligible
Click here to learn more about our
. Starting salary is dependent upon several factors including previous work experience, specific industry experience, and/or skills required.
Recognized as one of
Fortune's
Were proud that due to our mutuality, we operate in the best interests of our policy owners. We invite you to bring your talents to New York Life, so we can continue to help families and businesses Be Good At Life. To learn more, please visit
.
, our
and the
page of
.
Job Requisition ID90252