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.

ESSENTIAL FUNCTIONS

• 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 relate to customer loyalty programs, marketing campaigns, and customer behavior.