Data & Analytics Engineer – SQL, Python, Tableau & AWS
Job description
Job Summary
We are seeking a Data & Analytics Engineer to build cloud-based data pipelines and business intelligence solutions using SQL, Python, Tableau, and AWS services. The role focuses on data integration, workflow automation, and delivering reliable dashboards and reports.Key Responsibilities
Develop SQL queries to extract, transform, and validate data for analytics and reporting.Create Python scripts for data processing, integration, and automation.
Build and maintain ETL pipelines using AWS Glue.
Configure and maintain AWS Glue crawlers and the AWS Glue Data Catalog.
Orchestrate data workflows using AWS Step Functions, including retries, error handling, and dependencies.
Use Amazon S3 for data storage and AWS Lambda for event-driven processing.
Develop and maintain Tableau dashboards, reports, calculated fields, and data sources.
Collaborate with stakeholders to define reporting requirements and business metrics.
Monitor pipelines using Amazon CloudWatch and resolve data processing issues.
Optimize pipeline and dashboard performance while maintaining data quality and appropriate access controls.
Document data flows, transformation logic, and reporting definitions.
Required Qualifications
Strong SQL and Python development skills.Hands-on experience building Tableau dashboards and reports.
Experience with AWS Glue and AWS Step Functions.
Familiarity with Amazon S3, AWS Lambda, Amazon CloudWatch, and AWS IAM.
Understanding of ETL processes, data warehousing, and data modeling.
Experience with data validation, troubleshooting, and performance optimization.
Strong problem-solving and stakeholder communication skills.
Preferred Qualifications
Experience with Amazon Athena or Amazon Redshift.Familiarity with PySpark for large-scale data processing.
Knowledge of Git and CI/CD practices.
Interested in this role?