NuStar Technologies
AWS Neptune Expert
Experience Required: 8+ Years
Must Have Technical/Functional Skills AWS Neptune, Neo4j, S3, Snowflake, Graph database, AWS Cloud
Key Responsibilities
Identify and select the data sources, tables, and relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via the AWS service stack, securing extracted data and storing it in S3 for transformation before loading into AWS Neptune.
Collaborate with the current platform team to understand data structure and implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, and entity mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entity definitions.
Implement the graph schema in AWS Neptune.
Create indexes to improve query performance.
Review and refine schema based on query patterns and performance, based on mutually agreed design.
Define the transformation logic using DBT.
Develop DBT models for data transformation.
Schedule and automate the ELT pipeline using DBT and Snowflake.
Salary Range $100,000 to $140,000
Benefits Summary
Discretionary Annual Incentive
Comprehensive Medical Coverage: Medical and Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans
Family Support: Maternal and Parental Leaves
Insurance Options: Auto and Home Insurance, Identity Theft Protection
Convenience and Professional Growth: Commuter Benefits and Certification and Training Reimbursement
Time Off: Vacation, Time Off, Sick Leave and Holidays
Legal and Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Location Plano, TX
#J-18808-Ljbffr
Must Have Technical/Functional Skills AWS Neptune, Neo4j, S3, Snowflake, Graph database, AWS Cloud
Key Responsibilities
Identify and select the data sources, tables, and relationships between different entities in Snowflake.
Establish a secure connection between Snowflake and AWS Neptune via the AWS service stack, securing extracted data and storing it in S3 for transformation before loading into AWS Neptune.
Collaborate with the current platform team to understand data structure and implement data extraction processes from Snowflake.
Load the extracted data into AWS S3 for graph model transformation.
Analyze the data, relationships, and entity mappings to determine the necessary graph schema.
Design nodes, edges, and properties for the graph schema using entity definitions.
Implement the graph schema in AWS Neptune.
Create indexes to improve query performance.
Review and refine schema based on query patterns and performance, based on mutually agreed design.
Define the transformation logic using DBT.
Develop DBT models for data transformation.
Schedule and automate the ELT pipeline using DBT and Snowflake.
Salary Range $100,000 to $140,000
Benefits Summary
Discretionary Annual Incentive
Comprehensive Medical Coverage: Medical and Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans
Family Support: Maternal and Parental Leaves
Insurance Options: Auto and Home Insurance, Identity Theft Protection
Convenience and Professional Growth: Commuter Benefits and Certification and Training Reimbursement
Time Off: Vacation, Time Off, Sick Leave and Holidays
Legal and Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing
Seniority level
Mid-Senior level
Employment type
Full-time
Job function
Other
Location Plano, TX
#J-18808-Ljbffr