ETL Developer - Loyalty Program

Business Intelligence Developer Loyalty ProgramThe 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, optimizing our loyalty initiatives, and enhancing customer engagement and retention. Essential Functions: 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. Qualifications: 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. Preferred: 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 related to customer loyalty programs, marketing campaigns, and customer behavior.