Job description

Description: Client: SEI Investments Company Location: Oaks, PA (Hybrid- 3days onsite in a week) Note: Please look for someone have worked in past Denodo Migration. Responsiblities: Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake. Optimize data models, design star/snowflake schemas, manage warehouse performance, and implement clustering/materialized views. Create scalable ELT/ETL pipelines to ingest and transform data from diverse sources.Write modular, testable SQL code using version control and manage DBT project structures. Implement data quality checks, automated tests, anomaly detection, and data security, including RBAC, masking, and row-level access in Snowflake. Basic Qualifications: (what are the skills required to this job with minimum years of experience on each) 5+ years of experience with DBT and Hands-on experience developing with dbt. 3+ years of experience with Python development 3+ years of experience with Airflow development3+ years of experience with Snowflake and Strong SQL proficiency. Good handle on Datawarehouse concepts. Education: Bachelor’s degree in Computer Science, Data Engineering, or a related field Nice to Have; (But not a must) Cloud Platforms: Experience with AWS, GCP, or Azure environments.

Requirements

Must-haves

Client: SEI Investments Company
Location: Oaks, PA (Hybrid- 3days onsite in a week)
Note: Please look for someone have worked in past Denodo Migration.
Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
Optimize data models, design star/snowflake schemas, manage warehouse performance, and implement clustering/materialized views.
Create scalable ELT/ETL pipelines to ingest and transform data from diverse sources.Write modular, testable SQL code using version control and manage DBT project structures.
Implement data quality checks, automated tests, anomaly detection, and data security, including RBAC, masking, and row-level access in Snowflake.
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
5+ years of experience with DBT and Hands-on experience developing with dbt.
3+ years of experience with Python development
3+ years of experience with Airflow development3+ years of experience with Snowflake and Strong SQL proficiency.
Good handle on Datawarehouse concepts.
Education: Bachelor’s degree in Computer Science, Data Engineering, or a related field
Cloud Platforms: Experience with AWS, GCP, or Azure environments.

Nice-to-haves

Nice to Have; (But not a must)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonawsgcpazure

Platform: jobdiva
Effort: medium