Senior Snowflake Data Architect

Join New Era Technology, where People First is at the heart of everything we do. With a global team of over 4,500 professionals, we’re committed to creating a workplace where everyone feels valued, empowered, and inspired to grow. Our mission is to securely connect people, places, and information with end-to-end technology solutions at scale.At New Era, you’ll join a team-oriented culture that prioritizes your personal and professional development. Work alongside industry-certified experts, access continuous training, and enjoy competitive benefits. Driven by values like Community, Integrity, Agility, and Commitment, we nurture our people to deliver exceptional customer service.If you want to make an impact in a supportive, growth-oriented environment, New Era is the place for you. Apply today and help us shape the future of work—together.

Job Description:

We are seeking a skilled Snowflake expert and data architect to assist in the performance monitoring, tuning, and operationalization of its Snowflake-based Enterprise Data Management platform.

We are looking for a person with the following expertise:

• Deep knowledge of implementing and performance tuning Dynamic Tables, Streams, and Tasks.
• Knowledge of performance monitoring in Snowflake, ability to identify queries in need of performance improvement and the mechanism to optimize performance and cost of compute in Snowflake.
  • Includes query optimization techniques
  • Resource monitoring
  • Warehouse sizing
• Ability to develop and communicate key guidelines to the individuals’ creating processes in Snowflake. Must be able to monitor to ensure guidelines are being followed.
• Strong data engineering experience to help optimize data load and unload processes for performance and cost.
• Ability to review data architecture and provide performance and cost optimization direction to help maximize our Snowflake spend.
• Ability to mentor junior data engineers in Snowflake and data architecture principles and practices.
• Proven capability to automate performance and cost optimization checks and workflows.
• Data modeling capabilities.
• Data Transformation, ETL/ELT
• Proven capability to optimize a process for business effectiveness.
• Experience with Data Quality and Data Governance in Snowflake.
• Ability to capture and understand business requirements. Ability to facilitate interactions in order to gain a thorough understanding of core business operations.
• Some knowledge of healthcare payer data is preferred. Knowledge of healthcare data is minimum.

Skills:

• Strong Snowflake architectural experience
• Snowflake SQL, MSSQL T-SQL, Python, SSIS, PowerShell
• Strong Snowflake development experience
  • Basic objects, Materialized Views, Dynamic Tables, Streams, UDFs, Stored Procedures
• Strong understanding of Snowflake metadata
• Compute and Load/Unload optimization (both performance and cost).
• Data Modeling
• ETL/ELT, Data Transformation
• Modern Data Transformation tools: FiveTran, Matillion, CData, DBT, etc.
• Strong communication skills. Ability to simplify and explain complex topics to both developers and business folks.
• DevOps/DataOps and CI/CD for Snowflake
• Containers in Snowflake
• PowerBI, Snowflake Dashboards, Streamlit

New Era Technology, Inc., and its subsidiaries (“New Era” “we”, “us”, or “our”) in its operating regions worldwide are committed to respecting your privacy and recognize the need for appropriate protection and management of any Personal Data that you may provide us. In this, we are also committed to providing you with a positive experience on our websites and while using our products, services and solutions (“Solutions”).View our Privacy Policy here https://www.neweratech.com/us/privacy-policy/