Data Engineer -Snowflake
Share
Job Location:
North Wilkesboro, NC - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Data Engineer -Snowflake
Location: Raleigh NC (Onsite)
Job Type: 06-12 Months
Work Authorization: US Citizen or Green Card ONLY
Client: Fidelity Investments
Years of Experience: 8-10 Years
Responsibilities:
Translate data models into efficient and optimized database objects in accordance with established governance and naming conventions.
Develop and implement data transformation and loading process to populate and maintain data within the created tables and views.
Collaborate with data architects and tech leads to understand data requirements and translate them into logical data model.
Document table/view definitions into Alation and enable data quality checks for required tables/views.
Optimize database performance by identifying and implementing improvements to queries indexing and table structures.
Location: Raleigh NC (Onsite)
Job Type: 06-12 Months
Work Authorization: US Citizen or Green Card ONLY
Client: Fidelity Investments
Years of Experience: 8-10 Years
Responsibilities:
Translate data models into efficient and optimized database objects in accordance with established governance and naming conventions.
Develop and implement data transformation and loading process to populate and maintain data within the created tables and views.
Collaborate with data architects and tech leads to understand data requirements and translate them into logical data model.
Document table/view definitions into Alation and enable data quality checks for required tables/views.
Optimize database performance by identifying and implementing improvements to queries indexing and table structures.
Required Skills and Qualifications:
Strong proficiency in SQL and experience with relational database management systems (RDBMS) such as Oracle or Snowflake
Experience with data warehousing concepts and technologies.
Experience with Python for Data Processing.
Familiarity with ETL/ELT tools and techniques.
Experience in developing data applications in Cloud (AWS)
Experience with Business Intelligence like Tableau and Dashboards is a plus
Experience with DevOps Continuous Integration and Continuous Delivery (Jenkins GitHub)
Understanding of data governance principles and best practices.
Proven experience in understanding existing data model and develop the data objects.
Excellent analytical and problem-solving skills.
Ability to work independently and collaboratively within a team environment.
Strong communication skills to articulate technical concepts to both technical and non-technical audiences.
Strong proficiency in SQL and experience with relational database management systems (RDBMS) such as Oracle or Snowflake
Experience with data warehousing concepts and technologies.
Experience with Python for Data Processing.
Familiarity with ETL/ELT tools and techniques.
Experience in developing data applications in Cloud (AWS)
Experience with Business Intelligence like Tableau and Dashboards is a plus
Experience with DevOps Continuous Integration and Continuous Delivery (Jenkins GitHub)
Understanding of data governance principles and best practices.
Proven experience in understanding existing data model and develop the data objects.
Excellent analytical and problem-solving skills.
Ability to work independently and collaboratively within a team environment.
Strong communication skills to articulate technical concepts to both technical and non-technical audiences.
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
