As a Data & AI Engineer, you’ll build and deploy modern data pipelines and generative AI solutions on AWS — from scalable ETL/ELT workflows and cloud data platforms to production-grade RAG systems and AI agents. One engagement you may be designing and optimizing data pipelines using Glue, Lambda, and Redshift, the next you’re building GenAI applications powered by Bedrock, Claude, and vector databases to enable intelligent search and automation. You’ll work directly with clients to deliver end-to-end data and AI solutions that are secure, scalable, and production-ready.
What You’ll Do:
- Implementing data pipelines using AWS services such as Glue, Lambda, Step Functions, and EMR
- Creating and maintaining data extraction, transformation, and loading processes
- Configuring and optimizing AWS database services including RDS, Aurora, Redshift, and DynamoDB
- Implementing data lakes using S3 and related AWS services
- Designing and building production-ready Generative AI applications using Amazon Bedrock and foundation models such as Anthropic Claude
- Building and optimizing RAG (Retrieval-Augmented Generation) pipelines with vector databases
- Developing AI agents and multi-agent orchestration systems using frameworks like LangChain or LlamaIndex
- Writing and testing SQL queries and stored procedures
- Documenting technical solutions and providing knowledge transfer to customers
- Supporting the implementation of data governance and security controls
- Troubleshooting and resolving issues with data pipelines and AI services
- Participating in code reviews and implementing feedback
- Assisting with proof-of-concept implementations for customer engagements
Required Skills:
- 5+ years of software engineering experience with at least 2+ years focused on AI/ML, data engineering, or cloud-native development
- 2+ years of hands-on AWS experience with production deployments
- 1+ years of direct Generative AI experience (LLMs, embeddings, RAG, agents)
- Proven track record delivering production AI applications from concept to deployment
- Strong understanding of software engineering best practices (version control, testing, code review, documentation)
- Experience working in agile/scrum environments with distributed teams
- Excellent problem-solving skills and ability to work independently with minimal supervision
- Strong written and verbal communication skills for client-facing interactions
Preferred:
- Technical familiarity with AWS data and AI/ML services and modern data engineering practices
- Hands-on experience with ETL/ELT processes and data transformation
- Exposure to Generative AI concepts including LLMs, embeddings, RAG, and agent frameworks
- Ability to write and optimize SQL queries across various database platforms
- Knowledge of data modeling concepts and best practices
- Strong analytical and problem-solving skills
- Eagerness to learn new technologies and keep up with cloud and AI innovations
- Excellent communication skills with the ability to explain technical concepts clearly
- Attention to detail and commitment to solution quality
- Collaborative mindset with strong teamwork capabilities
- Experience or interest in automation and infrastructure as code
Skills Required
- 1-3 years of experience with cloud technologies, preferably AWS
- AWS Certified Cloud Practitioner certification or ability to obtain within 3 months
- Experience with SQL and at least one programming language (Python, Java, etc.)
- Basic understanding of data engineering concepts and data lifecycle management
- Familiarity with AWS data services such as S3, RDS, Glue, and Redshift
- Understanding of data security and access control principles
- Experience with version control systems (Git)
- Knowledge of infrastructure as code concepts
What We Do
Innovative Solutions is focused on helping every small to midsize business, across the U.S. and Canada, leverage the power of the cloud to drive business growth. As an AWS Premier Tier Services Partner, we specialize in cloud consulting, cloud migrations, cloud optimization, and cloud-native development. At Innovative, the customer always comes first. There is no ‘one size fits all’ mentality. Our team is flexible and will work with you to navigate the cloud in a way that aligns with your individual business needs. From the very first interaction, and every step along the way, we’re committed to doing what’s right for your business, your productivity, and your bottom line.
