Role: Snowflake Data Engineer

Location: McLean, VA

Duration: FTE

JD:

Data Engineer with good knowledge of Snowflake cloud platform, architecture.

Experience with various data ingestion methods (snowpipe & others), time travel and data sharing and other Snowflake capabilities

Very good knowledge of data warehouse, data infrastructure, data platforms, ETL implementation, data modelling and design

Ability to be creative and analytical in a problem-solving environment.

Effective verbal and written communication skills.

Adaptable to new environments, people, technologies, and processes

Ability to manage ambiguity and solve undefined problems

Working experience in services of the public Clouds like AWS or Azure

Experience in using Data migration using cloud-native tools like AWS DMS or Azure DMS

Experience in tasks and streams in Snowflake

Responsibilities:

Build and maintain robust and scalable ETL/ELT pipelines to integrate data from multiple systems across the enterprise

Build complex data models to perform business analysis using SQL Queries on Snowflake

Collaborate across the company s multiple data teams to meet analytics deliverables

Maintain databases and develop/support monthly/quarterly metrics reports

Improve performance, efficiency, and accuracy of all queries

Provide business partners with actionable insights into KPIs in the form of regular reporting and ad-hoc analysis

Identify and drive process and reporting enhancements, develop and collaborate across teams to help scale the process

Good knowledge of SQL and should be able to write complex SQLs

Qualifications

Experience in writing strong SQL in data warehouse technologies (Snowflake or any modern database)

Strong understanding of Data Warehousing concepts for big data applications and services, preferably using Snowflake

3+ years of proven experience in building large scale ETL/ELT pipelines using your own code (Python, Java )

Experience working with Client/AI teams is a big plus

Expertise in database design & development, writing optimized queries, handling facts, dimension data effectively

Effective problem solving and analytical skills. Ability to manage multiple projects and report simultaneously across different stakeholders

Structured thinking with ability to easily break down ambiguous problems and propose impactful data modeling designs

Passion for analyzing large and complex data sets and converting them into the information which drive business decisions

Attention to detail, organization, and effective verbal/written communication skills

Must be able to work in fast paced environment and be able to adapt to changing requirements

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.