Snowflake Administrator - Hybrid in Boston - US Citizenship or GC Required

Job Posted 24 Days Ago Posted 24 Days Ago
Be an Early Applicant
Boston, MA
Junior
Information Technology • Software
The Role
The Snowflake Administrator will manage and maintain the Snowflake data warehouse environment, focusing on setup, performance tuning, user management, data integration, and security. The role requires collaboration with data professionals and continuous improvement recommendations based on Snowflake best practices.
Summary Generated by Built In

This is a hybrid position that will be a mix of remote and onsite in Boston, MA 
Candidates must be local to MA, NH or RI.
US Citizenship or a Green Card is required. 
Starts out as a 12 month contract. Multiple extensions are anticipated.
Summary:
The Client is seeking a highly skilled and motivated Snowflake Administrator to join our team. The ideal candidate will be responsible for the administration, configuration, and maintenance of our Snowflake data warehouse environment. This role requires a deep understanding of Snowflake's features and best practices, as well as strong problem-solving skills and the ability to work collaboratively with cross-functional teams.
Key Responsibilities:

  • Snowflake Environment Management: Administer and manage Snowflake data warehouse environments, including setup, configuration, monitoring, and optimization.
  • Performance Tuning: Monitor and optimize performance, including query performance, resource utilization, and storage management.
  • User and Access Management: Manage user access, roles, and permissions to ensure data security and compliance with organizational policies.
  • Data Integration: Support and manage data integration processes, including data loading, transformation, and extraction.
  • Backup and Recovery: Implement and oversee backup and recovery strategies to ensure data integrity and availability.
  • Troubleshooting and Support: Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization.
  • Documentation and Reporting: Maintain detailed documentation of system configurations, procedures, and changes. Generate and deliver regular reports on system performance and usage.
  • Collaboration: Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal performance of the Snowflake environment.
  • Best Practices: Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performance.
  • Security: Ensure platform is up to date on System patches. Monitor, apply and test product security updates

Qualifications:
Experience: 2 years of hands-on experience in managing and administering Snowflake environments. Experience with other cloud-based data platforms is a plus.
Required Skills:

  • Strong proficiency in Snowflake architecture, features, and capabilities.
  • Knowledge of SQL and Snowflake-specific query optimization.
  • Experience with ETL tools and data integration processes.
  • 2 years of hands-on experience as a Snowflake Administrator
  • Ability to identify and drive continuous improvements
  • Strong problem solving and analytical skills
  • Strong SQL skills
  • Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.
  • Experience in scripting languages such as PowerShell and Python
  • Experience working in AWS cloud environments
  • Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus
  • Experience working with Power BI and other BI, data visualization, and reporting tools
  • Strong Database design and data modelling experience
  • Business requirement gathering and aligning to solutions delivery
  • Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus
  • Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud based and on-premises technologies

Analytical Skills: Excellent problem-solving and analytical skills with a strong attention to detail.

  • Communication: Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders.
  • Teamwork: Ability to work independently and collaboratively in a fast-paced environment.

Preferred Skills:
 Snowflake certification (e.g., SnowPro Core or Advanced Certification).
• Experience with data visualization tools (e.g., Power BI).
• Knowledge of technical areas such as T-SQL, DevOps, and scripting

Top Skills

Powershell
Python
Snowflake
SQL
The Company
HQ: Baltimore, MD
10 Employees
On-site Workplace
Year Founded: 2010

What We Do

Booker DiMaio, King of Global Solutions, is an SBA 8(a) small business and minority-owned engineering & software modernization firm in Maryland leading the IT industry with proven performance and innovative design, development, and integration services. We lead agile-based digital transformations delivering sleek, intuitive, user-focused solutions.

CORE COMPETENCIES:

TECHNOLOGY: Cloud Computing, Big Data Visualization, Analytics, DevSecOps, Cybersecurity, Health IT, IT Modernization, Infrastructure As a Service, Integration & Sustainment, Software Engineering, System Architecture

OPERATIONS: Staff Augmentation, Program Management, Telecommunications, User Experience Design, Administrative, Contact Center Support, Security Operations Center, Technology Transformation, Technology Advisory, Research & Development, Rapid Prototyping

TECHNOLOGY PORTFOLIO:
Booker DiMaio provides access to a suite of technology solutions through our reseller network, delivering added value to national security missions and government transformation for defense, intelligence, and civilian customers. A few of our notable partners are AWS, Microsoft Azure, FedRAMP Cloud Solutions, SecuLore

DIFFERENTIATORS:
SPECIALIZED - Our team is specially hired for each project and has a combined 90+ years of specialized industry experience.

DRIVEN - We deliver solutions that are based on an in-depth understanding of the industry and commitment to improving user experiences.

COMPREHENSIVE - We offer a comprehensive suite of end-to-end Big Data solutions, including cloud platforms, software engineering, DevSecOps, cybersecurity, and much more.

COMPLIANT - Our tailored solutions facilitate compliance with CMMC, NIST, and other strict regulatory requirements.

EFFECTIVE - Our cross-functional team of industry experts will carry your mission-critical operations to success, increasing digital proficiency across the globe with modern software and technology solutions.

Contact.us@bookerdimaio.com

Similar Jobs

PwC Logo PwC

Google PDM/PLM Consultant - Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Remote
Hybrid
69 Locations
364000 Employees
100K-232K Annually

MassMutual Logo MassMutual

Investment Vendor Oversight Consultant

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hybrid
Boston, MA, USA
6000 Employees
113K-148K Annually

Akeneo Logo Akeneo

Senior Revenue Systems Administrator

eCommerce • Information Technology • Marketing Tech • Software
Hybrid
Boston, MA, USA
430 Employees

ZS Logo ZS

Business Technology Solutions Consultant - MDM

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
5 Locations
13000 Employees
155K-171K Annually

Similar Companies Hiring

Stepful Thumbnail
Software • Healthtech • Edtech • Artificial Intelligence
New York, New York
60 Employees
HERE Technologies Thumbnail
Software • Logistics • Internet of Things • Information Technology • Computer Vision • Automotive • Artificial Intelligence
Amsterdam, NL
6000 Employees
True Anomaly Thumbnail
Software • Machine Learning • Hardware • Defense • Artificial Intelligence • Aerospace
Colorado Springs, CO
131 Employees
By clicking Apply you agree to share your profile information with the hiring company.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account