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 You'll 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 You'll 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 recruiting@lhtservices.com

View all of our open jobs here: jobs.lhtservices.com