Data Architect Engineer (AWS / Python) - 3635382

Lighthouse Technology Services

Charlotte, NC

JOB DETAILS
SALARY
$65–$72 Per Hour
SKILLS
AWS Lambda, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Auditing, Best Practices, Business Intelligence Software, Cloud Computing, Communication Skills, Data Analysis, Data Management, Data Modeling, Data Processing, Data Quality, Data Recovery, Data Storage, Data Warehousing, DataArchitect Data Modeling Tool, Database Design, Database Extract Transform and Load (ETL), Database Technology, Detail Oriented, Dimensional Modeling, Distributed Computing, Identify Issues, Information/Data Security (InfoSec), Large-Scale Systems, NoSQL, Operations Management, Performance Tuning/Optimization, PostgreSQL, Problem Solving Skills, Python Programming/Scripting Language, SQL (Structured Query Language), SQL Databases, Scalable System Development, Software Engineering, Technical Writing, Testing, Transaction Processing/Management, Writing Skills
LOCATION
Charlotte, NC
POSTED
1 day ago

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


About the Company

L

Lighthouse Technology Services