Data Transformation Engineer

Confie
Huntington Beach, TX
Category Engineering
Job Description
Work under the guidance of the Director of Enterprise Architecture to build Confie's next-generation Enterprise Data Solutions, designing and implementing data solutions on Snowflake data cloud environments to drive critical business insights and operations.

Requirements

  • Design and develop data pipelines, ELT workflows to populate the cloud Data Lake and Data Warehouse on Snowflake
  • Translate business requirements into technical specifications
  • Design and develop robust and scalable data pipelines to support data integrations using Snowflake, Coalesce, Python, Airflow, and Fivetran
  • Implement ELT processes using Snowflake's features
  • Perform data cleaning, analysis, and integration using Python
  • 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
  • Identify and resolve performance bottlenecks and optimize data warehouse configurations for maximum efficiency
  • Implement processes and systems to monitor data quality
  • Stay up-to-date with industry trends and advancements in data engineering

Benefits

  • Generous Paid Time Off
  • Sick Pay
  • Health Benefits
  • Annual Bonus
  • 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)
]]>