Match score not available

Software Architect - Highly Skilled Software Architect - Highly Skilled

72% Flex

Remote:

Full Remote

Experience:

Mid-level (2-5 years)

Work from:

New York (USA)

Offer summary

Qualifications:

5+ years experience in data modeling/architecture, 3-4 years working with Snowflake Cloud, Expertise in Snowflake metadata, features, and integrations, Hands-on experience with Snowflake administrative functions, security, and GIT development, Experience with BI tools integration and high volume data processing in cloud technologies.

Key responsabilities:

Design end-to-end data analytics architecture for Snowflake
Optimize Snowflake at warehouse and database levels
Deploy Snowflake environments; monitor data shares and pipelines
Implement cloud management frameworks for Snowflake projects
Communicate trends, issues, and optimization techniques to leadership

US Tech Solutions Human Resources, Staffing & Recruiting Large https://www.ustechsolutions.com/

1001 - 5000 Employees

See more US Tech Solutions offers

Job description

Your missions

Note: looking for a more hands on system admin/architect with in depth knowledge of Snowflake data cloud (new and advanced features like Iceberg, Git & CI/CD practices, security and authentications etc.) and integrations with cloud providers (aws, azure & gcp). Flexible with working hours - 7-3pm ET as long as they put in 8hr/day.
Responsibilities:

Responsible for end-to-end data analytics design and architecture for Snowflake
Work on Data Modelling for Snowflake analytic applications
Work on Snowflake optimizations at warehouse, database level
Setup, configure and deploy Snowflake application environments (Databases, Warehouses, Roles, Users, Masking policies etc.)
Setup and monitor data shares, snowpipes for Snowflake projects
Implement Snowflake Cloud management frameworks that includes but is not limited to monitoring, alerting, and governance model, budgets and change management, cost optimization lifecycle, show-backs, and charge-backs
Work on Cloud Usage reporting to measure cloud cost related insights, metrics and KPIs
Communicate with leadership on Cloud usage trends, issues, and optimization techniques
Ability to write complex SQL to analyze and troubleshoot data anomalies
Participate in Snowflake forecasting process; build and improve forecasts and explore trends in cloud spend using internal and external tools
Work on building Snowflake Governance policies, standards, and documentation
Address technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of Snowflake
Provide guidance and support to internal and federated Solution Architects to ensure compliance to expected technical and quality standards

Qualifications

5+ years hands-on data modelling/architecture experience (logical & physical modeling with 3NF & Star Schema) with at least 3-4 years working experience with Snowflake Coud platform
Detailed understanding of Snowflake metadata structures for FinOps & governance reporting - account_usage, organization_usage schemas
Detailed understanding of Snowflake features for enabling governance e.g. Resource Tagging, Budgets, Alerting & Notification features etc.
Experience with Snowflake administrative functions around user, role and access management (RBAC), masking policies etc.
Experience with Snowflake Data loading & unloading best practices, Data Sharing, Replication, Cloning, Data Exchange, BC & DR features
Experience with Snowflake security features around authentication mechanisms (key pair, Oauth, MFA), authentication ploicies
Experience with GIT based development, deployment, and support of data processes and procedures
Detailed understanding of Snowflake integrations (storage & security) with cloud platforms like AWS, Azure & GCP
Detailed understanding of Snowflake features and integrations with Iceberg table format
Experience with high volume data processing using Snowflake, Redshift, Databricks, and other relevant cloud technologies and designing solutions for reliability and performance at scale.
Experience with BI tool and Database integration (e.g. Snowflake or other cloud db with Tableau, PowerBI, Google Looker Studio, Microstrategy etc.)
Effective analytical, troubleshooting, and problem-solving skills
Experience working cross-functionally to roll out and manage large initiatives
Advanced Microsoft Excel, Outlook, Word, PowerPoint documentation and presentation skills

About US Tech Solutions:
US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit www.ustechsolutions.com.

US Tech Solutions 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, disability, or status as a protected veteran.