Snowflake Date Engineer
Snowflake Date Engineer
Posted on :
24-09-2024
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
24-09-2024
Job Description
Job Title: Snowflake Data Engineer
About the Role:
The Snowflake Data Engineer will be a key member of the CAESAR (Crum Aggregate Enterprise
Store for Analytics & Reporting) team responsible for building optimizing and managing data
pipelines in the Snowflake cloud data platform. The ideal candidate will work closely with data
analysts stakeholders and developers to design and implement scalable data solutions that
support Crum & Forster s growing enterprise data needs.
Key Responsibilities:
Data Pipeline Development: Design build and maintain efficient scalable ETL/ELT
processes using Snowflake integrating data from various sources into the CAESAR data
repository.
Snowflake Data Management: Set up and optimize Snowflake environments ensuring
best practices in performance security and cost management.
Data Modeling: Develop and maintain data models (e.g. star snowflake schema) that
align with business reporting and analytics needs.
Data Integration: Collaborate with the CAESAR team to integrate data from multiple
internal and external systems ensuring data consistency accuracy and availability.
Performance Tuning: Monitor troubleshoot and optimize data load times and query
performance in Snowflake.
Collaboration: Work closely with stakeholders and the CAESAR team to gather
requirements understand data needs and deliver insights via dashboards reports and
data models.
Data Governance and Security: Implement best practices for data governance
including access control encryption and compliance with data privacy regulations.
Requirements
Location: Chicago/New Jersey
Type: Full Time
Qualifications:
Experience:
o 3 years of experience in data engineering with a focus on cloudbased data
warehousing.
o Handson experience working with Snowflake including managing Snowflake
environments writing complex SQL and optimizing performance.
o Experience with ETL/ELT tools (e.g. Matillion Talend DBT) and data pipeline
automation.
Technical Skills:
o Proficiency in SQL SnowSQL and working knowledge of programming
languages (e.g. Python Java) for data processing.
o Familiarity with cloud platforms like AWS Azure or GCP.
o Experience with data modeling techniques (star schema snowflake schema)
and database design.
Data Tools: Experience with BI tools such as Tableau Power BI or similar platforms.
Soft Skills: Strong communication and collaboration skills ability to work with crossfunctional teams.
Preferred Qualifications:
Certifications: Snowflake certification or relevant cloud data certifications (AWS
Azure).
Industry Knowledge: Experience working in the insurance or financial services industry
is a plus.
Agile Methodology: Familiarity with Agile development processes and tools (e.g. Jira).
Location: Chicago/New Jersey Type: Full Time Qualifications: Experience: o 3+ years of experience in data engineering, with a focus on cloud-based data warehousing. o Hands-on experience working with Snowflake, including managing Snowflake environments, writing complex SQL, and optimizing performance. o Experience with ETL/ELT tools (e.g., Matillion, Talend, DBT) and data pipeline automation. Technical Skills: o Proficiency in SQL, SnowSQL, and working knowledge of programming languages (e.g., Python, Java) for data processing. o Familiarity with cloud platforms like AWS, Azure, or GCP. o Experience with data modeling techniques (star schema, snowflake schema) and database design. Data Tools: Experience with BI tools such as Tableau, Power BI, or similar platforms. Soft Skills: Strong communication and collaboration skills, ability to work with crossfunctional teams. Preferred Qualifications: Certifications: Snowflake certification or relevant cloud data certifications (AWS, Azure). Industry Knowledge: Experience working in the insurance or financial services industry is a plus. Agile Methodology: Familiarity with Agile development processes and tools (e.g., Jira).
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
