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.
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.
