ETL Snowflake Developer

Company Description

Arthur Grand Technologies (www.arthurgrand.com) is in the business of providing staffing and technology consulting services. We have doubled our revenue year over year for the past 5 years. This speaks to the long-lasting relationship and customer satisfaction that we have built in this short span of time. Our company is managed by a team of professionals who worked for big 5 consulting firms for 20+ years. 

We are a minority owned staff augmentation and technology consulting company
To keep our valued employees, we need to keep them engaged in challenging, interesting work, offer market-relevant benefits and provide continued opportunities for professional growth.

Job Description

Arthur Grand Technologies is currently seeking a highly motivated and skilled Senior/Mid-level Snowflake Developer  for one of our clients

Role: Senior/Mid-level Snowflake Developer

Location: McLean, VA

Duration: Long term

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 ML/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

Thanks,

Afrah Faiza

Arthur Grand Technologies Inc

Arthur Grand Technologies is an Equal Opportunity Employer (including disability/vets)

Additional Information

All your information will be kept confidential according to EEO guidelines.