Business Intelligence Data Warehouse Consultant

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.