More jobs:
Snowflake Data Architect and Administrator
Job in
City of Albany, Albany, Albany County, New York, 12201, USA
Listed on 2026-09-09
Listing for:
Sligo Software Solutions Inc.
Full Time
position Listed on 2026-09-09
Job specializations:
-
IT/Tech
Database Administrator, Data Warehousing, Data Engineering, Information Security & Data Protection
Job Description & How to Apply Below
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.
DescriptionDatabase 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.
- 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.
- 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.)
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×