What are the responsibilities and job description for the ETL Developer - Loyalty Program position at At Home Group Inc.?
Job Summary
JOB DESCRIPTION
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
When you’re a part of our team, you have the full support of a diverse, close-knit team in our stores. We consider all applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, gender identity and expression, marital or military status. We also provide reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law. At Home is committed to knitting diversity and inclusion into the fabric of our culture; we respect, appreciate and celebrate the experiences and qualities that differentiate everyone on the At Home team.
JOB DESCRIPTION
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.
- 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.
When you’re a part of our team, you have the full support of a diverse, close-knit team in our stores. We consider all applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, gender identity and expression, marital or military status. We also provide reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law. At Home is committed to knitting diversity and inclusion into the fabric of our culture; we respect, appreciate and celebrate the experiences and qualities that differentiate everyone on the At Home team.