Jobs
>
Alexandria

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

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

    3 weeks ago

    Default job background
    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 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.

    #J-18808-Ljbffr
  • The Salvation Army National Headquarters

    Data Warehouse Administrator

    1 week ago

    The Salvation Army National Headquarters Alexandria, United States

    **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 archi ...

  • Casey Construction Group, LLC

    Warehouse Administrator

    1 day ago

    Casey Construction Group, LLC Gaithersburg, United States

    Job Description · Job DescriptionSalary: · Established in 2009 by Steve Casey, Casey Construction is a Commercial Drywall & Floor Prep contractor built upon a family tradition of building relationships and providing quality interior finishes. Casey provides services all througho ...

  • Casey Construction Group, LLC

    Warehouse Administrator

    1 week ago

    Casey Construction Group, LLC Gaithersburg, United States

    Established in 2009 by Steve Casey, Casey Construction is a Commercial Drywall & Floor Prep contractor built upon a family tradition of building relationships and providing quality interior finishes. Casey provides services all throughout the metro Washington, DC area and Raleigh ...

  • H.M. SWEENY

    Warehouse Administrator

    6 days ago

    H.M. SWEENY Hyattsville, United States

    Busy HVAC supply house in need of motivated, personable, and intelligent person to join our team. · Duties include but not limited to: · - Answering general phone inquiries in a professional and courteous manner. · - Directing phone inquiries to the appropriate staff members. · - ...

  • Insight Global

    Director of DevSecOps

    2 weeks ago

    Insight Global Alexandria, United States

    Day-to-Day · As a key member of the Software Development & Operations team, this person will lead the team responsible for Compute, Messaging, Virtualization, SaaS Applications. Reporting to the VP of Software Development and Operations, this person is responsible for leading on ...

  • Sapphire Ventures

    Employee (m/f/d) Goods Receipt in Pinneberg Nord

    2 weeks ago

    Sapphire Ventures Washington, United States

    Washington Employee (m/f/d) for Goods Receipt / Warehouse · Date: · Starting immediately · Location: · 25421 Pinneberg Nord, · Job Level: · Experienced, Entry Level · Contract Type: · Full-time · famila Nordost is an expanding, dynamic retail company and is part of the owner-mana ...

  • General Dynamics Information Technology

    IT Warehouse Manager

    1 week ago

    General Dynamics Information Technology Alexandria, United States

    Seize your opportunity to make a personal impact as an IT Warehouse Manager supporting our federal customer. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career.At GDIT, people are our differentiator. As an IT Warehouse Manager ...

  • General Dynamics Information Technology

    IT Warehouse Manager

    1 week ago

    General Dynamics Information Technology Alexandria, United States

    Seize your opportunity to make a personal impact as an IT Warehouse Manager supporting our federal customer. GDIT is your place to make meaningful contributions to challenging projects and grow a rewarding career. · At GDIT, people are our differentiator. As an IT Warehouse Manag ...

  • NANA Regional Corp

    General Clerk III

    4 days ago

    NANA Regional Corp Alexandria, United States

    OverviewWork Where it MattersRiverTech, an Akima company, is not just another federal professional solutions contractor. As an Alaska Native Corporation (ANC), our mission and purpose extend beyond our exciting federal projects as we support our shareholder communities in Alaska. ...

  • RAJA Medical - Esthetic Device Manufacturer

    Administrative Assistant/warehouse Logistics

    2 weeks ago

    RAJA Medical - Esthetic Device Manufacturer Fairfax, United States

    We are seeking a highly organized and detail-oriented individual to join our team as an Administrative Assistant. As an Administrative Assistant, you will play a vital role in providing administrative support to our company and ensuring smooth operations. · **Responsibilities**: ...

  • Virginia Linen Service Inc

    Assistant General Manager

    5 days ago

    Virginia Linen Service Inc Alexandria, United States

    JOB DESCRIPTION · Assistant General Manager opportunity with growing, successful regional family owned and professionally managed company, serving customers since 1934. · This position is responsible for the overall management of a "stand alone" business and plays a critical ro ...

  • MANAGEMENT APPLICATIONS, INC.

    Field Engineers for USPTO IT Support

    1 week ago

    MANAGEMENT APPLICATIONS, INC. Alexandria, United States

    Field Engineers for USPTO IT Support · Management Applications, Inc., a leading provider of Network Management, Design and Implementation is seeking Field Engineers for a long-term contract with the US Patent and Trademark Office (USPTO). · The mission of the United States Pate ...

  • MANAGEMENT APPLICATIONS, INC.

    Network Engineers for USPTO IT Support

    1 week ago

    MANAGEMENT APPLICATIONS, INC. Alexandria, United States

    Network Engineers for USPTO IT Support · Management Applications, Inc., a leading provider of Network Management, Design and Implementation is seeking Network Engineers for a long-term contract with the US Patent and Trademark Office (USPTO). · The mission of the United States ...

  • MANAGEMENT APPLICATIONS, INC.

    Managerial/Consulting/SME Staff for USPTO IT Support

    4 days ago

    MANAGEMENT APPLICATIONS, INC. Alexandria, United States

    Managerial/Consulting/SME Staff for USPTO IT Support · Management Applications, Inc., a leading provider of Network Management, Design and Implementation is seeking Managerial/Consulting/SME Staff for a long-term contract with the US Patent and Trademark Office (USPTO). · The m ...

  • Echelon Insights

    Echelon Fellowship

    3 weeks ago

    Echelon Insights Alexandria, United States InternshipSHIP

    Job Description · Job DescriptionOur Echelon Insights Fellows will work directly with our partners and analysts to uncover and mine new data sources, synthesize results, and write research reports for our growing base of clients and subscribers. As an Echelon Fellow, you'll be at ...

  • Global Placement Services LLC Defunct

    Warehouse Assistant Manager

    3 days ago

    Global Placement Services LLC Defunct Alexandria, United States

    Job Description: · As a Warehouse Manager, you are an organizational leader responsible for creating a high-performing work environment that results in positive associate experiences, excellent customer service and an overall successful operation that supports the mission. Manag ...

  • Intrepid Solutions and Services, LLC

    Logistician

    1 week ago

    Intrepid Solutions and Services, LLC Alexandria, Virginia, United States Permanent

    Overview: · Intrepid Solutions has open a Logistician position supporting our US Army TENCAP client to help enable the Army to rapidly exploit and influence national capabilities and architectures in Alexandria, VA. · Responsibilities: · The Logistician shall provide logistics su ...

  • Infinity Systems

    Forklift driver

    2 weeks ago

    Infinity Systems Plain Dealing, United States

    We are currently seeking a forklift driver (m/f/d) for our well-known client in Neustadt i. Sachsen. · Your future responsibilities: · Receiving and checking goods for completeness · - Loading and unloading trucks · - Booking incoming goods · Performing minor PC tasks · - Timely ...

  • Encore

    Technical Supervisor, Audio Visual

    5 days ago

    Encore Oxon Hill, United States

    Position Overview · The Technical Supervisor leads floor operations with a focus on customer service, staff leadership and development. The Technical Supervisor directly leads the technical team to ensure operational efficiencies and customer satisfaction. This role may also part ...

  • Iron Mountain

    Support Associate, Crozier

    2 weeks ago

    Iron Mountain Arlington, United States Full time

    At Iron Mountain we know that work, when done well, makes a positive impact for our customers, our employees, and our planet. That's why we need smart, committed people to join us. Whether you're looking to start your career or make a change, talk to us and see how you can elevat ...