Job Information
US Tech Solutions Software Architect - Highly Skilled Software Architect - Highly Skilled in New York, New York
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 - accountusage, organizationusage 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.
US Tech Solutions
- US Tech Solutions Jobs