Snowflake Developer

Brite Systems Incorporated

Washington, DC, United States

about 1 month ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

3 years minimum

Compensation

$116,758.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

Airflow Amazon Web Services Microsoft Azure Cloud Database Computer Programming Information Engineering Extract Transform Load (ETL) Data Security Data Sharing Data Warehousing Revision Control Systems JSON

+25 more

Python (Programming Language) Query Optimization Role-Based Access Control Power BI Shell Script SQL Stored Procedures SQL Databases Tableau (Software) Talend Parquet Scripting Freeform SQL Cloud Platform System Azure Data Factory Informatica Powercenter Snowflake Git Data Lakes Semi-structured Data Avro Star Schema Stream Processing Looker Analytics Software Version Control Data Pipelines

Job description

We are seeking an experienced Snowflake Developer with around 6 years of experience in data engineering, data warehousing, and cloud-based data solutions. The ideal candidate will design, develop, optimize, and maintain scalable data pipelines and solutions using the Snowflake platform., * Design and implement data models (Star/Snowflake schemas) in Snowflake.

Develop and optimize ETL/ELT pipelines using tools like Snowpipe, Streams, Tasks, or external ETL tools (Informatica, Talend, Azure Data Factory, etc.).
Load and transform structured and semi-structured data (JSON, Parquet, Avro) into Snowflake.
Write advanced SQL queries, stored procedures, and Snowflake scripting.
Optimize Snowflake performance (query tuning, clustering, partitioning, warehouse sizing).
Implement data security and governance (RBAC, masking, encryption).
Integrate Snowflake with cloud platforms like AWS / Azure / GCP.
Work with BI tools (Power BI, Tableau, Looker) for reporting and analytics.
Monitor and troubleshoot data pipelines and warehouse performance.
Collaborate with business analysts, data scientists, and stakeholders.

Requirements

Do you have experience in Version control systems?, * Strong experience in Snowflake Cloud Data Platform

Proficiency in SQL (advanced level)
Hands-on with data warehousing concepts
ETL/ELT development experience
Knowledge of Snowflake features:
Snowpipe
Streams & Tasks
Time Travel & Zero Copy Cloning
Data Sharing

Programming & Tools

Python / Shell scripting (good to have)
Experience with ETL tools:
Informatica / Talend / DBT / ADF / Airflow
Version control tools (Git)

Soft Skills

Strong problem-solving skills
Good communication and collaboration
Ability to handle multiple priorities, * Certification in Snowflake (SnowPro Core / Advanced)
Experience with Data Lake and Data Mesh architecture
Exposure to CI/CD pipelines in data engineering
Knowledge of real-time data processing

About the company

Brite Systems is an Information Technology company specializing in consulting and software development. We have successfully implemented solutions for the public and private sector since 2006.

We focus on providing our clients with simplified, innovative technology solutions to improve and streamline the user’s experience. Brite Systems confidently bring the right people, customized approaches, and successful track records to each opportunity. If you are looking to be part of a strong, collaborative culture, Brite Systems is the place for you to grow your career.