Junior Azure Data Warehouse & ETL Engineer

AEGIS CORPS INC; Washington (District of Columbia); On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Disability insurance

Paid time off

Holidays (10)

Life insurance

401K

Job summary

AEGIS CORPS INC in Washington DC is seeking a Junior Database Administrator to support testing, implementing, maintaining and controlling the organization’s databases across Azure cloud environment. Responsibilities include ETL, data extraction, testing data marts, and tuning database performance with a focus on data quality.

The role requires a computer science degree and hands-on SQL Server experience; familiarity with Python, Java, PL/SQL, .NET or SAS is a plus, and data warehousing

Qualifications

• College degree in computer science from accredited university.
• Basic knowledge and experience in SQL Server programming is mandatory.
• Some experience in other programming languages such as Python, Java, PL/SQL, .net, SAS is highly preferred – the more languages the better.
• Background and prior experience in working with databases in data warehousing environments is desirable.

Responsibilities

• Perform disciplined, auditable execution of established data warehouse ETL (extract/transform/load) programs and refresh procedures.
• Execute disciplined, recurring manual data extractions, downloads, and pre-processing of FTP data files as inputs to datamart.
• Test and implement new releases to data mart.
• Contribute to the development of new methods, procedures, processes or systems and understand the impact of these changes.
• Provide support and expertise in investigation and resolution of performance related issues for warehousing environments.
• Proactively monitor and remedy data quality failures in recurring data mart ETL and refresh processes.
• Provide support in installing & upgrading database software and resolving database software problems.
• Perform evaluations of potential tools & utilities.
• Automate database tasks via scripting or through the use of tools.
• Proactively configure, monitor, and review statistics for errors, capacity and performance issues.
• Tune and troubleshoot software & database performance issues.

Skills

SQL Server

Python

Java

PL/SQL

C# / .NET

SAS

Education

College degree in computer science

Job description

AEGIS CORPS INC in Washington DC is seeking a Junior Database Administrator to support testing, implementing, maintaining and controlling the organization’s databases across Azure cloud environment. Responsibilities include ETL, data extraction, testing data marts, and tuning database performance with a focus on data quality.

The role requires a computer science degree and hands-on SQL Server experience; familiarity with Python, Java, PL/SQL, .NET or SAS is a plus, and data warehousing