Data Engineer - AWS Redshift Tableau

Orangebits Software Technologies; Mumbai; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Orangebits Software Technologies is seeking data professionals skilled in data engineering, Redshift administration, and Tableau to support and enhance data pipelines and dashboards.

The role covers data governance, quality, and collaboration with business teams to meet reporting needs, including Tableau Cloud/Server administration and system integration considerations.

Qualifications

• Experience in data engineering with Redshift administration and Tableau reporting.
• Strong data pipelines, data warehouse operations, governance and data quality.
• Ability to design data models, tables and views for dashboards.

Responsibilities

• Manage and support day-to-day data pipelines and data loads.
• Monitor and optimize Amazon Redshift performance and cost.
• Design and maintain data models, tables, views, and related data warehouse objects.
• Manage access, security, and data governance requirements.
• Monitor data quality and troubleshoot production issues.
• Build, enhance, and support Tableau dashboards and reports.
• Support Tableau Cloud/Tableau Server administration and application activities.
• Work with business stakeholders for requirement gathering and reporting needs.
• Support system integrations, including authentication, authorisation, monitoring, scalability, and system design considerations.
• Drive process improvements and provide ongoing production support.

Skills

Tableau administration

Redshift SQL

PostgreSQL

Data warehousing concepts

ETL/ELT concepts

Data governance

Excel and business reporting

Tools

Tableau Server

Tableau Cloud

Amazon Redshift

PostgreSQL

AWS (S3, Glue, AppFlow, Lambda)

Job description

Role Overview

We are looking for experienced data professionals with strong expertise in data engineering, Amazon Redshift administration/data modelling, and Tableau. The role will be responsible for supporting and enhancing data pipelines, data warehouse operations, governance, data quality, and business dashboards.

Key Responsibilities

• Manage and support day-to-day data pipelines and data loads.
• Monitor and optimize Amazon Redshift performance and cost.
• Design and maintain data models, tables, views, and related data warehouse objects.
• Manage access, security, and data governance requirements.
• Monitor data quality and troubleshoot production issues.
• Build, enhance, and support Tableau dashboards and reports.
• Support Tableau Cloud/Tableau Server administration and application activities.
• Work with business stakeholders for requirement gathering and reporting needs.
• Support system integrations, including authentication, authorisation, monitoring, scalability, and system design considerations.
• Drive process improvements and provide ongoing production support.

Technical Skills

• Tableau Cloud / Tableau Server administration and working application knowledge
• SQL Amazon Redshift and PostgreSQL
• AWS services – S3, Glue, AppFlow, Redshift, Lambda, etc.
• Data warehousing and data modelling concepts
• ETL, ELT, and data integration concepts
• System integration concepts – authentication, authorisation, monitoring, system design, and scalability
• Excel and business reporting