Staff Data Engineer

1 Month ago • 10 Years +

Job Summary

Job Description

As the hands-on Staff Database Engineer, you will design, develop, and maintain data systems and architectures to collect, store, process, and analyze large volumes of data. You will be building data pipelines, optimizing data models, and ensuring data quality and security. This role involves collaborating with cross-functional teams to meet business objectives and stay updated with emerging technologies and industry best practices. Responsibilities include expertise in Snowflake, data modeling, ELT processes, DBT CLI, and complex SQL processes.
Must have:
  • Extensive experience with Snowflake, including Snow SQL CLI.
  • In-depth expertise in Snowflake data modeling and ELT processes.
  • Strong background in DBT CLI, DBT Cloud, and GitHub.
  • Hands-on approach in designing and supporting data pipelines.
  • Advance SQL knowledge and experience in complex query writing.
  • Collaborate closely with cross-functional teams.
  • Hands-on role in conducting data modeling and ETL development.
  • Develop and implement comprehensive data governance policies.
  • Independently conceptualize and develop ETL and reporting solutions.
  • Create comprehensive documentation for database objects.
  • Troubleshoot and resolve production support issues.
Good to have:
  • Familiarity with big data, data warehouse architecture.
  • Strong understanding of database management systems.
  • Expertise in Snowflake architecture, administration, and performance tuning.
  • Experience with Snowflake security configurations and access controls.
  • Knowledge of Snowflake's data sharing and replication features.
  • Experience with ETL (Extract, Transform, Load) tools and processes.
  • Ability to translate business requirements into EDW solutions.
  • Streaming Technologies like AWS Kinesis
  • Experience in the Finance industry

Job Details

As the hands-on Staff Database Engineer for Clearwater Analytics, you will play a crucial role in designs, develops, and maintains data systems and architectures to collect, store, process, and analyse large volumes of data. You will be building data pipelines, optimize data models, and ensure data quality and security. You will be collaborating with cross-functional teams to meet business objectives and stay updated with emerging technologies and industry best practices.

 

Responsibilities and Duties:

  • Extensive experience with Snowflake, including proficiency in Snow SQL CLI, Snowpipe, creating custom functions, developing Snowflake stored procedures, schema modeling, and performance tuning.

  • In-depth expertise in Snowflake data modeling and ELT processes using Snowflake SQL, as well as implementing complex stored procedures and leveraging Snowflake Task Orchestration for advanced data workflows.

  • Strong background in DBT CLI, DBT Cloud, and GitHub version control, with the ability to design and develop complex SQL processes and ELT pipelines.

  • Take a hands-on approach in designing, developing, and supporting low-latency data pipelines, prioritizing data quality, accuracy, reliability, and efficiency

  • Advance SQL knowledge and hands-on experience in complex query writing using Analytical functions, Troubleshooting, problem-solving, and performance tuning of SQL queries accessing data warehouse as well as Strong knowledge of stored procedures.

  • Collaborate closely with cross-functional teams including, Enterprise Architects, Business Analysts, Product Owners, Solution Architects actively engaging in gathering comprehensive business requirements and translate these requirements into scalable data cloud and Enterprise Data Warehouse (EDW) solutions that precisely align with organizational needs

  • Play a hands-on role in conducting data modeling, ETL (Extract, Transform, Load) development, and data integration processes across all Snowflake environments.

  • Develop and implement comprehensive data governance policies and procedures to fortify the accuracy, security, and compliance of Snowflake data assets across all environments.

  • Capable of independently conceptualizing and developing innovative ETL and reporting solutions, driving them through to successful completion.

  • Create comprehensive documentation for database objects and structures to ensure clarity and consistency.

  • Troubleshoot and resolve production support issues post-deployment, providing effective solutions as needed.

  • Devise and sustain comprehensive data dictionaries, metadata repositories, and documentation to bolster governance and facilitate usage across all Snowflake environments.

  • Remain abreast of the latest industry trends and best practices, actively sharing knowledge and encouraging the team to continuously enhance their skills.

  • Continuously monitor the performance and usage metrics of Snowflake database and Enterprise Data Warehouse (EDW), conducting frequent performance reviews and implementing targeted optimization efforts

 

Skills Required:

  • Familiarity with big data, data warehouse architecture and design principles

  • Strong understanding of database management systems, data modeling techniques, data profiling and data cleansing techniques

  • Expertise in Snowflake architecture, administration, and performance tuning.

  • Experience with Snowflake security configurations and access controls.

  • Knowledge of Snowflake's data sharing and replication features.

  • Proficiency in SQL for data querying, manipulation, and analysis.

  • Experience with ETL (Extract, Transform, Load) tools and processes.

  • Ability to translate business requirements into scalable EDW solutions.

  • Streaming Technologies like AWS Kinesis

 

Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or a related field. 

  • 10 years of hands-on experience in data warehousing, ETL development, and data modeling, with a strong track record of designing and implementing scalable Enterprise Data Warehouse (EDW) solutions.

  • 3+ years of extensive hands-on experience with Snowflake, demonstrating expertise in leveraging its capabilities.

  • Proficiency in SQL and deep knowledge of various database management systems (e.g., Snowflake, Azure, Redshift, Teradata, Oracle, SQL Server).

  • Experience utilizing ETL tools and technologies such as DBT, Informatica ,SSIS, Talend

  • Expertise in data modeling techniques, with a focus on dimensional modeling and star schema design.

  • Familiarity with data governance principles and adeptness in implementing security best practices.

  • Excellent problem-solving and troubleshooting abilities, coupled with a proven track record of diagnosing and resolving complex database issues.

  • Demonstrated leadership and team management skills, with the ability to lead by example and inspire others to strive for excellence.

  • Experience in the Finance industry will be a significant advantage

Similar Jobs

Aristocrat Gaming - Integrations Manager

Aristocrat Gaming

Sofia, Sofia City Province, Bulgaria (Hybrid)
5 Months ago
shyft labs - OMS Lead Engineer

shyft labs

Noida, Uttar Pradesh, India (Hybrid)
1 Month ago
Trend Micro - DevOps Engineer

Trend Micro

Taipei City, Taiwan (On-Site)
1 Week ago
Illuminia - Staff Software Signal Processing Engineer/Scientist

Illuminia

San Diego, California, United States (On-Site)
1 Week ago
AccelData - Lead SDET

AccelData

Bengaluru, Karnataka, India (On-Site)
6 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Virtusa - Automation SDET

Virtusa

Karnataka, India (On-Site)
10 Months ago
QuinStreet - Frontend Developer (VUE)

QuinStreet

Pune, Maharashtra, India (Hybrid)
1 Month ago
N-ix - Middle Node.JS Engineer

N-ix

Colombia (Remote)
1 Month ago
N-ix - Middle Data Engineer

N-ix

Ukraine (Hybrid)
3 Weeks ago
WildBrain - Pipeline TD-Flow

WildBrain

Vancouver, British Columbia, Canada (On-Site)
1 Month ago
Tekion Corp - Principal Data Scientist

Tekion Corp

Pleasanton, California, United States (On-Site)
1 Month ago
Marsh McLennan - Lead Software Engineer

Marsh McLennan

Dublin, California, United States (Hybrid)
3 Days ago
appier - Senior Data Backend Engineer (Ad Cloud)

appier

Taipei City, Taiwan (On-Site)
1 Week ago
Sporty Group - Frontend Engineer

Sporty Group

(On-Site)
11 Months ago
Animoca Brands - Frontend Developer

Animoca Brands

South Korea (Remote)
8 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Noida, Uttar Pradesh, India

Accenture - Business Process Architect

Accenture

Mumbai, Maharashtra, India (On-Site)
3 Days ago
DNEG - Animator (DNEG Animation)

DNEG

India (On-Site)
10 Months ago
Syniverse - Lead Quality Assurance

Syniverse

Bengaluru, Karnataka, India (Hybrid)
1 Month ago
Capgemini - Senior CMDB Developer

Capgemini

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Capgemini - Account Delivery Partner

Capgemini

Pune, Maharashtra, India (On-Site)
1 Month ago
Antarctica Global - Business Development Executive

Antarctica Global

Maharashtra, India (Hybrid)
2 Months ago
Capgemini - Administrative Coordinator

Capgemini

Kolkata, West Bengal, India (On-Site)
1 Week ago
bounteous - Associate, Graphic Designer

bounteous

Chennai, Tamil Nadu, India (Hybrid)
2 Weeks ago
Capgemini - Reltio - C2

Capgemini

Bhubaneswar, Odisha, India (On-Site)
2 Months ago
AI Dash - Technical Project Manager

AI Dash

Bengaluru, Karnataka, India (Hybrid)
3 Weeks ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud-native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single-instance, multi-tenant architecture delivers real-time data and AI-driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally.

Boise, Idaho, United States (On-Site)

Noida, Uttar Pradesh, India (On-Site)

Noida, Uttar Pradesh, India (On-Site)

Noida, Uttar Pradesh, India (On-Site)

New York, United States (On-Site)

Boise, Idaho, United States (On-Site)

New York, United States (Hybrid)

Edinburgh, Scotland, United Kingdom (On-Site)

San Jose, California, United States (On-Site)

View All Jobs

Get notified when new jobs are added by Clear Watery Analytics

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug