Clicflyer - SQL Data Engineer - SSRS/SSIS

About Clicflyer (A Bodmas Technologies Brand) :

Bodmas Technologies is a retail analytics company that assists retailers and manufacturers improve and optimize promotions and visibility of their products. Our App "ClicFlyer" was born from the need to increase customer engagement and move towards retail optimization.

- Connect retailers with shoppers to provide a focused communication medium for their offers and promotions.

- Hassle free launch and instant reach of promotions to target audience.

- Instant feedback through actionable insights by understanding how promotions are being received by shoppers.

- Provide shoppers with all the information in an interactive and engaging manner to make shopping fun whilst saving money.

With over 5 million downloads in the middle east region and a rapidly increasing user base, being on ClicFlyer is now a necessity and a very cost-effective communication medium to drive sales and optimize promotions.

Key Skills :

- T-SQL, Azure SQL DB, Replication, SSRS, SSIS, Backup, View, Stored Procedures, Functions, Performance Tuning, Data Quality, ETL/Data Pipeline, Backup, Automation jobs. NoSQL Dbs.

- Experience : 3-8 Years

Job Description :

- 3+ years' experience in developing SQL based logics, DB Management & data for BI Tools.

- Developing complex SQL queries, views, procedures, and triggers with a deep understanding of indexing.

- Deep expertise in SQL, Stored Procedures, Triggers, functions, and SQL troubleshooting.

- Experience in SSIS, SSRS and ability to develop, build and troubleshoot SSIS packages.

- Experience in designing efficient database solutions for loading and transforming large volume of data & Data pipelines.

- Performance Tuning & DB Security & Logins creation and maintain high data quality and integrity.

- Familiar with common database activities such as upgrade, backup, recovery, migration, etc.

- Capability to think logically & design data flow chart.

- Experience of working on Azure SQL dbs.

- Experience of working on clickstream & large size databases.

- Experience of working on other databases e.g., non structed database.