Data Engineer (AWS)

Capstone Integrated Solutions is a comprehensive services provider. Our team consists of outstanding professionals, highly experienced in designing, building, and supporting retail software. We see ourselves as a build-as-a-service provider who follows a repeatable business pattern that can be applied to a variety of platforms and verticals. Having a culture built on outcomes and delivery at the core of the business, Capstone is providing its customers with a complete suite of services for software development, system analysis, integration, implementation, and support, as well as the option to engage a single team to perform all the services they require.  

Who You Are and What You'll Do:  

Capstone Integrated Solutions is seeking an experienced AWS Data Engineer with deep expertise in building and optimizing data lakes, ETL pipelines, and scalable data solutions using AWS services. The ideal candidate has hands-on experience with AWS Glue, Amazon S3, Lake Formation, and related services, along with strong knowledge of data modeling, governance, and performance optimization. This role will focus on designing and implementing modern data architectures that enable analytics, machine learning, and business intelligence across the organization.  

Responsibilities:  

• Design, develop, and maintain ETL workflows and pipelines using AWS Glue, Python, and Spark. 

• Build and optimize data lakes on AWS leveraging S3, Lake Formation, and Glue Data Catalog. 

• Implement best practices for data partitioning, schema evolution, and performance tuning in distributed environments. 

• Collaborate with data scientists, analysts, and business stakeholders to deliver reliable, high-quality datasets. 

• Develop and maintain metadata, data lineage, and governance standards within AWS data ecosystems. 

• Monitor, troubleshoot, and optimize ETL processes for scalability, reliability, and cost-effectiveness. 

• Integrate structured and unstructured data from multiple sources into centralized storage solutions. 

• Ensure compliance with data security, privacy, and regulatory requirements. 

• Contribute to the architecture and roadmap for enterprise data platforms and analytics solutions.  

Qualifications:  

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or equivalent experience. 

• 5+ years of experience in data engineering with a strong focus on AWS. 

• Hands-on expertise with AWS Glue (ETL, Data Catalog, Job orchestration). 

• Strong experience with Amazon S3, Lake Formation, Athena, Redshift, and IAM. 

• Proficiency in Python, PySpark, or Scala for ETL development. 

• Solid understanding of data warehousing, data lake architectures, and distributed computing. 

• Experience with data quality, governance, and security best practices. 

• Strong SQL skills and experience with query performance tuning. 

• Familiarity with CI/CD pipelines and infrastructure-as-code (e.g., CloudFormation, Terraform). 

• Excellent problem-solving and communication skills. 

Nice to Have:  

• Experience with Pentaho ETL Jobs.  

• Experience working with AWS Professional Services. 
    

“Our Culture”:  

At Capstone, the central principles that we all adhere to, and the glue that holds us together, are our keystones.  Our four keystones are:  

• "A Customer Obsessed, Delivery Focused, Culture"   

• We’re driven to exceed our customers’ expectations by listening, leading, solving problems, and delivering what we promise  

• We aim to be the most dependable and trusted partner serving our customers. TRUST = CONSISTENCY x TIME  

• "A Culture of Learning and Sharing"   

• We value “Lifetime Learners”; those who are hungry, competitive, curious, and self-motivated in their pursuit of knowledge.  

• Personal and professional growth depends on teamwork and continuous learning. By sharing knowledge, skills, ideas, and effort, we benefit our customers, ourselves, and our communities.  

• We recognize that the thoughts, feelings, and backgrounds of others are as important as our own. Everyone has something to learn and everyone has something they can teach.  

• Knowledge and ability are valued. Sharing knowledge and helping others learn new capabilities is valued exponentially.  

• "A Culture of Growth and Scalability"   

• Growth comes from not establishing barriers in your role. “Cross functional skill sets are valued and help us deliver to our customers in a truly agile fashion. It comes with understanding that when asked to do something new, you will need support, have questions, and make some mistakes along the way.  

• The most elegant solution is a simple solution. Simple doesn’t mean easy. It’s often more difficult to break a complex problem down into simple, scalable terms. We don’t appreciate, or value, over architected solutions or superfluous coding.  

• Time is one of our most precious commodities.  Scalability implies being respectful of this and passionate about making the most efficient use of each and every one of our team members time.  

• "All Work is Strategic"   

• No matter how small a project or assignment appears, every single engagement is an opportunity for us to prove ourselves, build trust, and develop relationships that last and grow  

• Every task, interaction, and commitment matters  

• Big or small, we execute our plans and strategies with focus, commitment, and passion  

We offer:  

Job Type: Full-time  

Benefits:   

• Remote work  

 

Capstone Integrated Solutions is an equal opportunity employer. We embrace and celebrate diversity and are committed to creating an inclusive and safe environment for all employees. Experience comes in many forms, and we're dedicated to adding new perspectives to the team. We encourage you to apply even if your experience doesn't perfectly align with what we have listed. We look forward to hearing from you.  

No Agencies Please!