Key Facts

Remote From:

California (USA) , Colorado (USA) , Florida (USA) , Georgia (USA) , Texas (USA)

Full time

Mid-level (2-5 years)

English

Hard Skills

Other Skills

•
Communication
•
Teamwork
•
Analytical Thinking
•
Detail Oriented
•
Problem Solving

Roles & Responsibilities

4+ years of professional experience in data engineering, designing and implementing data pipelines and building data infrastructure.
4+ years of Snowflake data cloud and ETL development experience, including Snowflake procedures, UDFs in Python and SQL, streams, tasks, Snowpipe, and working with semi-structured data.
3+ years of Python programming experience with frameworks such as Snowpark, pandas, numpy, and requests for data analysis and integration.
Bachelor's degree in Computer Science, Engineering, or a related field; Snowflake Advanced Certification or related data-platform certifications are a plus.

Requirements:

Design and develop data pipelines and ELT workflows to populate the cloud Data Lake and Data Warehouse on Snowflake with transformation tools (e.g., Coalesce, WhereScape, Azure Data Factory) and replication tools (e.g., Fivetran, Airbyte).
Translate business requirements into technical specifications; establish and define details, definitions, and requirements of applications, components, and enhancements.
Design and develop robust and scalable data pipelines to support data integrations using Snowflake, Coalesce, Python, Airflow, and Fivetran.
Design and develop Snowflake data objects (tables, views, stored procedures, UDFs, etc.) and implement ELT processes using Snowflake features such as SnowPipe, Streams, and Tasks.

Confie

Insurance

About Confie

Confie is the largest personal lines insurance agency in the US. Since the day we established ourselves in 2008, we quickly grew to become the nation’s leading independent insurance provider for personal lines. Personal lines insurance includes auto, motorcycle, homeowners, renters, life, and health among others. We are passionate about serving our customers in their local communities through our click, call, or come-in approach. We live by our aspiration to be the most trusted source of insurance solutions so our customers can have peace of mind. In the insurance industry, we have been recognized as the #1 personal lines leader in the nation for the past seven years. Confie is the only independent agency focused on personal lines insurance that consistently ranks in the Top 10 Property/Casualty agencies in the U.S. Our customers know us as friendly, professional, trustworthy, and knowledgeable. They recognize our brands and the great value we provide, and count on us for insurance solutions at competitive prices. We provide them quality coverage in the diverse communities that we serve. We believe that our employees are our brand. Our employees enjoy a positive, dynamic, inclusive and collaborative workplace where performance is rewarded, education is promoted, and employees have exciting opportunities to advance their careers. We strive to help every employee embrace our corporate values in everything they do. We promote a positive, workplace, and find satisfaction in a job well done. The secret to our continued success is our talented, diverse and dedicated employees. We are proud of our leading position in terms of employee diversity within our industry. At Confie, we offer competitive pay, great benefits, work-life balance, and significant upward opportunities for employees with passion. We look forward to you being a part of our team! Disclaimer: *2023 Top 50 Personal Lines Agency in Insurance Journal

Company type: Large

Industry: Insurance

Founded: 2018

Company size: 1001 - 5000

Website LinkedIn See all jobs →

Job description

Pay Range:

$110000 - $120000 / year

Our Perks:

Generous PTO plans, sick pay and health benefits
Annual bonus based on employment standing*
Work from home and hybrid model employment
Confie Enablement Fund/ Scholarship Program
I-Care Recognition Program
Corporate Social Responsibility Program
Diversity, Equity and Inclusion Initiatives
Confie Hub and Discount Programs (Gym Membership)

Purpose

Work under the guidance and supervision of the Director of Enterprise Architecture to build Confie's next-generation Enterprise Data Solutions. Require expertise in implementing and maintaining data solutions on Snowflake data cloud environments that drive critical business insights and operations. Responsible for developing robust data models, creating efficient ELT processes, and optimizing performance to support the organization's data needs

Essential Duties & Responsibilities

Design and develop data pipelines, ELT workflows to populate the cloud Data Lake and Data Warehouse on Snowflake with transformation tools (e.g., Coalesce, WhereScape, Azure Data Factory) and replication tools (e.g., Fivetran, Airbyte, etc.)

Translate business requirements into technical specifications; establish and define details, definitions, and requirements of applications, components, and enhancements

Design and develop robust and scalable data pipelines to support data integrations using Snowflake, Coalesce, Python, Airflow, and Fivetran

Design and develop Snowflake data objects (tables, views, stored procedures, udf's, etc.)

Implement ELT (Extract, Load, Transform) processes using Snowflake's features, such as SnowPipe, Streams, and Tasks

Perform data cleaning, analysis, and integration using Python

Ability to work with multiple data sources and types (structured/semi-structured/unstructured)

Design and implement efficient data models and schemas within Snowflake to support reporting, analytics, and business intelligence needs

Monitor and optimize query performance and resource utilization within Snowflake using query profilling, query optimization techniques, and workload management features

Identify and resolve performance bottlenecks and optimize data warehouse configurations for maximum efficiency

Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it

Monitor data pipelines for timely and accurate completion

Stay up-to-date with industry trends and advancements in data engineering, continuously improving the team's technical knowledge and skills

On-call support

Qualifications and Education Requirements

4+ years of professional experience in data engineering, designing and implementing data pipelines, and building data infrastructure

4+ years of strong experience required in Snowflake data cloud and ETL development, including Snowflake procedures, udf's in Python and SQL, streams, tasks, Snowpipe, and working with semi-structured data

3+ years of strong experience with Python programming and extensively used frameworks/packages like Snowpark, pandas, numpy, and requests for Data Analysis and integration

Solid understanding of data warehousing concepts, dimensional modeling, and data integration techniques

2+ years of strong experience with data integration and transformation tools like Coalesce, WhereScape, and Azure Data Factory

Experience with data quality and observability concepts is a plus

Bachelor's degree in Computer Science, Engineering, or a related field

Snowflake Advanced Certification is a plus

Additional certifications related to data platforms are a plus

Other Duties

This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice

Notice

As permitted by applicable law and from time-to-time, Confie may use a computer system that has elements of artificial intelligence to help make decisions about your employment, including recruitment, hiring, renewal of employment, or the terms and conditions of your employment. Employees with questions about Confie’s use of these computer systems should contact Human Resources at employeerelations@confie.com

Ready to apply?

APPLY

Share ·