Trilogy Federal provides financial management, information technology (IT) consulting, program management services, and strategic consulting to federal agencies. Trilogy has an extensive history helping federal clients achieve their most ambitious business modernization and optimization goals with the ability to deliver targeted subject matter expertise and full life cycle support.
Trilogy Federal, LLC. (Trilogy) is looking for a SQL Developer to support a large Federal agency’s data analytics needs. The chosen candidate must have related experience with the Veterans Health Administration (VHA).
Primary Responsibilities:
- Assist in conducting comparative, trend, and predictive analysis of a variety of data and prepare comprehensive reports of the analysis that are useful in decision-making, and communication
- Must possess skillsets to work with large and complex data sets, multiple sources, and changing requirements
- Design multi-dimensional systems using SSAS’s star schema that create simplicity in accessing diverse data to perform efficient and fast analysis on large amounts of data, uncover trends and make timelier, better-informed decisions. The designs must be flexible to accept data from multiple data sources with varying structures and compatible with existing sources and structures
- Utilize SQL and PL/SQL to create, develop, and maintain databases
- Build reports using Power BI from the OLAP multi-dimensional databases
- Adept at working with various data management systems and assist in designing scalable automated reporting processes that can deliver high quality reports efficiently and consistently
Minimum Requirements:
- Bachelor’s degree
- 8+ years of related experience
- Experience with the following: Power BI, SQL and PL/SQL, Database design and ETL (data extraction, transform, and load), and an understanding of big data concepts
- Proficient experience creating, developing, and maintaining SQL databases
- Experience with the Veterans Health Administration (VHA) is required
- The ability to obtain a Public Trust Clearance
- Detailed understanding of Microsoft applications (Word, Excel, PowerPoint, Outlook, SharePoint) and their features/functions
- Strong analytical, problem-solving, communication, and facilitation skills
- Experience with creating executive-level documentation and reports
- General understanding of IT System Development Life Cycle and Agile concepts
- Possesses a solid understanding of IT architecture concepts
- Ability to interface well with end-users and senior client stakeholders
- Ability to prioritize and manage multiple tasks concurrently
- Ability to work in a fast-paced and collaborative virtual environment
- Detail-oriented consulting approach, with client-service focus
- Self-starter with the ability to work independently and within a team
Preferred Qualifications:
- Possesses an advanced degree or credential (e.g., BIDA) in data analytics or business intelligence
- Experience with Tableau
- VA or VBA experience
- Experience with or general understanding of VA data analytic platforms, repositories, or tools
Benefits (including but not limited to):
- Health, dental, and vision plans
- Optional FSA
- Paid parental leave
- Safe Harbor 401(k) with employer contributions 100% vested from day 1
- Paid time off and 11 paid holidays
- No cost group term life/AD&D plan, and optional supplemental coverage
- Pet insurance
- Monthly phone and internet stipend
- Tuition and training reimbursement
Regarding remote positions, Trilogy Federal is able to offer virtual employment in the following states: Colorado, Connecticut, D.C., Florida, Georgia, Illinois, Maryland, New York, South Carolina, Texas, and Virginia.
Trilogy Federal is an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.
Top Skills
What We Do
Founded in 2009 and headquartered in the Washington DC metro area, Trilogy Federal is a verified service-disabled, veteran-owned small business (SDVOSB) providing financial management and information technology consulting to the Federal government. Trilogy has an extensive and distinctive history helping Federal clients achieve their financial management goals. Our leadership team has over 60 years of combined experience supporting Federal financial management initiatives. Our professional staff specializes in federal financial management and maintains certifications in several relevant programs.
Trilogy strives to provide its clients with a flexible and comprehensive approach to financial management with the ultimate goal of fiscal compliance and audit readiness. The Trilogy approach starts with assessing the financial management solution and determining its effectiveness in capturing functional business requirements and meeting agency reporting requirements. Since our inception, we have assisted our federal partners in migrating to new financial management systems or enhancing existing systems to meet new requirements. Ultimately, success lies in the data, where Trilogy utilizes industry leading Business Intelligence and Business Performance Management tools to assess the overall effectiveness of financial business operations and to produce timely, reliable and value-added financial reporting. We have a proven track record of successful implementations for agencies large and small.
