Snowflake Architect

Ampcus Incorporated

Cincinnati, OH

JOB DETAILS
SALARY
$70–$85 Per Hour
SKILLS
Administrative Skills, Agile Programming Methodologies, Amazon Web Services (AWS), Analysis Skills, Automation, Business Services, Capacity Management, Capacity Utilization, Cloud Computing, Consulting, Cost Control, Cryptography, Data Mart, Data Migration, Data Warehousing, Database Administration, Database Replication, DevOps, High Availability, Information/Data Security (InfoSec), Kerberos, Microsoft Access Database, OAuth, OpenID, Operational Support, PCI, Performance Tuning/Optimization, Problem Solving Skills, Production Support, Production Systems, Public Cloud, Python Programming/Scripting Language, Query Analysis, Query Optimization, Relational Databases (RDBMS), Reporting Dashboards, Scripting (Scripting Languages), Security Assertion Markup Language (SAML), Security Auditing, Security Infrastructure, Snowflake Schema, Team Player
LOCATION
Cincinnati, OH
POSTED
4 days ago

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title:Snowflake Architect

Location(s): Cincinnati, OH./ Atlanta, GA. (Hybrid)

Duration: 6 Months Contract (Possibility of extension)

Job Summary:

Work in a globally distributed team to provide a robust enterprise data platform in Snowflake, ensuring optimal performance, security, and efficiency.

Key Responsibilities:

  • Design, optimize, document, and implement operational aspects in supporting the Snowflake cloud data platform, including cost monitoring and optimizations, user security auditing.
  • Implement/support automation for production deployment in Snowflake.
  • Implement Snowflake standards and methodologies for DB security – both infrastructure and app level.
  • Implement/support automation for administering Snowflake - Accounts/Databases and access roles.
  • Implement data sharing/replication – cross cloud/cross region for internal/external clients.
  • Create Snowflake utilization and capacity plan.
  • Propose and implement DB/Snowflake query performance optimizations.
  • Identify system bottlenecks and recommend solutions.
  • Implement Snowflake user/query log analysis and alerts.
  • Implement data encryption/decryption/masking policies to protect PII/PCI data.
  • Work as admin on Snowflake on AWS i.e., Configuration, Data migration and security.

Required Qualifications:

  • Technical expertise in all aspects of Snowflake.
  • Experience in implementing Snowflake external functions.
  • Experience securing sensitive data PII/PCI data in Snowflake.
  • Hands-on experience in administering Snowflake in AWS.
  • Experience with AWS CLI and Networking.
  • Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.).
  • Experience with architecting and maintaining high availability production systems.
  • Experience with developing monitoring architecture and implementing monitoring agents, dashboards, escalations, and alerts.
  • Knowledge of security controls for the public cloud (encryption of data in motion/rest and key management).
  • Demonstrated proficiency of index design, query plan optimization and analysis required.
  • Hands-on experience in administration of relational Databases, Data Warehouse and Data marts.
  • Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools.
  • Experience with Agile and DevOps concepts.
  • Strong development skills in Python or other scripting language.

Added bonus if you have:

  • AWS certification.
  • Snowflake Certifications.
 

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

About the Company

A

Ampcus Incorporated

Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.

Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.

We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted"​ that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.

Industry: Information Technology and Services

Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI

COMPANY SIZE
500 to 999 employees
INDUSTRY
Staffing/Employment Agencies
WEBSITE
http://www.ampcus.com