Data Warehouse Administrator - Alexandria, United States - The Salvation Army National Headquarters

The Salvation Army National Headquarters
The Salvation Army National Headquarters
Verified Company
Alexandria, United States

1 week ago

Mark Lane

Posted by:

Mark Lane

beBee recruiter
Description

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. Managing schema design, indexing, and optimizing SQL queries for efficient data retrieval.

Monitors and optimizes data warehouse performance, addressing bottlenecks, and ensuring scalability. Implementing strategies to enhance query efficiency and response time.

Implements and maintains data security measures, including access controls, encryption, and auditing. Ensuring compliance with data privacy regulations and organizational security policies.


Manages Extracts, Transforms, Load (ETL) processes to extract data from source systems, transform it to meet analytical requirements, and load it into the data warehouse.

Develops and maintains BI solutions, including dashboards, reports, and analytics. Collaborate with business analysts to understand reporting requirements. Optimize BI performance for quick and efficient data analysis.

Develops and implements backup and recovery procedures to safeguard data against loss or corruption. Testing and validating backup and recovery processes regularly.


Works closely with data architects, database developers, and business intelligence teams to understand data requirements, provide database support, and ensure alignment with business objectives.

Creates and maintains documentation for database configurations, processes, and procedures. Keeping documentation up to date to facilitate knowledge transfer and compliance.

Identifies and resolves data warehouse issues, collaborating with IT and development teams to address technical challenges promptly.

Implements monitoring tools to track data warehouse performance and generates regular reports on system health, usage, and optimization recommendations.

Analysis data growth trends and planning for future capacity requirements. Proactively identifying opportunities for system improvements and recommending upgrades.


OTHER RESPONSIBILITIES
Assist with special projects as requested and as needed.

Performs other related work as requested by the supervisor.


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.


LICENSES AND CERTIFICATIONS:


Certifications such as Azure Data Engineer Associate, Certified Information Systems Security Professional (CISSP), Certified Information Security Manager (CISM), SnowPro Core Certification are a plus but not required.


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, including data modeling, ETL processes, star schema, and snowflake schema.

Advanced knowledge of SQL for data retrieval and manipulation. Ability to optimize and tune SQL queries for better performance.

Familiarity with data security best practices, encryption techniques, and compliance standards such as GDPR or HIPAA. Ensures the implementation of security measures to protect sensitive data.

Experience with Extract, Transform, Load (ETL) tools like Informatica, Talend, or Microsoft SSIS for efficiently moving and transforming data.

Ability to monitor and optimize data warehouse performance, identify bottlenecks, and implement solutions for improved efficiency.

Knowledge of backup and recovery strategies for data warehouses, including regular testing of procedures to ensure data integrity.

Familiarity with scripting languages like Python, Shell, JSON, or PowerShell for automation and customization tasks.

Proficient in designing and implementing data models, understanding concepts like star schemas, snowflake schemas, and dimension hierarchies.

Strong analytical and problem-solving skills to identify and address issues related to data warehouse performance, security, and reliability.

Excellent communication skills to collaborate with cross-functional teams, convey technical information to non-technical stakeholders, and document processes.

Meticulous attention to detail, especially in tasks related to database configurations, data integrity, and troubleshooting.

Ability to manage tasks, prioritize wo
More jobs from The Salvation Army National Headquarters
See all jobs of The Salvation Army National Headquarters