SQL & ETL Database Developer

Ardmore Roderick; Chicago (IL); On-site; USD 124,987 - 154,980; Full time

Benefits offered by this job

Medical, Dental, Vision plans

401K plan

Paid maternity leave, PTO

EAP and relocation not available

Job summary

Ardmore Roderick in Chicago, IL is seeking a Database Developer to design, develop, and optimize database objects, ensuring data quality and seamless integration with web interfaces. You will work with a team of infrastructure solutions experts to meet evolving client project needs at the Jardine Water Purification Plant.

The role requires strong SQL Server and Oracle experience, ETL, data modeling, and the ability to handle multiple assignments while collaborating with analysts and developers.

Qualifications

• Minimum 3 years of relevant experience as a Database Developer.
• Experience with SQL Server and Oracle environments.
• Ability to write complex queries and develop stored procedures/triggers.

Responsibilities

• Design stable, reliable database objects and procedures based on requirements.
• Translate issues and requirements for management and staff; align with business processes.
• Modify database objects and perform tests; ensure data quality and integrity.
• Collaborate with analysts and owners to improve applications and practices.
• Create design specifications and documentation for database projects.
• Provide data management support and assist in production issue resolution.
• Develop and link backend databases to web interfaces with stakeholders.

Skills

SQL querying

ETL development

Data modeling

Troubleshooting

Cross-functional collaboration

Front-end integration

Education

BS in Computer Science

Tools

SQL Server 2014/2016

SSMS

SSIS

SSRS

Oracle 11g/12c

Power BI

SAP Business Objects

Visual Studio Team Explorer / TFS

Job description

Ardmore Roderick in Chicago, IL is seeking a Database Developer to design, develop, and optimize database objects, ensuring data quality and seamless integration with web interfaces. You will work with a team of infrastructure solutions experts to meet evolving client project needs at the Jardine Water Purification Plant.

The role requires strong SQL Server and Oracle experience, ETL, data modeling, and the ability to handle multiple assignments while collaborating with analysts and developers.