Data Warehouse Administrator

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 workloads, and meet deadlines within the context of data warehouse projects.

A commitment to staying updated on emerging technologies, industry best practices, and advancements in data warehousing.

Ability to work effectively in a collaborative environment, partnering with data architects, developers, and business intelligence teams.

Strong leadership qualities to guide and influence the adoption of best practices, standards, and procedures related to data warehouse administration.

Proficient in identifying and resolving issues, conducting root cause analysis, and implementing solutions to enhance data warehouse functionality.

Ability to analyze data growth patterns, assess system capacity requirements, and plan for scalability.

Ability to learn quickly, be adaptable, flexible, and creative.

Excellent interpersonal and organizational skills.

Attention to detail and service oriented.

Self-motivated and able to drive a project to completion.

Knowledge of cloud computing (AWS/Azure), Docker, GitHub, and code testing is a plus.

Excellent command of both spoken and written English.

MENTAL AND PHYSICAL ABILITIES:

Ability to meet attendance requirements.

Ability to read, write, and effectively communicate the English language.

Demonstrated research and analytical skills.

Ability to work well under the pressure of deadlines.

Ability to follow instructions and work independently with minimal supervision.

Limited amount of physical effort required associated with walking, standing, lifting, and carrying light objects (less than 25 lbs.) 5-10% of work time.

Duties are usually performed seated. Sitting may be relieved by brief or occasional periods of standing or walking.

WORKING CONDITIONS:

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

The Salvation Army reserves the right to reassign, revise the job or to require that different or additional tasks be performed based on the organization's need or when circumstances change.

All employees recognize that The Salvation Army is a church and agree that they will do nothing as an employee of The Salvation Army to undermine its religious mission.

BENEFITS:

• 403(b)
• Dental insurance
• Health insurance
• Vision insurance
• Hearing Insurance
• Life insurance
• Paid time off
• Free lunch
• Free parking