Trilogy Federal - Washington, DC
posted about 2 months ago
Trilogy Federal, LLC. is seeking a SQL Developer to support the data analytics needs of a large Federal agency, specifically the Veterans Health Administration (VHA). The ideal candidate will have extensive experience in SQL development and a strong understanding of the unique data requirements associated with the VHA. This role involves conducting comparative, trend, and predictive analysis of various data sets, preparing comprehensive reports that aid in decision-making and communication. The SQL Developer will be responsible for working with large and complex data sets, ensuring that the data is accessible and usable for analysis. The SQL Developer will design multi-dimensional systems using SQL Server Analysis Services (SSAS) star schema, which simplifies access to diverse data for efficient analysis. This includes creating flexible designs that can accommodate data from multiple sources with varying structures. The role requires proficiency in SQL/PL SQL for database creation, development, and maintenance, as well as experience in building reports using Power BI from OLAP multi-dimensional databases. The candidate will also assist in designing scalable automated reporting processes to deliver high-quality reports consistently and efficiently. The position demands a strong analytical mindset, problem-solving skills, and the ability to communicate effectively with both end-users and senior client stakeholders. The SQL Developer will need to manage multiple tasks concurrently in a fast-paced, collaborative virtual environment, demonstrating a detail-oriented consulting approach with a client-service focus. A self-starter attitude is essential, as the role requires both independent work and teamwork to achieve project goals.