Data Engineer

Lorven Technologies - Alpharetta, GA

Full-time - Mid Level

Alpharetta, GA

Professional, Scientific, and Technical Services

About the position

The Data Engineer position is a long-term contract role based in Alpharetta, GA, requiring extensive experience in data warehousing and ETL concepts. The role involves working with SQL, Hadoop, and Snowflake, and requires strong analytical skills to gather and analyze system requirements. The ideal candidate will have a collaborative attitude and the ability to work effectively across teams.

Responsibilities

• Gather and analyze system requirements for data warehousing.
• Design and implement ETL processes.
• Write complex SQL queries for data manipulation and analysis.
• Utilize Snowflake utilities such as SnowSQL and SnowPipe.
• Collaborate with cross-functional teams to ensure data integrity and availability.
• Provide insights and reports using BI tools like Tableau.

Requirements

• 12+ years of experience in data engineering.
• Expertise in SQL and ability to write complex queries.
• In-depth knowledge of Data Warehouse/ODS and ETL concepts.
• Hands-on experience with Hadoop, Hive SQL, and Python/Pyspark.
• Experience with Snowflake and its utilities.

Nice-to-haves

• Experience with Tableau or other BI tools.
• Familiarity with Java and Spring Boot.
• Financial industry experience.

Benefits

• Flexible working hours due to hybrid model.
• Opportunity to work on long-term projects.