Business Intelligence Developer Loyalty Program

Description

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

Bachelors 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.

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Employment Type : Full-Time

Experience : years

Vacancy : 1