AWS Data Engineer

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 looking for a skilled AWS Data Engineer to join our team and play a crucial role in designing, developing, and optimizing data pipelines within AWS. This role will focus on processing and analyzing data related to advertising campaigns, marketing metrics, and media performance. A strong understanding of Marketing Cloud data structures and advertising analytics is essential to succeed in this position.

Key Responsibilities:

• Design, build, and maintain scalable and efficient data pipelines on AWS, ensuring data is processed, transformed, and stored correctly.

• Work closely with marketing teams, data analysts, and data scientists to support business intelligence and analytics needs related to advertising campaigns.

• Develop and manage ETL processes to ingest and process Marketing Cloud data and other media-related datasets.

• Optimize data workflows and pipelines to enhance performance, scalability, and reliability.

• Implement best practices for data governance, security, and compliance within AWS environments.

• Utilize AWS services such as Glue, Redshift, S3, Lambda, Kinesis, and EMR to process and manage data efficiently.

• Collaborate with cross-functional teams to ensure seamless data integration across multiple platforms.

Qualifications:

• 3+ years of experience in data engineering with a focus on AWS technologies.

• Strong experience with Marketing Cloud data, advertising campaign metrics, and media analytics.

• Proficiency in AWS services like Glue, Redshift, S3, Lambda, and Kinesis.

• Hands-on experience with SQL, Python, and Spark for data processing and transformation.

• Familiarity with data modeling, data warehousing, and ETL/ELT development.

• Experience working with large-scale datasets and optimizing query performance.

• Strong problem-solving skills and the ability to work in a fast-paced, collaborative environment.

• Knowledge of data governance and security best practices within AWS.

Preferred Qualifications:

• Experience with real-time streaming data and event-driven architectures.

• Familiarity with marketing analytics platforms and APIs.

• Understanding of AI/ML-driven data processing for predictive analytics in marketing.

 

“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 customer’s 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 bene