What are the responsibilities and job description for the Snowflake Data Engineer position at Themesoft Inc.?
Job Role: Snowflake Senior Technical Specialist with SQL, Python, DBT
Location: Jersey City, NJ - Onsite
Hire Type: Contract on W2
Job Summary
The Senior Technical Specialist will be responsible for managing and optimizing Snowflake, DBT, SQL, and Python processes within the organization. They will play a key role in implementing and maintaining efficient data pipelines, ensuring data integrity, and driving data driven decision-making processes.
Key Responsibilities
1. Develop and maintain snowflake data cloud environment, including optimizing database performance and troubleshooting any issues that arise.
2. Design and implement etl processes using dbt to transform and load data into snowflake for analytics and reporting purposes.
3. Write complex sql queries to extract and manipulate data as required by various business units.
4. Utilize python programming language to automate data processes, build data pipelines, and create data visualizations.
5. Collaborate with cross functional teams to understand data requirements and implement solutions that meet business needs.
6. Ensure data security and governance practices are followed in compliance with industry standards and regulations.
Skill Requirements
1. Proficiency in snowflake data platform, including data warehouse design, implementation, and optimization.
2. Experience with dbt (data build tool) for managing data transformations and modeling within a cloud data warehouse environment.
3. Strong sql skills with the ability to write and optimize complex queries for data extraction and analysis.
4. Proficient in python programming language for data manipulation, automation, and visualization.
5. Knowledge of data governance best practices and experience in implementing data security measures within a cloud environment.
6. Excellent analytical and problem-solving skills with a keen attention to detail.
Certifications: SnowPro Core Certification, DBT Fundamentals Certification (preferred).