Sr Data Engineer (Snowflake)

Company Description

It all started in sunny San Diego, California in 2004 when a visionary engineer, Fred Luddy, saw the potential to transform how we work. Fast forward to today — ServiceNow stands as a global market leader, bringing innovative AI-enhanced technology to over 8,100 customers, including 85% of the Fortune 500®. Our intelligent cloud-based platform seamlessly connects people, systems, and processes to empower organizations to find smarter, faster, and better ways to work. But this is just the beginning of our journey. Join us as we pursue our purpose to make the world work better for everyone.

Job Description

What you get to do in this role:

In this role, you will leverage your prior experience and industry-standard best practices to analyze cross-functional data and provide insights to business teams with key responsibilities in below area

1. Data Analysis & Design
   1. Leverage prior experience and industry-standard best practices to analyze cross-functional data and provide insights to business teams.
   2. Assist stakeholders with data analysis, design data structures like Tables, Views, and procedures in Snowflake to meet business needs.
2. Implementation & Processes:
   1. Implement snapshot processes, data refresh schedules, and exception handling procedures as necessary.
   2. Define required data integration requirements between various systems and work with an extended team to get them created.
   3. Follow all documented architecture, design, and deployment processes to ensure compliance with policies.
3. Subject Matter Expertise
   1. Develop functional subject matter expertise within various areas of enterprise business processes.
4. Collaboration & Solution Development
   1. Collaborate with teams to translate business requirements and get appropriate data solutions developed to meet the business need.
   2. Partner with the Global BI team to help implement solutions for end-user adoption.

Qualifications

To be successful in this role you have:

• Educational Background: Bachelor’s degree or equivalent in Computer Science, Computer Engineering, Information Systems, or similar.
• Experience: 5+ years of documented experience in writing strong SQL and PLSQL in data warehouse technologies with a minimum of 5+ years in Snowflake.
• Deep Knowledge on Clustering and Partitioning, Materialized Views, Time Travel and Fail-safe,Data Sharing and Data Marketplace, Streams and Tasks

Query Optimization Techniques, Snowpipe, Advanced Data Security Features, Advanced User Management and Role-Based Access Control (RBAC)

Advanced API and Integration Techniques [Apache Kafka, ETL tools (e.g., Matillion, Fivetran), and BI tools using Snowflake's native connectors and third-party APIs.]

• Cloud Awareness -  Implement and manage data solutions on Cloud Platforms, primarily on the Microsoft Azure cloud platform, including cloud data pipeline/near-real-time/batch loads/flow orchestration.
• Data Observability to understand the health and performance of data pipelines in real-time.
• Strong in building data pipelines, database design & development, writing optimized queries, handling Facts and dimension data effectively.
• Experience in ad-hoc data analysis and solution design
• Adhere to framework standards on scalability, restart ability, error logging, and manageability
• Strong in Star Schema / Dimensional Modelling, able to implement a solution, and convert existing logical to physical data models.
• GenAI Readiness -  Awareness of GenAI and Models, Use  Synthetic Data, and relevant data structures to train models.
• Strong understanding of ML Platforms ( Azure / Databricks)
• Ability to write complex SQL scripts, perform query tuning, and benchmarking.
• Proficiency in at least one relevant programming language (e.g., Python), including SQL skills.
• Excellent communication skills, with the ability to work individually and in a broader geographically dispersed team.

JV20

Not sure if you meet every qualification? We still encourage you to apply! We value inclusivity, welcoming candidates from diverse backgrounds, including non-traditional paths. Unique experiences enrich our team, and the willingness to dream big makes you an exceptional candidate!

Additional Information

Work Personas 

We approach our distributed world of work with flexibility and trust. Work personas (flexible, remote, or required in office) are categories that are assigned to ServiceNow employees depending on the nature of their work. Learn more here.

Equal Opportunity Employer 

ServiceNow is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, national origin or nationality, ancestry, age, disability, gender identity or expression, marital status, veteran status, or any other category protected by law. In addition, all qualified applicants with arrest or conviction records will be considered for employment in accordance with legal requirements. 

Accommodations 

We strive to create an accessible and inclusive experience for all candidates. If you require a reasonable accommodation to complete any part of the application process, or are unable to use this online application and need an alternative method to apply, please contact talent.acquisition@servicenow.com for assistance. 

Export Control Regulations 

For positions requiring access to controlled technology subject to export control regulations, including the U.S. Export Administration Regulations (EAR), ServiceNow may be required to obtain export control approval from government authorities for certain individuals. All employment is contingent upon ServiceNow obtaining any export license or other approval that may be required by relevant export control authorities. 

From Fortune. ©2024 Fortune Media IP Limited. All rights reserved. Used under license.