Jobs
>
Bloomington

    ETL / Snowflake Developer - Full Time Employment - McLean, United States - Arthur Grand Technologies Inc

    Default job background
    Full time
    Description

    Job Description

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

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

    Additional Information

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



  • Freddie Mac McLean, United States

    At Freddie Mac, you will do important work to build a better housing finance system and you'll be part of a team helping to make homeownership and rental housing more accessible and affordable across the nation. · **Position Overview**: · **Our Impact**: · The Employment Law Team ...


  • Kaiser McLean, United States Full time

    This position is eligible for a $10,000 sign on bonus · Job Summary: · For members of a defined population, responsible for collaborating with the members of the health care team to facilitate the coordination of appropriate, cost-effective services that are consistent with membe ...


  • Kaiser McLean, United States Full time

    This position is eligible for $10,000 sign on bonus · Job Summary: · For members of a defined population, responsible for collaborating with the members of the health care team to facilitate the coordination of appropriate, cost-effective services that are consistent with member ...


  • Capital One McLean, United States

    Center , United States of America, McLean, VirginiaManager, Data Scientist - Compliance RiskData is at the center of everything we do. As a startup, we disrupted the credit card industry by individually personalizing every credit card offer using statistical modeling and the rela ...


  • Kaiser McLean, United States Full time

    Job Summary: · For members of a defined population, responsible for collaborating with the members of the health care team to facilitate the coordination of appropriate, cost-effective services that are consistent with members plan of care, help achieve his/her optimal level of ...


  • Kaiser McLean, United States Full time

    Job Summary: · For members of a defined population, responsible for collaborating with the members of the health care team to facilitate the coordination of appropriate, cost-effective services that are consistent with members plan of care, help achieve his/her optimal level of ...

  • EnDyna

    Contracts Manager

    2 days ago


    EnDyna McLean, United States

    EnDyna is currently recruiting a Project & Contract Manager (PCM) to oversee its various contracts. The PCM will manage multiple projects/contracts simultaneously, dividing their time effectively among them. This role will be based primarily at EnDyna's office in McLean, VA. · Th ...


  • State Farm McLean, United States Full time

    Overview · We are not just offering a job but a meaningful career Come join our passionate team · As a Fortune 50 company, we hire the best employees to serve our customers, making us a leader in the insurance and financial services industry. State Farm embraces diversity and inc ...

  • Federal Realty Investment Trust

    Property Manager

    6 days ago


    Federal Realty Investment Trust McLean, United States

    Overview: · **Responsibilities**: · - Develop and review annual property operating budgets, monitor all purchases and expenses to ensure cost effectiveness and compliance with budget parameters, prepare monthly variance reports and quarterly budget reforecast reports · - Create a ...

  • Somatus, Inc.

    HR Generalist

    1 week ago


    Somatus, Inc. McLean, United States

    Overview: · As the HR Generalist, you will lead strategic Human Resources initiatives and create data driven solutions that inform business decisions. As a key member of the Human Resources team, you enjoy streamlining and optimizing related systems, data, and processes. Leveragi ...

  • US Office of the Director of National Intelligence

    Tradecraft Reviewer

    13 hours ago


    US Office of the Director of National Intelligence McLean, United States

    **Duties**: · NCTC's Directorate of Identity Intelligence (DII) is seeking an energetic officer to serve as a Tradecraft Reviewer in DII's Mission Innovation Group. This position requires the skills of a motivated self-starter with excellent interpersonal skills who can work coll ...


  • SecTek, Inc McLean, United States

    Unarmed Security Officer (McLean, VA) PT · **Security Duties**: · **Our Officers are responsible for providing quality physical security at the client site. Duties include, but are not limited to**: · - Following prescribed Standard Operating Procedures for basic and emergency re ...


  • US Office of the Director of National Intelligence McLean, United States

    **Duties**: · **Major Duties and Responsibilities**: · Support the Functions and Collections Group to coordinate and facilitate enterprise-wide integration of the IC's collection, and supporting capabilities related to IC spectrum management; · Serve as the MPAC/FCG expert in Glo ...


  • Palmercare Chiropractic MCLEAN McLean, United States

    Palmercare Chiropractic in MCLEAN, VA is looking for our next amazing team member This clinic has made a huge impact on the health and wellness of our community, and in turn, continues to grow. For that reason, we are looking for our next team member to help us reach more members ...

  • US Office of the Director of National Intelligence

    Analyst

    1 week ago


    US Office of the Director of National Intelligence McLean, United States

    **Duties**: · Develop an understanding of and utilize a variety of methodological tools and approaches to gain a comprehensive understanding of known or suspected terrorists (KSTs), including as appropriate, social networking and other "new" media; incorporate policies, strategie ...


  • EnDyna McLean, United States

    **Position Overview** · **Responsibilities**: · - Interpret and analyze laboratory results related to environmental samples. · - Match results obtained from databases to the corresponding data in studies and reports. · - Utilize environmental and water expertise to assess data ac ...

  • Pendulum LLC

    Data Scientist

    6 days ago


    Pendulum LLC McLean, United States

    **JOB DESCRIPTION** · **Clearance Level: Top Secret/SCI with Full Scope Polygraph** · **Skill Level(s): Expert** · **REQUIRED SKILLS** · - Clearance Level: Top Secret/SCI with Full Scope Polygraph- Skill Level(s): Expert- · - generating ideas for revolutionary technologies suppor ...

  • KBR

    Business Analyst

    1 week ago


    KBR McLean, United States

    **Title**: · Business Analyst · **Business Analyst**: · **McLean, VA** · **Full-Time** · **Responsibilities**: · - Assist with the development and monitoring of department and divisions level strategic plans and objectives; · - Develop and implement Department Level portfolio, pr ...

  • Finishline Macy's

    Pt Supervisor

    13 hours ago


    Finishline Macy's McLean, United States

    **Come work for us** · We are looking for dedicated employees to join our team to help our customers have the best experience possible every time they enter a Finish Line Macy's store. · - **Our employees are key to our success.**_ · **Position Title**:Store Supervisor · **Summar ...


  • Aligned Orthopedic & Sports Therapy McLean, United States

    **Who we are**: · Aligned Orthopedic Partners is a well-respected private orthopedic team comprised of highly trained, board-certified orthopedic surgeons devoted to delivering patients with the highest orthopedic care possible. Our commitment to finding the best solutions for in ...