← Back to jobsJob ID col-cmva1x5we048qjl01qx5ehnij

ConfiePosted 30+ days ago

Data Transformation Engineer

Full-time
Remote
4+ years
$130K – $150K/yr
Posted 30+ days ago

Confie is seeking a Data Transformation Engineer to build and maintain next-generation enterprise data solutions. The role focuses on developing Snowflake data models, ELT pipelines, integrations, data quality processes, and performance optimizations that support reporting, analytics, business intelligence, and critical business operations.

Posted
30+ Days Ago
Source
recruiting2.ultipro.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

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

  • 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

Required skills

SnowflakeData EngineeringData PipelinesELT DevelopmentPythonSQLSnowparkpandasNumPyData WarehousingDimensional ModelingData IntegrationCoalesceWhereScape

Full job description

Confie is seeking a Data Transformation Engineer to build and maintain next-generation enterprise data solutions. The role focuses on developing Snowflake data models, ELT pipelines, integrations, data quality processes, and performance optimizations that support reporting, analytics, business intelligence, and critical business operations.

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

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
  • Data Quality
  • Data Observability
  • Snowflake Advanced Certification
  • Data Platform Certifications

Benefits

  • Comprehensive benefits package including medical, dental, vision, and life insurance
  • Performance-based bonuses to reward your contributions
  • Paid time off to recharge and maintain a healthy work-life balance
  • Flexible work options, including remote and hybrid opportunities, if eligible
  • Retirement Plan (401k) with company-matched contributions
  • Education Advancement, for employees and qualified dependents, via the Confie Enablement Scholarship Fund
  • Fitness Reimbursement – up to $15/month for gym memberships
  • Inclusive workplace through a strong commitment to Diversity, Equity, and Inclusion
  • Employee Assistance Program – confidential support for personal or professional challenges, at no cost
  • Optional plans for disability, hospital indemnity, health advocate program, universal life, critical illness, accident insurance, and pet insurance

Company

  • Personal lines insurance distributor for standard and non-standard markets
  • Huntington Beach, California, USA
  • https://www.confie.com/
  • Founded in 2008
  • 1001-5000 employees

Qualifications

  • 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
  • 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

Required skills

  • Snowflake, Data Engineering, Data Pipelines, ELT Development, Python, SQL, Snowpark, pandas, NumPy, Data Warehousing, Dimensional Modeling, Data Integration, Coalesce, WhereScape, Azure Data Factory, Airflow, Fivetran, Snowpipe, Snowflake Streams and Tasks, Snowflake Advanced Certification

Preferred skills

  • Snowflake Advanced Certification is a plus

Experience

  • 4+ years

Job details

Employment type

Full-time

Seniority level

4+ years

Date posted

Oct 6, 2026

Work mode

Remote

Job source

recruiting2.ultipro.com

Company

Confie

Information Technology & AI

Personal lines insurance distributor for standard and non-standard markets

  • Huntington Beach, California, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 2008
  • confie.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame roleData PipelinesRemote

Curana Health

1d ago

New

Data Engineer

Full-timeRemoteUnited StatesCompetitive

Curana Health is hiring a Data Engineer to build, optimize, and maintain data pipelines supporting clinical, operational, and analytical reporting.

Why similarSame roleData WarehousingRemote

Airbnb

1d ago

New

Data Engineer Tech Foundations

Full-timeRemoteUnited States$162K – $186K/yr

Airbnb is hiring a Data Engineer to build and operate reliable, reusable datasets and pipelines that support AI usage and cost measurement, Unit Economics, enterprise application data, and critical financial metrics.

Why similarSame roleData PipelinesRemote

Get new Data Engineer jobs by email

Create job alert

Data Transformation Engineer

Confie · $130K – $150K/yr

Apply on company site