The Data Engineer is responsible for designing, developing, and maintaining database structures and data pipelines, writing SQL queries, and optimizing ETL processes.
DATA ENGINEER - Onsite/Hybrid
Location is US (Midwestern or Southern regions of the US), Local Office Flex positions.
Contract
Key Responsibilities
· Design, develop, and maintain database structures and data pipelines in Snowflake and Oracle environments
· Write efficient SQL queries, stored procedures, and functions to support application requirements
· Create and optimize ETL processes for data migration between different database platforms
· Implement database security measures and access control protocols
· Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions
· Develop Python scripts for data processing, analysis, and automation
· Monitor database performance and recommend optimization strategies
· Participate in code reviews and implement best practices for database development
· Create and maintain comprehensive documentation for database structures and processes
Required Qualifications
· Bachelor's degree in Computer Science, Information Technology, or related field
· 5+ years of experience with Software/database development.
· 3+ years of experience with Relational database development
· Python programming skills, particularly for data manipulation and analysis
· Proficiency in SQL query optimization and performance tuning
· Experience with ETL/ELT processes and data migration strategies
· Knowledge of database security best practices
· Strong analytical and problem-solving abilities
Preferred Qualifications
· Experience with PostgreSQL architecture and development
· Experience with Oracle databases or Oracle cloud infrastructure.
· Knowledge of data modeling and dimensional modeling concepts
· Familiarity with version control systems (Git)
· Experience with CI/CD pipelines for database changes
· Background in financial services or experience with financial data
· Understanding of agile development methodologies
· Certification in Snowflake, Oracle, or related technologies
Top Skills
Ci/Cd
ETL
Git
Oracle
Postgres
Python
Snowflake
SQL
Bounteous Chicago, Illinois, USA Office
The Bounteous flagship collaboration center is located in the heart of Ravenswood. This neighborhood is a stone's throw away from Wrigley Field, microbreweries, and boutiques.
Similar Jobs at Bounteous
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Systems Engineer will handle DevOps escalations, support project setups, monitor infrastructure, gather user requirements, and collaborate with teams.
Top Skills:
Amazon Web ServicesBitbucketCi/CdCloudFormationDockerGitJavaScriptPython
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Iterable Platform Developer will manage digital marketing campaigns, translate requirements into solutions, and support platform troubleshooting while ensuring best practices.
Top Skills:
CSSHTMLIterableJavaScriptJSONMjmlSQLXML
Agency • Digital Media • eCommerce • Professional Services • Software • Analytics • Consulting
The Lead PIM Technical Analyst will manage complex PIM engagements, working collaboratively with clients and teams to solve technical and business challenges while overseeing delivery and mentoring staff.
Top Skills:
AgileAngularCSSGraphQLHTMLHTML5JavaJavaScriptMvc ApplicationsObject-Oriented ProgrammingPHPPwaReactRestRwdSQLWeb Development
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
