Skip to Main Content

Data Warehouse Analyst/Reports Developer

DT Professional Services
Washington, DC
  • Expired: over a month ago. Applications are no longer accepted.
Job Description

Job Summary:

DT Professional Services is seeking a Data Warehouse Analyst / Reports Developer with broad skills in working to develop functional interfaces and representation of data flowing from the US Coast Guard software applications to the customer base. This program supports the US Coast Guard Office of Legal Policy AND Program Development (CG-LPD) and the USCG Investigative Service Headquarters (CGIS). The Data Warehouse Analyst is responsible for design, implement and support data warehousing. Implement business rules via stored procedures, middleware, or other technologies. Define user interfaces and functional specifications. Typically requires a bachelor's degree in area of specialty. Reports to the PM. The Data Warehouse Analyst work is generally independent and collaborative in nature. Contributes to moderately complex aspects of a project.


  • Provide full-time Business Intelligence/Data Analytics development. These services shall include designing and developing reports, dashboards and ad-hoc queries using Power BI and SQL Server Reporting Services, and Hexagon WebRMS’ On-Call Analytics (a Power BI- / SSRS based business intelligence tool.)
  • Build enterprise data and analytics solutions.
  • Gather reporting and analysis requirements from investigative analysts, database users, administrators, and CGIS leadership, and design and develop appropriate solutions.
  • Publish and integrate reports; conduct or coordinate tests to ensure intelligence is consistent with the defined needs and create or review technical design documentation to ensure the accurate development of reporting solutions.
  • Maintain a library of model documents, templates and/or other reusable knowledge assets and provide technical support for existing reports, dashboards or other tools.

Required Qualifications:

  • Ability to obtain and maintain a DoD Secret Clearance

Basic Qualifications:

  • The Data Warehouse Analyst / Reports Developer shall have two (2) or more years’ experience in data preparation, analytics and visualization.
  • The Data Warehouse Analyst / Reports Developer must be proficient in the use of Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, and SSIS.

Additional Qualifications:

  • Experience installing applications on servers.
  • Experience in accessing servers to function within the analytical software used (e.g., SSRS, SSMS, etc.).
  • Experience creating and linking dashboards between server and desktop environments.
  • Experience using Hexagon is preferable.

Powered by JazzHR


DT Professional Services


Washington, DC
20593 USA