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...SuggestedLocal area
- ...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...SuggestedHourly payContract work
- 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
$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...SuggestedFull timeFor contractorsFlexible hours- ...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...SuggestedFull timeContract workLocal area
- ...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 contractTemporary workH1bLocal areaImmediate start
- ...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
- ...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 timeWork at office
- ...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
- ...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 timeContract workPart timeWork at officeLocal areaRemote workRelocationFlexible hoursShift work
$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 officeShift work- 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 workFor contractorsWork experience placementLocal areaFlexible hoursAfternoon shift
- ...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
- ...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 officeLocal areaMonday to FridayFlexible hours
$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 payTemporary workPart timeWork at officeImmediate startFlexible hoursShift work- .... 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 timeWork at officeRemote workFlexible hours
- ...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 timeWork at officeFlexible hours
- ...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 workWork at officeRemote work
- ...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 timeTemporary workWork at officeHome officeFlexible hours
- 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...
- 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 workPart timeFor contractorsWork experience placementLocal areaMonday to Friday
- 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
$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 timePart timeLocal area- 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 workImmediate start
- ...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 timeImmediate startMonday to Friday
- 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 contractorsWork at officeLocal areaFlexible hoursAfternoon shift
$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 payReliefLocal area- ...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
$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 timeWork experience placementLive inWork at officeLocal area- ...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...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Snowflake Data Architect and Administrator. Be the first to apply!





