Business Intelligence Developer - Loyalty Program
At Home GroupJOB 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
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 relate to customer loyalty programs, marketing campaigns, and customer behavior.