The Salvation Army National Headquarters in Alexandria, VA 22314

Job Summary:

The Data Warehouse Administrator is responsible for managing and optimizing the performance of a data warehouse, ensuring the integrity, security, and efficient storage and retrieval of data. This role involves collaborating with database developers, data architects, and business intelligence teams to design, implement, and maintain data warehouse solutions.

Essential Functions:

This job description should not be interpreted as all inclusive. It is intended to identify the essential functions and requirements of this position. You may be requested to perform job-related responsibilities and tasks other than those stated in this job description.

Oversees the installation, configuration, and maintenance of data warehouse databases.
Monitors and optimizes data warehouse performance, addressing bottlenecks, and ensuring scalability.
Implements and maintains data security measures, including access controls, encryption, and auditing.
Manages Extracts, Transforms, Load (ETL) processes.
Develops and maintains BI solutions, including dashboards, reports, and analytics.
Develops and implements backup and recovery procedures.
Works closely with data architects, database developers, and business intelligence teams.
Creates and maintains documentation for database configurations, processes, and procedures.
Identifies and resolves data warehouse issues.
Implements monitoring tools to track data warehouse performance.
Analyzes data growth trends and plans for future capacity requirements.

Minimum Qualifications Required:

Education and Experience:

Bachelor's degree in a relevant field (e.g., Computer Science, Information Technology) and 3+ years of experience in data warehouse and database administration roles or equivalent work experience.

Knowledge, Skills, and Abilities:

Proficient with data warehouse platforms such as Snowflake, Microsoft SQL Server, IBM Db2, or similar systems.
Solid understanding of data warehousing architecture.
Advanced knowledge of SQL for data retrieval and manipulation.
Familiarity with data security best practices.
Experience with ETL tools.
Ability to monitor and optimize data warehouse performance.
Knowledge of backup and recovery strategies.
Familiarity with scripting languages.
Strong analytical and problem-solving skills.
Excellent communication skills.
Meticulous attention to detail.
Ability to manage tasks and meet deadlines.
Commitment to staying updated on emerging technologies.
Ability to work effectively in a collaborative environment.
Strong leadership qualities.

Mental and Physical Abilities:

Ability to meet attendance requirements.
Ability to read, write, and effectively communicate in English.
Ability to work well under pressure.
Ability to follow instructions and work independently.
Limited physical effort required.

Working Conditions:

Work is performed in a typical office environment. Full-time position may require some weekend and evening work.

Benefits:

403(b)
Health insurance
Vision insurance
Life insurance
Paid time off
Free lunch
Free parking

Job Type: Full-time

Schedule:

Monday to Friday

Experience:

Data warehouse: 3 years (Required)

#J-18808-Ljbffr

Salvation Army USA

New Jobs

Data Warehouse Administrator