ETL Developer - Loyalty Program

JOB SUMMARY

The Business Intelligence Developer – Loyalty Program develops, maintains, and provides production support for the Data Warehouse and Power BI Tools, with a strong understanding of loyalty programs. This role is instrumental in designing, developing, and implementing data-driven solutions, optimize our loyalty initiatives, and enhance customer engagement and retention.

• Design, develop, and maintain ETL processes to load data into Snowflake.
• Utilize Coalesce to build and manage data transformations within Snowflake.
• Implement Snowpipe for continuous data ingestion.
• Develop and optimize Stored Procedures for data manipulation and transformation.
• Write complex SQL queries for data extraction, cleansing, and validation.
• Collaborate with data architects, data analysts, and other stakeholders to understand data requirements.
• Ensure data quality and accuracy through rigorous testing and validation.
• Monitor and troubleshoot ETL processes.
• Optimize ETL performance.
• Document ETL processes and data flows.
• Stay up-to-date with the latest Snowflake and ETL technologies.

• Bachelor's degree in Computer Science or a related field, preferred. Equivalent experience considered.
• 3+ years of experience in ETL development.
• Strong experience with Snowflake data warehouse.
• Proficiency in SQL.
• Experience with Coalesce.
• Experience with Snowpipe.
• Experience with Stored Procedures.
• Strong understanding of data warehousing principles and ETL best practices.
• Experience with data modeling.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.

• Experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
• Experience with other cloud-based data warehousing solutions.
• Snowflake Certification
• Experience with data governance and data quality tools.
• Experience working with data relate to customer loyalty programs, marketing campaigns, and customer behavior.