The Business Intelligence Developer – Loyalty Program is needed to develop, maintain, and provide 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.
Requirements
- 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.
Responsibilities
- 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.
- Ensure data quality and accuracy through rigorous testing and validation.
- Monitor and troubleshoot ETL processes.
Other
- Collaborate with data architects, data analysts, and other stakeholders to understand data requirements.
- Optimize ETL performance.
- Document ETL processes and data flows.
- Stay up-to-date with the latest Snowflake and ETL technologies.
- Excellent problem-solving and analytical skills.
