What are the responsibilities and job description for the Business Intelligence Data Warehouse Consultant position at pinnacle?
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
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.