About the Position

We are seeking a Senior Data Engineer ID75059 to join AgileEngine and support a top US Wealth Management firm. You will design and build scalable data lakes, warehouses, and lakehouse architectures, implementing Python-based ETL/ELT pipelines, orchestrating workflows with Airflow, and developing ingestion workflows from third-party APIs.

Responsibilities

Design and implement Python Data Engineering solutions
Design and build scalable Data Lakes, Data Warehouses, and Data Lakehouses
Design and implement robust ETL/ELT processes at scale using Python, incorporating modern pipeline orchestration tools like Airflow
Develop sophisticated ingestion workflows from diverse 3rd party APIs and data sources
Manage and optimize various file formats (Parquet, Avro, ORC) and columnar storage to ensure high-performance data retrieval
Work with AI development tools to support and accelerate ongoing development, machine learning initiatives, and advanced analytics
Act as a technical consultant for stakeholders and leadership to gather requirements, understand business goals, and translate them into technical roadmaps
Work with Terraform and other tools to build AWS and on-prem infrastructure

Requirements

Authorized to work for ANY employer in the US (e.g., Green card holders, TN visa holders, GC EAD, H4 EAD, U4U with EAD)
Bachelor’s degree in computer science/engineering or other technical field, or equivalent experience
5+ years of experience with Python (strong, hands-on Python experience is a must)
5+ years of experience with data processing, manipulation, and analytics libraries like Pandas, Polars, PySpark, or DuckDB
2+ years of experience with Big Data technologies (Spark, Snowflake)
Expert-level knowledge of pipeline orchestration using Airflow or similar industry-standard tools
Deep understanding of Medallion Architecture, columnar file formats, and diverse database technologies (SQL, NoSQL, and Lakehouse architectures)
Proven ability to work with 3rd party APIs for complex data ingestion tasks
Proficiency with modern Cloud platforms (AWS, GCP, Snowflake) and advanced SQL optimization
Exceptional soft skills with a proven ability to gather requirements from leadership and collaborate effectively across cross-functional teams
Excellence in optimizing complex data pipelines and troubleshooting data latency or consistency issues in massive datasets
A self-starter mindset, regularly investigating more efficient data architectures and AI development tools to improve pipeline performance
Taking pride in data integrity and the accuracy of the end-to-end pipelines and architectures you build
Strong communication skills for seamless global collaboration with stakeholders and distributed teams
Upper-intermediate English level

Nice to Have

Familiarity with the fintech industry, understanding of financial data, regulatory requirements, and business processes specific to the domain
Documentation skills to document data pipelines, architecture designs, and best practices for knowledge sharing and future reference
OpenSearch, Elasticsearch
AWS Sagemaker Studio, Jupyter for analyze data
Terraform
Scala

We Offer

Professional growth: Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps
Competitive compensation: We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities
A selection of exciting projects: Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands
Flextime: Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office – whatever makes you the happiest and most productive

About the Company

Join AgileEngine, ranked by Inc. 5000 among America's fastest-growing private companies. We are social and committed to providing a dynamic and inclusive work environment.

Locations

Washington DC, USA
Miami, USA
Mexico
Colombia
Brazil
Argentina
Ukraine
Poland
Portugal
India

Apply for this position

Why Us
Open Positions
Refer a Friend
FAQ

Senior Data Engineer ID75059

Tech Stack

Job Description, Responsibilities & Requirements