SQL Developer (ETL & Relational Databases)

Aegis Worldwide; Novi (MI); On-site; USD 85,000 - 120,000; Full time

Job summary

Aegis Worldwide is seeking a Data Engineer to organize and manage data used across teams in Novi, Michigan. You will collaborate with the Data Architect to ensure data from multiple sources is accurate, accessible, and ready for reports, apps, and projects.

Key tasks include writing SQL, moving data between systems, and maintaining databases while addressing errors and performance issues. Strong communication with diverse teams is essential.

Qualifications

• 2+ years of experience with SQL, databases, or data engineering.
• Strong SQL skills and experience with relational databases.
• Experience moving and transforming data between systems.
• Good problem-solving skills and the ability to work with different teams.

Responsibilities

• Write SQL to pull, update, and organize data.
• Build processes that move data between systems.
• Set up and maintain databases so they run smoothly.
• Find and fix data errors or performance issues.
• Help teams get the information they need for reports and projects.
• Keep clear records of how data is organized and used.

Skills

SQL

Relational Databases

Data Integration

Team Collaboration

Problem Solving

Tools

Azure SQL

Azure Data Factory

Power BI

Python Basics

Job description

We’re looking for a Data Engineer to help organize and manage the information our teams use every day. You’ll work with our Data Architect to make sure data from different sources is accurate, easy to find, and ready to use in reports, applications, and other projects.

What you’ll do

• Write SQL to pull, update, and organize data
• Build processes that move data between systems
• Set up and maintain databases so they run smoothly
• Find and fix data errors or performance issues
• Help teams get the information they need for reports and projects
• Keep clear records of how data is organized and used

What you’ll need

• At least 2 years of experience working with SQL, databases, or data engineering
• Strong SQL skills and experience with relational databases
• Experience moving and transforming data between systems
• Good problem-solving skills and the ability to work with different teams

Experience with Azure SQL or Azure Data Factory is preferred. Power BI, Python, or experience with sensor data is a plus.