SQL Data Engineer
Laksys Consulting
contract
Posted on:
Location Type: Remote
Location: India
Visit company websiteExplore more
About the role
- Design, develop, and maintain end-to-end ETL/ELT pipelines using AWS Glue, Redshift, and related AWS services
- Develop and maintain robust data models by understanding business requirements and analytics needs
- Write and optimize complex SQL queries to support reporting, analytics, and downstream data consumers
- Optimize data warehouse schemas, data models, and queries for performance, scalability, and cost efficiency
- Collaborate with data architects, analysts, and business stakeholders to translate business needs into technical data solutions
- Implement data quality, governance, and security best practices across data pipelines
- Automate workflows, monitoring, alerting, and performance tuning in AWS environments
- Manage data ingestion from multiple structured and unstructured data sources
- Troubleshoot and resolve production data issues, ensuring high availability and reliability
Requirements
- 10+ Years of experience
- Strong hands-on experience with AWS Redshift
- Expertise in AWS Glue and PySpark for ETL development
- Solid expertise in data modeling
- Strong proficiency in SQL
- Solid understanding of data warehousing concepts and ETL design patterns
- Experience with AWS services such as S3, Lambda, Athena, Step Functions, and CloudWatch
- Proficiency in Python for data transformation and automation
- Experience with CI/CD pipelines, Git version control, and Infrastructure as Code (CloudFormation / Terraform) is a plus
- Excellent problem-solving, analytical, and communication skills
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETLELTAWS GlueAWS RedshiftSQLdata modelingPySparkPythonCI/CDInfrastructure as Code
Soft skills
problem-solvinganalytical skillscommunication skills