Hiring: Data Transformation Engineer Company: Confie Location: United States Job Posted Time: 2026-09-10 10:23:16 Employment Type: Remote Target Skills & Keywords : AI, Airbyte, Airflow, Azure, Data Lake, Data Pipeline, Data Warehouse, ELT, ETL, Fivetran, NumPy, Pandas, Python, SQL, Snowflake About the job Experience: •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 •2+ years of strong experience with data integration and transformation tools like Coalesce, WhereScape, and Azure Data Factory Required Skills: •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 •Demonstrated capacity 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 Qualifications: •Solid understanding of data warehousing concepts, dimensional modeling, and data integration techniques •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 Compensation: •$130000 - $150000 / year •Flexible work environment (work from home / hybrid options) •Competitive benefits and rewards package •Including medical, dental, vision, and life insurance Interested candidates, please apply directly through the job posting on company's career page or try via AI auto apply on this platform. Don't miss this opportunity to join a forward-thinking team!