Data Transformation Engineer

Confie; United States; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Benefits package

Bonuses

Paid time off

Flexible work options

401k with match

Education scholarship

Fitness reimbursement

Inclusive workplace

Employee assistance program

Extra perks: insurance & pet

Job summary

Confie is seeking a Data Engineer to design and implement robust data pipelines and ELT processes on Snowflake. You will build scalable data models, develop Snowflake objects, and optimize performance while collaborating with the Enterprise Architecture team.

The role requires 4+ years in data engineering, strong Snowflake and ETL experience, and proficiency in Python and SQL. Remote/hybrid options available; on-call support included.

Qualifications

• 4+ years of professional experience in data engineering and building data infrastructure.
• 4+ years in Snowflake data cloud and ETL development including Snowflake procedures, UDFs in Python/SQL, streams, tasks, Snowpipe, with semi-structured data.
• 3+ years Python programming with Snowpark, pandas, numpy, and requests for data analysis and integration.
• Knowledge of data warehousing concepts, dimensional modeling, and data integration techniques.
• 2+ years experience with Coalesce, WhereScape, and Azure Data Factory.
• Bachelor's degree in CS/Engineering; Snowflake Advanced Certification a plus.

Responsibilities

• Build and maintain data pipelines and ETL/ELT workflows to populate Snowflake-based data lake and warehouse.
• Translate business requirements into technical specifications for data solutions.
• Develop robust data models and scalable Snowflake objects (tables, views, procedures, UDFs).
• Monitor and optimize query performance and data quality across pipelines.
• Work with multiple data sources (structured/semi-structured/unstructured) and ensure timely data delivery.
• Provide on-call support and stay updated on data engineering trends.

Skills

Snowflake

Python

ETL

Airflow

Fivetran

WhereScape

Coalesce

Pandas

Numpy

SQL

Education

Bachelor's degree in CS/Engineering

Snowflake Advanced Certification

Data platform certifications

Tools

Azure Data Factory

SnowPipe

Job description

• 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
• Extra Perks – optional plans for disability, hospital indemnity, health advocate program, universal life, critical illness, accident insurance, and even pet insurance

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

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 [e-mail]