Full-Time

SQL Developer

Posted on 9/3/2024

Trilogy Federal

Trilogy Federal

51-200 employees

Financial management and IT consulting services

Data & Analytics
Consulting
Financial Services

Compensation Overview

$100k - $115kAnnually

Senior

Remote in USA

Virtual employment available in Colorado, Connecticut, D.C., Florida, Georgia, Illinois, Maryland, New York, South Carolina, Texas, and Virginia.

US Top Secret Clearance Required

Category
Data Management
Data Analysis
Data & Analytics
Required Skills
Power BI
Agile
Data Science
SQL
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

Simplify Jobs

Simplify's Take

What believers are saying

  • Increased demand for cybersecurity consulting services in federal agencies.
  • Growing interest in AI-driven financial management solutions within federal agencies.
  • Increased funding for veteran-owned businesses in federal contracts.

What critics are saying

  • Increased competition from larger consulting firms like Deloitte and Accenture.
  • Potential budget cuts in federal spending on consulting services.
  • The shift towards digital transformation may require rapid adaptation of services.

What makes Trilogy Federal unique

  • Trilogy Federal is a service-disabled, veteran-owned small business (SDVOSB).
  • The leadership team has over 60 years of combined federal financial management experience.
  • Trilogy specializes in federal financial management with multiple relevant certifications.

Help us improve and share your feedback! Did you find this helpful?

Benefits

Health Insurance

Dental Insurance

Vision Insurance

401(k) Company Match

Paid Vacation

Paid Holidays

Pet Insurance

Phone/Internet Stipend

Tuition and Training Reimbursement

INACTIVE