Snowflake Data Engineer, Diverse Lynx, Mc Lean, VA
Diverse Lynx -
Mc Lean, VA,
US
Snowflake Data Engineer
Date Posted: 2024-05-18
Job description
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
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.
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.