Simplify Logo

Full-Time

SQL Developer

Confirmed live in the last 24 hours

Trilogy Federal

Trilogy Federal

51-200 employees

Financial management and IT consulting for government

Data & Analytics
Consulting
Financial Services

Compensation Overview

$100k - $115kAnnually

Senior, Expert

Remote in USA

US Top Secret Clearance Required

Category
Data Management
Data Analysis
Data & Analytics
Required Skills
Power BI
Agile
SQL
PowerPoint/Keynote/Slides
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
  • 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
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

Trilogy Federal provides financial management and information technology consulting services specifically for the Federal government. Their work involves assessing and improving financial management solutions to ensure they meet the necessary business and reporting requirements. Trilogy's team, which has over 60 years of combined experience, helps federal clients migrate to new financial management systems or enhance existing ones. They focus on achieving fiscal compliance and audit readiness by utilizing advanced Business Intelligence and Business Performance Management tools to evaluate financial operations and deliver accurate financial reporting. What sets Trilogy apart from competitors is their extensive experience and proven success in implementing effective financial management solutions for a diverse range of federal agencies. The company's goal is to support federal clients in achieving their financial management objectives and ensuring they are prepared for audits.

Company Stage

N/A

Total Funding

N/A

Headquarters

Arlington, West Virginia

Founded

2009

Growth & Insights
Headcount

6 month growth

5%

1 year growth

5%

2 year growth

5%
Simplify Jobs

Simplify's Take

What believers are saying

  • Trilogy Federal's extensive experience and proven track record in federal financial management make it a trusted partner for government agencies.
  • The company's SDVOSB status can provide preferential access to certain government contracts, potentially leading to more business opportunities.
  • Trilogy's commitment to using advanced tools for financial reporting and business performance management can lead to more efficient and effective financial operations for clients.

What critics are saying

  • The niche focus on federal financial management may limit Trilogy's market to government contracts, making it vulnerable to changes in government spending.
  • Dependence on a small number of key clients could pose a risk if any of these clients were to reduce their spending or switch to a competitor.

What makes Trilogy Federal unique

  • Trilogy Federal is a verified service-disabled, veteran-owned small business (SDVOSB), which provides a unique advantage in securing government contracts.
  • The company has a leadership team with over 60 years of combined experience in federal financial management, setting it apart from competitors with less specialized expertise.
  • Trilogy's focus on fiscal compliance and audit readiness, combined with the use of industry-leading Business Intelligence and Business Performance Management tools, ensures high-quality, reliable financial reporting for federal clients.