Specialist - Data Engineering-Data Analysis
Summary
The Data Engineering Specialist designs and maintains interactive dashboards, writes complex SQL queries for data extraction, and develops Python scripts to automate data processing and reporting tasks. The role involves working with AWS Redshift and collaborating with stakeholders to provide data-driven insights.
Technical Skills (Must Have)
SQL Advanced querying, joins, window functions, stored procedures Python + GIT Pandas, NumPy, automation scripting, data wrangling AWS Redshift Data warehousing, cluster management, query optimization Automation Scripted pipelines, scheduled jobs, ETL automation Tableau / Power BI/Dashboarding. Dashboard design, KPI tracking, report publishing Confluence Documentation
Roles & Responsibilities
• Design, develop, and maintain interactive dashboards and reports using Tableau (or any other Dashboarding Tool) to support business stakeholders.
• Write complex SQL queries to extract, transform, and validate data from relational databases and data warehouses.
• Develop Python-based automation scripts to streamline repetitive reporting, data processing, and reconciliation tasks.
• Track and manage analytics tasks, sprints, and documentation using JIRA and Confluence.
• Identify trends, patterns, and anomalies in large datasets and present findings to both technical and non-technical audiences.
• Problem Solving: Ability to break down complex business problems and design data-driven solutions with minimal supervision.
• Stakeholder Management: Proven ability to communicate insights clearly to diverse audiences including senior leadership, product teams, and operations.
• Strong written and verbal communication skills with a proactive, ownership-driven mindset.
• Comfortable working in fast-paced, agile environments, managing multiple priorities simultaneously.