Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Snowflake Data Architect and Administrator

Sligo Software Solutions

Description

Database Architect is expected to design data infrastructure to extract and organize Department of Financial Services' enterprise data systems, bridges the gap between business needs and complex technology, ensures Department of Financial Services' data is secure, highly available, scalable, and compliant with New York State policies and regulations.

Duties

  • Monitor DFS Snowflake credit usage, adjust resource monitors, and tune virtual warehouses
  • Manage Snowflake users and roles, enforce security policies, audit Snowflake access
  • Write and tune SQL queries, build Snowflake ELT pipelines, manage compute and cost, and configure security and governance
  • Build and update Informatica mappings and configure workflows.
  • Perform unit testing and validate data integrity
  • Troubleshoot failures, tune performance
  • Documentation ETL process, security policies, system architecture, user guides and etc.

Mandatory Requirements

  • Experience (15+ Years)
  • Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Requirements

  • This is an 100% Onsite.
  • 84 Months Experience in Snowflake data warehouse development and administration.
  • 84 Months Experience in Snowflake performance tuning and improvement.
  • 84 Months Experience in Informatica pipeline development and data transformation.
  • 84 Months Experience in Informatica performance tuning and improvement.
  • 84 Months Experience in RDBMS (Relational Database Management System) and SQL Query development.
  • 48 Months Experience in solution architecture & modeling.
  • 84 Months Experience in database and platform security & governance.
  • R sum
  • Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable)
  • Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Snowflake Data Architect and Administrator in Albany, NY vacancy
  •  ...Senior Snowflake Database Architect, (Hybrid), Albany, NY 10 years of experienced candidates required...  ...Architect is expected to design data infrastructure to extract and...  ...Snowflake data warehouse development and administration. 2 84 Months Experience... 
    Suggested
    Local area

    Nexiva Inc

    Albany, NY
    1 day ago
  •  ...the State of New York. (Possibility of extension). Required Experience: ~84 Months Experience in Snowflake data warehouse development and administration. ~84 Months Experience in Snowflake performance tuning and improvement. ~84 Months Experience in Informatica... 
    Suggested
    Hourly pay
    Contract work

    Genesys

    Albany, NY
    3 days ago
  • 84 Months Experience developing and maintaining logical and physical dimensional data models, including star schema, snowflake schema, and data migration strategies in enterprise data warehouse and business intelligence environments. 84 Months Experience using data modeling... 
    Suggested

    JSM Consulting

    Albany, NY
    4 days ago
  • $150k - $185k

     ...methodology to measure project progress.   Review schedules with project team members on a regular basis to ensure that accurate and timely data is incorporated into the schedule.   Prepare and provide schedule progress reports, trending charts, and schedule analysis on a... 
    Suggested
    Full time
    For contractors
    Flexible hours

    Turner & Townsend

    Albany, NY
    22 days ago
  •  ...Job Title: Database Architect Duration: 30 Months...  ...Architect is expected to design data infrastructure to extract and...  ...Responsibilities: Monitor DFS Snowflake credit usage, adjust...  ...data warehouse development and administration. 84 Months Experience... 
    Suggested
    Full time
    Contract work
    Local area

    VGroup Inc

    Albany, NY
    1 day ago
  •  ...consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States. This is a...  ...tremendous career growth potential. Job Title: Senior Data Architect Location: NYC, NY – Onsite Position Type: Long-Term... 
    Long term contract
    Temporary work
    H1b
    Local area
    Immediate start

    Bright Vision Technologies

    Albany, NY
    2 days ago
  •  ...motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key...  ...(e.g., Python). ~1 year of experience with Tableau Server Administration. ~2 years of experience working with customers in data... 
    Flexible hours

    VISTRADA

    Albany, NY
    4 days ago
  •  ...allocation to optimize operational flow. The procedure scheduler acts as a liaison between patients, healthcare providers, and administrative staff to facilitate clear communication and timely scheduling. By managing appointment logistics and maintaining detailed records... 
    Full time
    Work at office

    Allied Digestive Health, LLC

    Albany, NY
    3 days ago
  •  ...We have an opening for a talented Kelly Services Administrative Assistant to perform daily responsibilities with dedication. Provide excellent interactions with customers and colleagues. Ensure compliance with company and safety standards. Perks include competitive pay... 
    Flexible hours

    TradeJobsWorkforce

    Albany, NY
    1 day ago
  •  ...adjustment (pro-rated for part-time positions).Department(OHEHR) AI - AIDS InstituteJob Description:ResponsibilitiesThe Health Program Administrator II will be located within the AIDS Institute’s Office of Medicaid Policy and Healthcare Financing. The incumbent will have... 
    Full time
    Contract work
    Part time
    Work at office
    Local area
    Remote work
    Relocation
    Flexible hours
    Shift work

    Health Research

    Albany, NY
    1 day ago
  • $46.95k - $65.73k

    Department/Unit HBD - Pediatric Surgery Work Shift Day (United States of America) Salary Range $46,947.00 - $65,726.00 Greet patients in a prompt, courteous and professional manner. Interact with a diverse patient population. Initiate surgical booking process as instructed...
    Work at office
    Shift work

    albanymed

    Albany, NY
    1 day ago
  • This position works closely with commercial paint customers to determine their needs, answer their questions about Sherwin-Williams products, and recommend the right solutions. Wholesale Product Specialists are also expected to promptly resolve any customer concerns and...
    Contract work
    For contractors
    Work experience placement
    Local area
    Flexible hours
    Afternoon shift

    Sherwin-Williams

    Menands, NY
    10 hours ago
  •  ...support patient care delivery and optimize the use of clinical and administrative resources. The Scheduler 2 collaborates closely with...  ...or healthcare administration. Demonstrated ability to use data analytics tools to improve scheduling efficiency. Bilingual... 
    Full time

    Allied Digestive Health

    Albany, NY
    2 days ago
  •  ...CLASSIFICATION PURPOSE The purpose of the Program Administrator is to perform direct and indirect supervisory functions and organize and directs the development, planning, implementation, and monitoring of various client service programs. JOB DUTIES Supervises and assigns... 
    Work at office
    Local area
    Monday to Friday
    Flexible hours

    Miami County, Inc. Defunct

    Albany, NY
    4 days ago
  • $17.75 per hour

     ...VUE provides a full suite of services from test development to data management and delivers exams through the world’s most...  ...start or grow your career, we are now hiring for a part-time Test Administrator to join our team in Albany, NY (94 New Karner Rd, Suite 207) .... 
    Hourly pay
    Temporary work
    Part time
    Work at office
    Immediate start
    Flexible hours
    Shift work

    Pearson

    Albany, NY
    4 days ago
  •  .... Department: Technology Support. CGS is seeking a Relativity Administrator to join our team supporting the legal organization within a large...  ...‑issued security clearance. Comprehensive understanding of data management, Office 365, and cloud environments. Our Commitment... 
    Full time
    Work at office
    Remote work
    Flexible hours

    CGS Federal (Contact Government Services)

    Albany, NY
    1 day ago
  •  ...Description Job Description Senior E-Discovery Application Administrator II Employment Type: Full-Time, Experienced Department:...  ...code. -         Test, debug, and refine programs to process data in accordance with written specifications. -         Revise... 
    Full time
    Work at office
    Flexible hours

    Contact Government Services, LLC

    Albany, NY
    29 days ago
  •  ...HBITS: HBITS-08-14953 Expert, Database Architect 30 month contract Interview: Virtual Interview Work model: 50% telecommuting...  ...Provides expert-level design and implementation of automation and data processing solutions using RPD, RPA or comparable enterprise... 
    Contract work
    Work at office
    Remote work

    MVP Consulting Inc

    Albany, NY
    3 days ago
  •  ...yourself looking for a fulfilling career , the Branch Office Administrator (BOA) role may be the right opportunity for you. BOAs team up...  ...and Citizenship Report. ¹Fortune 500, published June 2024, data as of December 2023. Compensation provided for using, not obtaining... 
    Full time
    Temporary work
    Work at office
    Home office
    Flexible hours

    Edward Jones

    Troy, NY
    10 hours ago
  • As a Postal Service Clerk, you will be responsible for managing mailroom operations and shipping tasks, including: sort and distribute incoming mail. process outgoing mail and packages. operate mailroom equipment such as postage meters. assist with shipping and tracking...

    TradeJobsWorkforce

    Albany, NY
    1 day ago
  • The Customer Service Associate is responsible for delivering products to customers from Sherwin-Williams branches using Company vans or pick-up trucks. The Customer Service Associate ensures deliveries are complete, packed correctly, and safely delivered to the correct...
    Contract work
    Part time
    For contractors
    Work experience placement
    Local area
    Monday to Friday

    Sherwin-Williams

    Albany, NY
    10 hours ago
  • Job TitleCommunity Neurology CoordinatorJob DescriptionRegister patients, update insurance information, schedule visits, and other duties as assigned to coordinate patient appointment scheduling. Interact with a diverse patient population. Utilize the electronic medical...
    Work at office

    Albany Medical Center

    Albany, NY
    5 days ago
  • $50k - $75k

     ...As a Service Advisor you will primarily be responsible for initiating and processing requests for repair services and providing administrative support to the Service Department as well as keep customers apprised of work progress. What You’ll Do: Determine specialized... 
    Full time
    Part time
    Local area

    Camping World Holdings, Inc.

    Albany, NY
    5 days ago
  • Dealership: L0430 Suburban Subaru Suburban Subaru NOW HIRING Service Advisors! If you’re looking for a fast-paced, challenging, and lucrative role for the next step in your career, this is a perfect fit for you! As one of more than 300 Lithia & Driveway Dealerships nationwide...
    Temporary work
    Immediate start

    Lithia & Driveway

    Albany, NY
    5 days ago
  •  ...Coordinate/direct instruction in assigned courses including preparation of course syllabus, course LMS site, exam creation and administration, reporting of student performance, and analysis of assessments.Perform student advisement and academic counseling.Assist the program... 
    Full time
    Immediate start
    Monday to Friday

    Albany College of Pharmacy

    Albany, NY
    5 days ago
  • The Administrator on Duty (AOD) is responsible for monitoring safety and procedures within the facility, overseeing and providing support...  ...follow up plans, and reducing future risk and program outcome data.Partners with the facility’s medical and case management staff... 
    For contractors
    Work at office
    Local area
    Flexible hours
    Afternoon shift

    TOGETHER for Youth

    Albany, NY
    1 day ago
  • $36.51 per hour

    Fitness Test Administrator (PRN) - (8532) Cape Fox Concentric Methods is accepting resumes for a Fitness Test Administrator (PRN) to execute...  ...standards and counting rules; record official times. Enter data into the secure field app; reconcile discrepancies with the Site... 
    Hourly pay
    Relief
    Local area

    Cape Fox Corporation

    Albany, NY
    10 hours ago
  •  ...Duration: 30 Months Client: State of NY Job Title: Database Architect - Expert Description Analyze business processes and system workflows...  ..., develop, and implement RPD-based automation solutions for data ingestion, transformation, and system integration Build and... 
    Local area

    i-Link Solutions

    Albany, NY
    10 hours ago
  • $70.35k - $196k

     ...leaders in helping drive that change, with strong ecosystem relationships. We combine our strength in technology and leadership in cloud, data and AI with unmatched industry experience, functional expertise and global delivery capability. Our broad range of services,... 
    Full time
    Work experience placement
    Live in
    Work at office
    Local area

    Accenture

    Albany, NY
    10 hours ago
  •  ...leading tech consulting firm in Albany, NY, seeks a Senior Database Administrator to lead database design and management for critical systems....  ...tuning and high-availability strategy, ensuring resilient data services. Candidates should have significant experience with database... 

    ASM Research, An Accenture Federal Services Company

    Albany, NY
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Snowflake Data Architect and Administrator. Be the first to apply!