Sr. Data Engineer (SnowSQL/T-SQL, PL/pgSQL) - Entertainment and technology

Project Description

You will work on a team of highly motivated and talented individuals that collaborate with organizational leaders, product managers, technical project managers, QA engineers, DevOps engineers, and client service stakeholders across the company to implement new features and products.

If you feel that you can make an impact through innovation and collaboration and come to work with a passion to create amazing applications that wow our clients, this is the role for you.

Responsibilities

• Analyzes and evaluates reported data-related problems, take responsibility/ownership, and prevent recurrence

• Develops solutions on Snowflake/Redshift, Postgres, and Oracle Develops, implements, administers and maintains logical and physical data models to support business, performance, reliability, and security requirements

• Develops, tests, implements, troubleshoots, and supports data extraction, transformation, and loading processes

• Maintains database performance by calculating optimum values for database parameters; implements new releases; completes maintenance requirements

• Tunes data warehouse and other database systems for optimal performance and reliability

• Develops, implements, administers and maintains operational automation scriptin

Requirements

• Advanced knowledge of Snowflake (SnowSQL/T-SQL), PostgreSQL (PL/pgSQL), Oracle (PL/SQL) and/or Redshift - current networking concepts, best practices, and database design and development

• Experience designing and developing data integration solutions using ETL tools such as dbt and SSIS

• Experience with performance tuning and fine tuning the warehouses

• Experience with enforcing data integrity guardrails and writing automated scripts to ensure data cleansing based on unique business logic 

• Understanding data pipelines and modern ways of automating data pipeline

Rewards

• Payment in USD.
• Free credentials for e-learning platforms.
• Remote workshops & activities.