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