Design, build, and maintain production-grade ETL/ELT pipelines and Snowflake schemas. Integrate APIs and event streams, orchestrate workflows (Airflow/Prefect/Dagster), implement data quality, lineage, observability, and apply DataOps/CI-CD, Docker, and testing best practices to ensure reliable, accessible analytics-ready data.
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 architect, build, and scale a modern data platform — designing production-grade ETL/ELT pipelines, optimizing Snowflake data warehouse schemas, and establishing robust DataOps practices. You will orchestrate workflows using Airflow, Prefect, or Dagster, implement data quality and lineage frameworks, integrate third-party REST APIs and event-driven sources, and apply software engineering standards including CI/CD, Docker, and automated testing to data repositories. The role prioritizes clean, well-tested Python code and a deep commitment to data reliability and accessibility.
WHAT YOU WILL DO
- Data Pipeline Development: Design, build, and maintain reliable, scalable ETL/ELT workflows that process batch and streaming data from diverse sources.
- Data Warehousing & Modeling: Design efficient, production-ready schemas (normalized and denormalized) in Snowflake to optimize query performance and enable enterprise analytics.
- API & Event Integration: Connect and ingest data from third-party REST APIs, event-driven streams, and batch sources into core data storage platforms.
- Orchestration: Maintain and expand workflow orchestration pipelines using modern tools (Airflow, Prefect, or Dagster).
- Data Quality & Observability: Implement automated testing, validation, lineage tracking, and proactive alerting frameworks to guarantee data accuracy and system uptime.
- DataOps & Engineering Standards: Drive CI/CD best practices, maintain code bases using Git and Docker, and adopt basic Infrastructure-as-Code (IaC) patterns.
- Code Excellence: Apply modern software engineering standards—including design patterns, automated unit/integration testing, and clear documentation—to data repositories.
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;
- 4+ years of experience as a Data Engineer.
- Core Python Fundamentals: Demonstrable expertise writing modular, maintainable, and well-tested Python code (OOP/functional patterns, package management, standard testing frameworks).
- Advanced SQL & Modeling: Deep knowledge of complex SQL queries, query optimization, database design principles, and normalization/denormalization patterns.
- Data Warehousing: Solid, hands-on experience building, managing, and optimizing data architectures within Snowflake.
- Workflow Orchestration: Production experience using workflow orchestration engines like Apache Airflow, Prefect, or Dagster.
- Integrations & Ingestion: Hands-on experience working with REST APIs, event-driven architectures, and both batch and streaming pipelines.
- Data Quality & Lineage: Experience building automated data quality checks, data lineage, and alerting mechanisms (e.g., using tools like dbt test, Great Expectations, or similar).
- DevOps / DataOps Practices: Strong skills in version control (Git), containerization (Docker), CI/CD automation, and familiarity with Infrastructure-as-Code basics.
- Upper-intermediate English level.
NICE TO HAVES
- Experience with dbt (data build tool) for data transformations.
- Familiarity with major cloud providers (AWS, GCP, or Azure).
- Exposure to message streaming tech like Apache Kafka or AWS Kinesis.
PERKS AND BENEFITS
- Growth without limits: build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget
- Competitive compensation: get recognition that reflects your skills and impact, with regular performance and compensation reviews
- Flexibility: work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm
- Meaningful, modern projects: build impactful products using modern technologies alongside global teams and leading brands
- Collaborative culture: join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized
- Well-being & support: access local well-being programs and people-focused support tailored to your location
Similar Jobs
Information Technology • Professional Services • Financial Services
Lead and maintain high-availability production and non-production databases (primarily SQL Server) supporting clearing operations. Responsibilities include performance tuning, capacity planning, HA/DR design and runbooks, upgrades, automation for monitoring and maintenance, incident escalation, vendor interaction, and participation in on-call rotation and cross-region handoffs.
Top Skills:
Always On Availability GroupsCommvaultExadataJIRAKanbanLog ShippingOraclePgbackrestPostgresReplicationServicenowSQL ServerT-SqlTransparent Data Encryption (Tde)Windows ServerWindows Server Failover Clustering (Wsfc)
Information Technology • Professional Services • Financial Services
Support firm-wide compliance by managing employee registration/licensing (FINRA/NFA), maintaining compliance databases, tracking attestations and filings, assisting exams and training, coordinating cross-departmental compliance matters, and documenting projects and follow-up actions.
Top Skills:
Finra CrdMS OfficeNfa BasicServicenowSharepoint
Big Data • Information Technology • Software • Analytics • Energy
Handle incoming owner relations inquiries about revenue, land, division orders, JIB, A/R, and A&P. Log and follow up cases in a tracking system, build trusting client relationships, manage difficult situations calmly, provide accurate timely responses, and participate in cross-training.
Top Skills:
MS Office
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
