Confie · 11 hours ago
Data Engineer
United States
Full-time
Remote
Mid, Senior Level
$120K/yr - $150K/yr
4+ years expConfie is focused on building next-generation Enterprise Data Solutions. The Data Engineer will work under the guidance of the Director of Enterprise Architecture to develop data pipelines and maintain data solutions on Snowflake, driving critical business insights.
FinanceProperty & Casualty InsuranceHealth InsuranceAuto InsuranceCommercial InsuranceFinancial ServicesInsurance
Responsibilities
Design and develop data pipelines, ETL 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 profiling, 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
Qualification
Required
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
Bachelor's degree in Computer Science, Engineering, or a related field
Preferred
Experience with data quality and observability concepts is a plus
Snowflake Advanced Certification is a plus
Additional certifications related to data platforms are a plus
Benefits
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)
Company
Confie
Confie is one of the nation’s largest and most respected independent personal lines insurance distributors.
1001-5000 employees
H1B Sponsorship
Confie has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (4)
2023 (2)
2021 (2)
2020 (6)
Funding
Current Stage
Late StageTotal Funding
unknown2021-04-21Acquired
Leadership Team
Cesar Soriano
CEO
Michael Kaplan
EVP CFO
Recent News
2025-12-19
2025-12-17
Company data provided by crunchbase