ETL / Snowflake Developer – Full Time Employment & Contract

Company Description

Arthur Grand (AG) is an IT services firm specializing in Digital Transformation initiatives for Federal, Commercial, State & local customers. Since 2012, AG has (been) successfully supporting and delivering IT services to our customers in the areas of enterprise modernization and transformation with a core focus on emerging technologies including Cloud Solutions (AWS, Azure), Agile Development and Custom Programming, Full Stack Development, DevOps, DevSecOps, & CI/CD, Web & Mobile APP Development, Data Visualization and Data Warehousing, Financial/ERP System Implementation, Infrastructure Management. Arthur Grand’s culture of (delivery excellence) or excellent delivery, combined with a commitment to bring the best talent to provide services, has earned our company an unparalleled reputation for delivering transformative results.

Job Description

Arthur Grand Technologies is currently seeking a highly motivated and skilled Snowflake Developer for one of our clients.

Role: Snowflake Developer

Location: McLean, VA (Onsite Hybrid)

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

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

About Arthur Grand Technologies:

Arthur Grand Technologies is a leading provider of staffing and technology consulting services. Our company is managed by a team of professionals who have worked for big 5 consulting firms for 20+ years. We are a minority-owned staff augmentation and technology consulting company.

At Arthur Grand Technologies, we value our employees & contractors and strive to provide them with challenging, interesting work, market-relevant benefits, and opportunities for professional growth. If you have the necessary qualifications, and are excited to join a dynamic team.

Thank you for considering Arthur Grand Technologies. We look forward to hearing from you soon.

Best regards,

Richard Tucker

Arthur Grand Technologies Inc

www.arthurgrand.com

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

Additional Information

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