Demo

Business Intelligence Data Warehouse Consultant

pinnacle
Washington, DC Full Time
POSTED ON 3/7/2025
AVAILABLE BEFORE 6/7/2025

Job Description

Pinnacle Government Solutions is a minority-owned small business that provides Software and Cloud Engineering Solutions for our Department of Defense and Federal Civilian agencies. We bring SME-level expertise and over two decades of industry knowledge and experience. We believe in getting it right for our customers and our country.

We are seeking a Business Analytics Data Warehouse technical lead responsible for guiding the design, development, and implementation of data warehouse solutions to support the business analytics and reporting needs of our Federal Government customer’s applications and capabilities. This role involves collaborating with business stakeholders, analysts, and data engineers to ensure the data warehouse meets the organization's requirements and supports strategic decision-making. Delivery requires a strong presence in the National Capital Region while working in hybrid low and high-side development environments.

Responsibilities :

  • Lead the design and development of data warehouse architectures, including data models, schemas, and data flow diagrams to ensure the data warehouse structure supports efficient data storage, retrieval, and analysis.
  • Develop, implement, and maintain Extract, Transform, Load (ETL) processes to extract and integrate data from various sources, transform into suitable formats, and load into the data warehouse to provide a unified view of data for analysis and reporting.
  • Collaborate with business analysts, data scientists, and other stakeholders to understand their data needs and provide appropriate solutions ensuring the data warehouse meets the needs of the organization and supports decision-making.
  • Implement data security measures, including access controls, encryption, and auditing to protect sensitive data and ensure compliance with security policies and regulations.
  • Optimize the performance of the data warehouse, including query performance tuning, indexes, and partitions to ensure fast and efficient data storage, retrieval, and processing.
  • Create and maintain conceptual, logical, and physical data models to represent the structure and relationships of data within the data warehouse ensuring it supports business requirements and analytical needs.
  • Oversee all Data Warehousing work and present overview briefings and updates to Government leads, partners, and customers. This includes reporting on business area progress at performance improvement meetings as well as helping to identify opportunities for increased effectiveness, efficiency, scale, and impact.
  • Assist the Program Manager (PM) and Deputy PM (DPM) in distilling Data Warehouse requirements, communicating them to contract staff, and tracking progress against them.
  • Work closely with technical leads, database architects, data scientists, and Information Systems Security Officers (ISSO) to build and integrate applications and ensure secure and seamless data flow and accessibility with both internal and external systems.
  • Maintain daily communication with Government, and other contractor leads on requirements, mission priorities, performance measures, program goals and milestones, and support needs.
  • Provide a technical need summary to the government program manager and government technical lead, giving the client a consolidated roundup across all development efforts, with a special focus on areas that need client intervention.
  • Notify Government, PM and DPM of any issues or trends that pose a risk to mission priorities.
  • Collaborate and communicate effectively with internal and external teams of software developers, data scientists, system administrators, stakeholders, and clients.

Required Skills

  • Bachelor’s degree in engineering, computer science, data science, mathematics, or similar technical discipline.
  • Experience with managed cloud database services such as Amazon RDS and Redshift to perform tasks such as ETL, retrieval, analysis, and implementing cloud-native high availability and scaling.
  • Strong experience with business intelligence (BI) tools such as Tableau or Power BI to create interactive and shareable dashboards for effective visualization and reporting.
  • Strong understanding of Structured Query Language (SQL) fundamentals such as creating tables, views, stored procedures, joins, and writing complex queries. This includes knowledge of advanced SQL concepts like indexing, normalization, transactions, query performance optimization, and database schema design.
  • Familiarity with database modeling and tools like Cameo, ER / Studio, ERWin, or Toad Data Modeler can be useful for designing data warehouses and generating their schemas.
  • Familiarity with NOSQL databases such as MongoDB or DynamoDB is helpful since semi-structured and unstructured databases are becoming increasingly common.
  • Understanding of data security and privacy regulations along with knowledge of best practices and regulations like Risk Management Framework (RMF), Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs) guidance, and National Institute of Standards and Technology (NIST) Special Publication 800-53 catalog of database security controls.
  • Excellent written and verbal communication skills to facilitate collaboration and teamwork among teams, ensure documentation is clear, concise, and comprehensive to serve as both deliverables as well as a guide to users, developers, and future team members.
  • Active TS / SCI with CI Poly Required
  • About pinnacle

    Pinnacle Government Solutions is a minority-owned small business that provides Software and Cloud Engineering Solutions for our Department of Defense and Federal Civilian agencies. We bring SME-level expertise and over two decades of industry knowledge and experience. We believe in getting it right for our customers and our country.

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Business Intelligence Data Warehouse Consultant?

    Sign up to receive alerts about other jobs on the Business Intelligence Data Warehouse Consultant career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $80,838 - $103,226
    Income Estimation: 
    $98,772 - $126,519
    Income Estimation: 
    $113,567 - $162,206
    Income Estimation: 
    $98,772 - $126,519
    Income Estimation: 
    $124,737 - $157,493
    Income Estimation: 
    $132,928 - $192,066
    Income Estimation: 
    $135,553 - $179,566
    Income Estimation: 
    $180,040 - $239,859
    Income Estimation: 
    $301,033 - $439,918
    Income Estimation: 
    $141,014 - $186,880
    Income Estimation: 
    $180,084 - $244,913
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at pinnacle

    pinnacle
    Hired Organization Address Waco, TX Full Time
    Job Description Pinnacle Government Solutions is a minority-owned small business that provides Software and Cloud Engine...
    pinnacle
    Hired Organization Address Waco, TX Full Time
    Job Description Pinnacle Government Solutions is a minority-owned small business that provides Software and Cloud Engine...
    pinnacle
    Hired Organization Address Morgan Hill, CA Part Time|Temporary
    We are doing some incredible things here at Pinnacle. We’re all about challenging convention and doing the hard work it ...
    pinnacle
    Hired Organization Address Appleton, WI Full Time
    C* A *PL* I *CO - Core Values for our company C - Customer Second A - Accountability P - Passion for learning L - Love O...

    Not the job you're looking for? Here are some other Business Intelligence Data Warehouse Consultant jobs in the Washington, DC area that may be a better fit.

    Business Intelligence Data Warehouse Consultant

    Pinnacle Government Solutions, Washington, DC

    System Security Manager - Data Intelligence

    Data Intelligence, LLC, Quantico, VA

    AI Assistant is available now!

    Feel free to start your new journey!