Migrate and optimize data workloads, develop ETL/ELT pipelines, build datasets for analytics, and support BI tools while ensuring data quality and collaborating with teams.
About Egen:
Egen is a fast-growing and entrepreneurial company with a data-first mindset. We bring together the best engineering talent working with the most advanced technology platforms, including Google Cloud and Salesforce, to help clients drive action and impact through data and insights. We are committed to being a place where the best people choose to work so they can apply their engineering and technology expertise to envision what is next for how data and platforms can change the world for the better. We are dedicated to learning, thrive on solving tough problems, and continually innovate to achieve fast, effective results. If this describes you, we want you on our team.
Want to learn more about life at Egen? Check out these resources in addition to the job description.
-> Meet Egen
-> Life at Egen
-> Culture and Values at Egen
-> Career Development at Egen
NOTE: This is a 6-month contract.
About the job:
- Migrate data and analytics workloads from BigQuery to Snowflake
- Support GCP to AWS data platform migration
- Develop and optimize ETL/ELT pipelines using Python and SQL
- Build analytics-ready datasets for reporting and dashboards
- Support BI tools such as Looker, Amazon QuickSight, or Tableau
- Ensure data quality, performance, and reliability
- Collaborate with data architects, analytics, and DevOps teams
About you:
- 3–5 years of experience as a Data Engineer
- Strong SQL skills (complex queries, optimization)
- Strong Python experience for data processing
- Experience with Snowflake
- Experience with BigQuery
- Cloud experience on GCP and/or AWS
- Experience supporting BI tools (Looker, QuickSight, Tableau)
Nice to have:
- Experience with data migration projects
- Knowledge of dbt, Airflow, or similar orchestration tools
- Experience in multi-cloud environments
- Familiarity with data modeling and analytics use cases
EEO and Accommodations:
Egen is an equal opportunity employer and is committed to inclusion, diversity, and equity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veterans’ status, or any other characteristic protected by federal, state, or local laws. Egen will also consider qualified applications with criminal histories, consistent with legal requirements. Egen welcomes and encourages applications from individuals with disabilities. Reasonable accommodations are available for candidates during all aspects of the selection process. Please advise the talent acquisition team if you require accommodations during the interview process.
Top Skills
Airflow
Amazon Quicksight
AWS
BigQuery
Dbt
GCP
Looker
Python
Snowflake
SQL
Tableau
Egen Naperville, Illinois, USA Office
Our office is located in a traditional business park with ample walking paths, greenery and trails with plenty of on-site parking. We are situated close to the thriving Naperville downtown district, with plenty of shopping, dining, and entertainment venues.
Similar Jobs
Information Technology • Consulting
The job involves leveraging AWS and Snowflake for data engineering tasks within a technology-focused company, requiring US residency.
Top Skills:
AWSSnowflake
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Full Stack Software Engineer, you will develop tools for cloud management, build APIs and UIs, and maintain cloud systems.
Top Skills:
AWSCi/CdCloudFormationGoGrpcJavaScriptKubernetesLinuxReactRestful ApisTerraformTypescript
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The Technical Operations Engineer III role focuses on leading AI solutions, integrating LLM-based technologies, mentoring team members, and ensuring the performance and quality of AI applications.
Top Skills:
Continuous DeliveryContinuous IntegrationGoLlmPythonReactRest Apis
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
