Data Architect Engineer (AWS Python)

Lighthouse Technology Services is partnering with our client to fill their Data Architect Engineer (AWS / Python) position! This is a 6 months contract-to-hire opportunity and will be hybrid in Charlotte NC. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.

What Youll Be Doing:

• Design and implement cloud-native data architectures on AWS including data lakes data warehouses and real-time data processing pipelines for a highly customized non-out-of-box solution
• Build and maintain scalable integration layers and API integrations to support analytics and reporting systems across the organization
• Develop deploy and manage AWS Lambda functions and AWS Glue jobs written in Python ensuring efficient serverless operations and performance optimization
• Define build and test scalable ETL/data pipelines leveraging AWS services including S3 PostgreSQL DynamoDB Athena Snowflake and Glue
• Proactively communicate data-related scenarios and potential issues to business stakeholders including audit trail management and data quality concerns
• Collaborate with development analytics and reporting teams to develop robust data models that feed business intelligence tools
• Perform data analysis to troubleshoot data-related issues and optimize data storage and retrieval for large-scale distributed systems
• Ensure data security compliance and privacy policies are integrated into all solutions while maintaining comprehensive technical documentation and architecture diagrams

What Youll Need to Have:

• 5 years of experience in data architecture engineering or similar roles with strong expertise in designing and implementing AWS-based data solutions
• 3 years of hands-on Python programming experience with proven ability to write manage and optimize production-level code
• 3 years in an ETL or Data Engineering role building and implementing data pipelines with strong SQL query writing skills
• Hands-on experience with AWS Lambda AWS Glue and other AWS services (S3 PostgreSQL DynamoDB Athena Snowflake)
• Strong understanding of design best practices for OLTP systems ODS reporting needs and dimensional database modeling
• Solid experience with both SQL and NoSQL database technologies with proficiency in writing efficient queries
• Proactive communication skills with the ability to identify and articulate data-related scenarios risks and recommendations to business stakeholders
• Highly self-motivated and detail-oriented with strong analytical thinking and problem-solving abilities
• AWS certifications (e.g. AWS Certified Data Analytics - Specialty AWS Certified Solutions Architect) are highly desirable

Pay Range: $65-72/hr

Questions about any of our jobs Email us at

View all of our open jobs here: