Trilogy Federal - Washington, DC
posted about 2 months ago
Trilogy Federal, LLC. is seeking a Senior 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 data analytics within the context of federal agencies. This role involves conducting comparative, trend, and predictive analysis of various data sets, preparing comprehensive reports that aid in decision-making and communication. The candidate must be adept at working with large and complex data sets, managing multiple sources, and adapting to changing requirements. The Senior SQL Developer will be responsible for designing multi-dimensional systems using SQL Server Analysis Services (SSAS) star schema, which simplifies access to diverse data for efficient analysis. This includes uncovering trends and enabling timely, informed decisions. The role requires proficiency in SQL/PL SQL for creating, developing, and maintaining databases, as well as 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. To succeed in this position, the candidate must possess a Master's degree and have over 10 years of related experience, particularly with Power BI, SQL/PL SQL, database design, and ETL processes. A detailed understanding of Microsoft applications and strong analytical, problem-solving, and communication skills are essential. The ability to create executive-level documentation and reports, along with a solid understanding of IT architecture concepts, is also required. The candidate should be able to interface well with end-users and senior client stakeholders, manage multiple tasks concurrently, and work effectively in a fast-paced, collaborative virtual environment.