Snowflake Date Engineer

Location: Chicago, IL / New JerseyDuration: Full TimeSalary Range And Plus BenefitsPrimary Skill: Write, optimize, and troubleshoot SQL queries within the Snowflake environment.Secondary Skill: Develop and maintain robust ETL pipelinesKey ResponsibilitiesData 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.Technical SkillsProficiency in SQL, SnowSQL, and working knowledge of programminglanguages (e.g., Python, Java) for data processing.Familiarity with cloud platforms like AWS, Azure, or GCP.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 industryis a plus.Agile Methodology: Familiarity with Agile development processes and tools (e.g., Jira).