Specialist Data Analysis - Data Engineering

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.

• Experience in Snowflake, Databricks, Azure platforms

• 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 4-6 Years)

• SQL Programming and ETL (Required 4-6 Years)

• Unix/Linux shell scripting (Required 3-4 years)

• Snowflake and Databricks (Required 4-6 Years)

• Power BI / Tableau (Desired 2 years)

• Python or any other programming language (Desired 2 years)

• Cloud Platforms - Azure, Delta lake (Desired – good to have experience)

Education & Qualifications

University Degree in Computer Science and/or Analytics

Minimum Experience required: 5-8 years in relational database design & development, ETL development