remote
Senior Data Engineer - Troutman Pepper Locke
Data Engineer
Senior Data Engineer responsible for designing, building, and maintaining enterprise data pipelines, cleansing and validating data, and creating centralized data lakes using Python, SQL, and AWS services to support finance applications.
About the role
Key Responsibilities
- Design, develop, and maintain robust ETL pipelines to ingest, transform, and load enterprise data into finance applications.
- Cleanse, validate, and enrich data, ensuring high quality and consistency across all datasets.
- Build and manage a centralized data lake, integrating data from multiple sources and enabling scalable analytics.
- Generate comprehensive validation reports and dashboards using database technologies and financial software.
- Collaborate with cross‑functional teams to understand data requirements and deliver actionable insights.
Requirements
- Proven experience as a Data Engineer or similar role, with strong expertise in Python and SQL.
- Hands‑on experience with ETL tools and data lake architectures, preferably on AWS (S3, Glue, Redshift).
- Solid understanding of data modeling, data quality, and validation techniques.
- Excellent problem‑solving skills and ability to work independently in a fast‑paced environment.
- Strong communication skills and a collaborative mindset.