Data Transformation Engineer

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)