Data Engineer

Position: Data Engineer

hybrid model

Location: 311 S Wacker Dr #1600, Chicago, IL & Ann Arbor, MI.

Job type: 9 Months Contract

Exp Level: Min 8+ Years.

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