Design and build scalable data lakes, warehouses, and lakehouses. Implement Python ETL/ELT pipelines and Airflow orchestration, ingest from third-party APIs, optimize Parquet/Avro/ORC columnar storage, and work with Spark, Snowflake, and cloud platforms. Act as technical consultant to translate business goals into data architecture roadmaps, use Terraform for infra, and support AI/ML initiatives while ensuring data integrity and pipeline performance.
AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.
WHY JOIN US
If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!
ABOUT THE ROLE
We are looking for a Senior Data Engineer to design and build scalable data lakes, warehouses, and lakehouse architectures supporting a thematic research platform that processes large volumes of financial data daily. You will implement Python-based ETL/ELT pipelines, orchestrate workflows with Airflow, develop ingestion workflows from third-party APIs, and work with Snowflake, Spark, and AWS to deliver high-performance data infrastructure. The role combines hands-on engineering with technical consulting responsibilities, translating business goals into data architecture roadmaps.
WHAT YOU WILL DO
- 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.
MUST HAVES
- You must be authorized to work for ANY employer in the US (e.g., Green card holders, TN visa holders, GC EAD, H4 EAD, U4U with EAD), as we are unable to sponsor or take over employment visa sponsorship at this time;
- 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 HAVES
- 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.
PERKS AND BENEFITS
- Professional growth: Mentorship, TechTalks, and personalized growth roadmaps.
- Competitive compensation: USD-based pay with education, fitness, and team activity budgets.
- Exciting projects: Modern solutions with Fortune 500 and top product companies.
- Flextime: Flexible schedule with remote and office options.
Similar Jobs
Software
Design and build scalable data lakes, warehouses, and lakehouse architectures. Implement Python ETL/ELT pipelines, orchestrate workflows with Airflow, ingest data from third-party APIs, optimize columnar formats and SQL, support ML initiatives, consult with stakeholders, and provision infrastructure using AWS and Terraform.
Top Skills:
AirflowAvroAWSDuckdbElasticsearchGCPJupyterOpensearchOrcPandasParquetPolarsPysparkPythonSagemaker StudioScalaSnowflakeSparkSQLTerraform
Software
Design and build scalable data lakes, warehouses, and lakehouses. Implement Python ETL/ELT pipelines and Airflow orchestration. Build ingestion workflows from third-party APIs, optimize performance using Spark and Snowflake on AWS/GCP, and consult with stakeholders to translate business goals into data architecture roadmaps.
Top Skills:
AirflowAvroAWSAws Sagemaker StudioDuckdbElasticsearchGCPJupyterLakehouseMedallion ArchitectureNoSQLOpensearchOrcPandasParquetPolarsPysparkPythonScalaSnowflakeSparkSQLTerraform
Software
Design and build scalable data lakes, warehouses, and lakehouse architectures. Implement Python ETL/ELT pipelines, orchestrate workflows with Airflow, ingest from 3rd-party APIs, optimize columnar file formats, support ML initiatives, and consult with stakeholders to translate business goals into data architecture roadmaps using Snowflake, Spark, and cloud infrastructure.
Top Skills:
AirflowAvroAWSDuckdbGCPNoSQLOrcPandasParquetPolarsPysparkPythonSnowflakeSparkSQLTerraform
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
