Data Analytical Engineer

Codetech•Malvern, PA

About The Position

The Data Analytical Engineer writes ETL (Extract, Transform, Load) processes, designs database systems, and develops tools for real-time and offline analytic processing. The role troubleshoots software and processes to maintain data consistency and integrity, and integrates data from varied sources so business partners can generate insights and make decisions. The position translates business specifications into design specifications and code, and is responsible for programs, ad hoc queries, and reports. It ensures code is well structured, documented, maintainable, and reusable. The engineer partners with internal clients to understand business functions and informational needs, develops working knowledge of relevant tools and systems, and participates in all phases of solution development. The role also explains technical considerations in meetings, reviews completed work with clients, provides data-analysis guidance, and supports business users and team members.

Requirements

  • Experience building AWS cloud architecture and supporting services and technologies, including ECS, Glue, S3, Glue Crawler, Redshift, Step Functions, IAM, CloudWatch, CloudFormation, Lambda, Secrets Manager, and SageMaker.
  • Expertise building Spark data-processing applications using Python and PySpark.
  • Expertise in SQL development and Tableau reporting.
  • Experience with test automation and test-driven development practices.
  • Experience with CI/CD pipeline tools such as GitHub.
  • Required skills include Amazon Web Services (AWS) and SQL Server.

Responsibilities

  • Write ETL processes, design database systems, and develop tools for real-time and offline analytic processing.
  • Troubleshoot software and processes to ensure data consistency and integrity.
  • Integrate data from multiple sources to support business insight and decision-making.
  • Translate business specifications into design specifications and code.
  • Write programs, ad hoc queries, and reports.
  • Ensure code is well structured, sufficiently documented, maintainable, and reusable.
  • Partner with internal clients to understand business functions and informational needs.
  • Gain working knowledge of tools, technologies, applications, databases, and company-wide systems relevant to specific business areas.
  • Participate in all phases of solution development.
  • Explain technical considerations in meetings, including meetings with business clients.
  • Test code thoroughly for accuracy and intended purpose.
  • Review the end product with clients to ensure adequate understanding.
  • Provide data-analysis guidance as required.
  • Provide tool and data support to business users and fellow team members.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service