ETL Developer Loyalty Program
BravoTech
Dallas, TX
JOB DETAILS
LOCATION
Dallas, TX
POSTED
30+ days ago
- Direct Hire
- Hybrid Onsite- Dallas TX (must live local to be considered)
- Retail Industry experience desired
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:
- 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.
- 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.
About the Company
B