Specialist Data/AI Engineering

This position will interact on a consistent basis with other developers, architects, data product owners and source systems. This position requires multifaceted candidates who have experience in data analysis, visualization, good hands-on experience with BI Tools and relational databases, experience in data warehouse architecture (traditional and cloud).

Key Roles and Responsibilities

• Develop, understand, and enhance code in traditional data warehouse environments, data lake, and cloud environments like Snowflake, Azure, Databricks
• Build new end-to-end business intelligence solutions. This includes data extraction, ETL processes applied on data to derive useful business insights, and best representing this data through dashboards.
• Write complex SQL queries used to transform data using Python/Unix shell scripting
• Understand business requirements and create visual reports and dashboards using Power BI or Tableau.
• Upskill to different technologies, understand existing products and programs in place
• Work with other development and operations teams.
• Flexible with shifts and occasional weekend support.

Key Competencies

• Full life-cycle experience on enterprise software development projects.
• Experience in relational databases/ data marts/data warehouses and complex SQL programming.
• Extensive experience in ETL, shell or python scripting, data modelling, analysis, and preparation
• Experience in Unix/Linux system, files systems, shell scripting.
• Good to have knowledge on any cloud platforms like AWS, Azure, Snowflake, etc.
• Good to have experience in BI Reporting tools Power BI or Tableau
• Good problem-solving and analytical skills used to resolve technical problems.
• Must possess a good understanding of business requirements and IT strategies.
• Ability to work independently but must be a team player. Should be able to drive business decisions and take ownership of their work.
• Experience in presentation design, development, delivery, and good communication skills to present analytical results and recommendations for action-oriented data driven decisions and associated operational and financial impacts.

Required/Desired Skills

• RDBMS and Data Warehousing (Required 6-9 Years)
• SQL Programming and ETL (Required 6-9 Years)
• Unix/Linux shell scripting (Required 6-9 years)
• Power BI / Tableau (Desired 3 years)
• Python or any other programming language (Desired 4 years)
• Cloud Platforms - Azure, Snowflake, Databricks, Deltalake (Required 3-4 years)

Education & Qualifications

University Degree in Computer Science and/or Analytics

Minimum Experience required: 6-9 years in relational database design & development, ETL development