Data Architect

Data Architect Engineer (AWS / Python) - Charlotte, NCCharlotte, NC$65-$72 / hr on W2Is Position Remote?: NoJob DescriptionData Architect Engineer (AWS / Python) position! This is a 6 months contract-to-hire opportunity and will be hybrid in Charlotte, NC.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 solutionBuild and maintain scalable integration layers and API integrations to support analytics and reporting systems across the organizationDevelop, deploy, and manage AWS Lambda functions and AWS Glue jobs written in Python, ensuring efficient serverless operations and performance optimizationDefine, build, and test scalable ETL/data pipelines leveraging AWS services including S3, PostgreSQL, DynamoDB, Athena, Snowflake, and GlueProactively communicate data-related scenarios and potential issues to business stakeholders, including audit trail management and data quality concernsCollaborate with development, analytics, and reporting teams to develop robust data models that feed business intelligence toolsPerform data analysis to troubleshoot data-related issues and optimize data storage and retrieval for large-scale distributed systemsEnsure data security, compliance, and privacy policies are integrated into all solutions while maintaining comprehensive technical documentation and architecture diagramsWhat 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 solutions3+ years of hands-on Python programming experience with proven ability to write, manage, and optimize production-level code3+ years in an ETL or Data Engineering role building and implementing data pipelines with strong SQL query writing skillsHands-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 modelingSolid experience with both SQL and NoSQL database technologies, with proficiency in writing efficient queriesProactive communication skills with the ability to identify and articulate data-related scenarios, risks, and recommendations to business stakeholdersHighly self-motivated and detail-oriented with strong analytical thinking and problem-solving abilitiesAWS certifications (e.g., AWS Certified Data Analytics - Specialty, AWS Certified Solutions Architect) are highly desirable