Jobs
>
Washington, D.C.

    Data Warehouse Architect/Engineer - Washington, United States - Steel Point Solutions

    Steel Point Solutions
    Steel Point Solutions Washington, United States

    3 weeks ago

    Default job background
    Description

    Job Description

    Job Description

    Steel Point Solutions is an amazing SBA Certified (8a), HUBZone, Small Disadvantaged Business (SDB) and a Woman Owned Small Business (WOSB) company. Established in 2013 with a vision of offering world class, integrated business solutions for all levels of Government and commercial enterprises. We are represented by a team of talented and qualified professionals who know how essential efficient, cost-effective integrated solutions are to your organization's success. Leveraging these resources, we strive daily to lead the industry in program management and service delivery.

    We are seeking a skilled and experienced Data Warehouse Architect/Engineer to join our team. The ideal candidate will be responsible for designing, developing, and maintaining our organization's data warehouse infrastructure. This role requires expertise in data modeling, database management, ETL (Extract, Transform, Load) processes, and data integration techniques. The Data Warehouse Architect/Engineer will collaborate with cross-functional teams to ensure that our data warehouse meets the organization's business requirements and supports data-driven decision-making.

    Responsibilities:

    • Design and architect scalable, robust, and high-performance data warehouse solutions that meet business needs and data governance requirements.
    • Develop data models, schemas, and database structures optimized for analytical querying and reporting.
    • Implement best practices for data warehousing, including dimensional modeling, indexing strategies, partitioning, and clustering.
    • Design and implement ETL processes to extract data from multiple sources, transform it into a unified format, and load it into the data warehouse.
    • Develop and maintain data pipelines to ensure the timely and accurate transfer of data from source systems to the data warehouse.
    • Integrate data from disparate sources, including relational databases, flat files, APIs, and streaming data sources.
    • Establish data quality standards and procedures to ensure the integrity, accuracy, and consistency of data within the data warehouse.
    • Implement data governance policies and controls to enforce data security, privacy, and compliance requirements.
    • Monitor data quality metrics and perform data profiling and cleansing activities as needed.
    • Monitor and optimize the performance of the data warehouse, including query performance, data loading times, and system resource utilization.
    • Identify and resolve performance bottlenecks through query optimization, indexing, partitioning, and other tuning techniques.
    • Implement monitoring and alerting mechanisms to proactively identify and address issues affecting data warehouse performance.
    • Collaborate with business stakeholders, data analysts, and BI developers to understand data requirements and develop solutions that meet their needs.
    • Document data warehouse design, architecture, and processes, including data models, ETL workflows, and system configurations.

    Skills and Qualifications:

    • Bachelor's degree in computer science, Information Systems, or a related field.
    • Minimum 5 years of experience in data warehousing, database design, and ETL processes.
    • Proficiency in SQL, data modeling, and database management.
    • Familiarity with cloud-based data warehousing platforms (e.g., Amazon Redshift, Google Big Query, Snowflake).
    • Strong problem-solving skills and attention to detail.

    Candidates from Historically Underutilized Business Zones (HUBZone) are strongly encouraged to apply. To determine whether you reside in a HUBZone, visit:

    Steel Point Solutions, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.

  • cBEYONData

    Data Warehouse Architect

    2 weeks ago

    cBEYONData Washington, United States

    Job Description · Job DescriptioncBEYONData is seeking a Data Warehouse Architect with an active Top-Secret clearance to join a Data Warehouse and BI development team supporting our federal client. The Data Warehouse Architect will support maintaining and enhancing the Enterprise ...

  • Zachary Piper Solutions

    Data Warehouse Architect

    1 week ago

    Zachary Piper Solutions Washington, United States Full time

    Zachary Piper Solutions is currently seeking a Data Warehouse Architect to support the FAA. The Data Warehouse Architect will be supporting the data warehouse team, which is full-time based in Washington D.C, Chantilly VA, Quantico VA, or Huntsville AL . Top-Secret clearance ...

  • Office of the Secretary

    Supervisory General Engineer/Architect

    3 weeks ago

    Office of the Secretary Washington, United States

    Summary · This position is located at the Office of Construction and Facilities Management, Office of Facilities Planning in Washington, DC. This position is for the Director of Cost Estimating Service (CES). Duties · The incumbent serves as a first- and second-line superviso ...

  • Nodel LLC

    Security Splunk Architect/Engineer

    3 weeks ago

    Nodel LLC Washington, United States

    Location: Washington DC metro area (Hybrid) · Must have an active Secret OR Top Secret Clearance · We are seeking a Security Splunk Architect/Engineer to support a Navy enterprise network within the Engineering and Cyber Divisions. The candidate's primary responsibility is to mai ...

  • 3M Consultancy

    Pega Computer Systems Engineer/Architect SME with IRS MBI Clearance

    3 weeks ago

    3M Consultancy washington, United States

    This is a remote position. · Job Title: Pega Computer Systems Engineer/Architect SME · Location: Remote. · Duration: Full-Time · Experience with COTS (Pega) development. · Familiar with software engineering and Agile delivery best practices, including code reviews, unit testi ...

  • Department of Corrections Executive Leadership

    Technology Architect and Site Reliability Engineer

    3 weeks ago

    Department of Corrections Executive Leadership Washington, United States

    Introduction · The Department of Corrections (DOC) is focused on public safety through the custody and supervision of those in our care. Corrections employees have the opportunity to positively impact the lives of others through careers in a variety of fields. Using cutting-edge ...

  • DIGITALSPEC

    Azure Cloud Engineer Architect

    3 weeks ago

    DIGITALSPEC Washington, United States

    Job Description · Job DescriptionPosition: Cloud Engineer/Architect · Location: Washington, DC (Currently, this program supports 3 days Remote and 2 days onsite per week) · Education: BS degree in Computer Science. Engineering, or related field, or equivalent experience · Clearan ...

  • USAJobs

    ENGINEER or ARCHITECT

    3 weeks ago

    USAJobs Washington D.C., United States Full time

    DutiesYou will evaluate architect-engineer (A/E) project resources, work methods, processes, and staffing to initiate actions that will reduce cost or increase productivity. · You will develop project budgets to secure funds for proposed multi-year, multi-billion dollar faciliti ...

  • VTG

    Naval Architect Engineer with Security Clearance

    2 weeks ago

    VTG Washington, United States

    Overview VTG is staffing a Naval Architect Engineer for professional support services contract related to the planning, design, construction, delivery, and testing of ships overseen by the Guided Missile Frigate (FFG) Program Office (PMS 515). VTG is tasked with providing these s ...

  • Sayres & Associates

    Senior Naval Architect/Marine Engineer

    2 weeks ago

    Sayres & Associates Washington, United States

    Job Description · Job DescriptionSayres, a distinguished leader in defense support services to the DOD, is currently seeking an experienced Senior Naval Architect/Marine Engineer (Modeler) with a current SECRET clearance, verifiable in DISS in Washington, DC to support the PMS 30 ...

  • Soft Tech Consulting Inc

    Software Engineer/Architect

    2 weeks ago

    Soft Tech Consulting Inc Washington D.c., United States

    Soft Tech Consulting is seeking a highly motivated, self-directed individual to fill the role of a Software Engineer/Architect. The selected individual will join a collaborative team environment where they will provide support and expertise necessary toward the successful deliver ...

  • C3EL

    System Engineer/Architect

    3 weeks ago

    C3EL Washington, United States

    Job Description · Job DescriptionC3EL is seeking a versatile and driven System Engineer/Architect to join our expanding team.The ideal candidate will possess a unique blend of technical expertise, problem-solving skills, and a passion for innovation. Working with C3EL, you will h ...

  • U.S. Department of the Interior

    Interdisciplinary Engineer/Architect

    1 week ago

    U.S. Department of the Interior Washington, United States

    Job Description (Please follow all instructions carefully) Summary · This position is part of the Office of Facilities and Administrative Services, Space and Alterations Branch. The incumbent serves as an Engineer / Architect, responsible for assisting in the technical qualit ...

  • Secure Technologies Group

    Senior Systems Engineer/Architect ONI

    1 week ago

    Secure Technologies Group Washington, United States

    Work with senior leaders at the Office of Naval Intelligence · We are looking for a Senior System Engineer with Architecture experience to support of the Office of Naval Intelligence (ONI). This position will directly support the PM and other senior members of the Partnerships an ...

  • Vector CSP

    Marine Engineer/Naval Architect, Journeyman

    5 days ago

    Vector CSP Washington, United States

    Job Description · Job DescriptionJob Summary: · The United States Coast Guard (USCG), Office of Acquisitions, National Security Cutter (NSC) Program Management Office (PMO) (COMDT (CG is in the later stage of the acquisition lifecycle as a fully mature program. The USCG NSC Progr ...

  • USAJobs

    General Engineer/Architect

    3 weeks ago

    USAJobs Washington D.C., United States Full time

    Duties · The individual selected for this position will perform the following duties: · - Serves as Project Manager with responsibility for managing the designs for multi-million-dollar construction projects which may include repair, renovation, rehabilitation, alteration and new ...

  • USAJobs

    General Engineer/Architect

    2 weeks ago

    USAJobs Washington D.C., United States Full time

    Duties · **This position is temporary in nature and is not to exceed 2 years. This is strictly a temporary appointment where there is no permanent need or permanent funding available for the work involved. This position is subject to the project needs of the Agency. Therefore, th ...

  • USAJobs

    supervisory engineer or architect

    1 week ago

    USAJobs Washington D.C., United States Full time

    DutiesYou will be responsible for the architect and engineering design program to ensure execution according to the schedule and compliance with established architectural and engineering standards. · You will evaluate the work of other engineers or architects to verify design co ...

  • Vector CSP

    Marine Engineer/Naval Architect, Journeyman

    2 weeks ago

    Vector CSP Washington, United States

    Job Description · Job DescriptionJob Summary: · The United States Coast Guard (USCG), Office of Acquisitions, National Security Cutter (NSC) Program Management Office (PMO) (COMDT (CG is in the later stage of the acquisition lifecycle as a fully mature program. The USCG NSC Progr ...

  • Nodel

    Security Splunk Architect/Engineer

    2 weeks ago

    Nodel Washington, United States

    Job Description · Job DescriptionSecurity Splunk Architect/Engineer · Location: Washington DC metro area (Hybrid) · Must have an active Secret OR Top Secret Clearance · We are seeking a Security Splunk Architect/Engineer to support a Navy enterprise network within the Engineering ...