Data Engineer

Position: Data Engineerhybrid modelLocation: 311 S Wacker Dr #1600, Chicago, IL & Ann Arbor, MI.Job type: 9 Months ContractExp Level: Min 8+ Years.Design, develop, and maintain database structures and data pipelines in Snowflake and Oracle environmentsWrite efficient SQL queries, stored procedures, and functions to support application requirementsCreate and optimize ETL processes for data migration between different database platformsImplement database security measures and access control protocolsCollaborate with cross-functional teams to understand business requirements and translate them into technical solutionsDevelop Python scripts for data processing, analysis, and automationMonitor database performance and recommend optimization strategiesParticipate in code reviews and implement best practices for database developmentCreate and maintain comprehensive documentation for database structures and processesRequired QualificationsBachelor's degree in computer science, Information Technology, or related field5+ years of experience with Software/database development.3+ years of experience with Relational database developmentPython programming skills, particularly for data manipulation and analysisProficiency in SQL query optimization and performance tuningExperience with ETL/ELT processes and data migration strategiesKnowledge of database security best practicesStrong analytical and problem-solving abilitiesPreferred QualificationsExperience with PostgreSQL architecture and developmentExperience with Oracle databases or Oracle cloud infrastructure.Knowledge of data modeling and dimensional modeling conceptsFamiliarity with version control systems (Git)Experience with CI/CD pipelines for database changesBackground in financial services or experience with financial dataUnderstanding of agile development methodologiesCertification in Snowflake, Oracle, or related technologies