Sr Data Engineer

Job Description

Employer: PSA Ventures, Inc

Requirements

  • Sr. Data Engineer, Master’s degree in Computer Science, Computer Information Systems with 2 years of exp.
  • Design and develop data pipelines for ingesting, transforming, and delivering structured and unstructured data using AWS Glue, Lambda, S3, Redshift, PostgreSQL, and EKS; 
  • Manage ETL/ELT workflows to support data processing for analytics and reporting, leveraging tools such as Airflow, dbt, and Amazon Web Services.
  • Collaborate with cross-functional teams to gather requirements, translate them into technical specifications, and deliver actionable data solutions. 
  • Optimize Snowflake and AWS-based data workflows by fine-tuning SQL queries, indexing strategies, and storage configurations to improve processing speed.
  • Automate and streamline data tasks by implementing CI/CD pipelines for data workflows, ensuring reliability, accuracy, and timely delivery of business-critical datasets. 
  • Implement data governance, security, and compliance protocols using AWS Lake Formation, IAM policies, VPC configurations, and other cloud-native security services, aligning with regulatory standards.
  •  

Skills

  • AWS Glue, Lambda, S3, Redshift, PostgreSQL, EKS, ETL/ELT, SQL, CI/CD, AWS Lake Formation.
  • Must be willing to travel and/or relocate to various worksites throughout the U.S., including Uniondale, NY 11556, and Corona, NM 88318.
  • No telecommuting
  • Twice a month to each location
 

Location: 7541 Mentor Ave, STE A102-3, Mentor, OH 44060

Send resume to PSA Ventures LLC, 7541 Mentor Ave, STE A102-3, Mentor, OH 44060 or email us at Hr@psaventuresus.com