Simplify Logo

Full-Time

Sr. Database Designer

Posted on 7/3/2024

Trilogy Federal

Trilogy Federal

51-200 employees

Financial management and IT consulting for government

Consulting
Government & Public Sector
Financial Services

Compensation Overview

$135k - $140kAnnually

Senior

Remote in USA

Category
Data Management
Data & Analytics
Required Skills
SQL
Postgres
MongoDB
Oracle
Requirements
  • Master’s degree or higher in Computer Science or equivalent discipline
  • 8+ years of experience in database design and support, with a focus on VA systems
  • 5+ years of experience in enterprise data reporting and writing advanced SQL queries
  • Proficient understanding of the VHA’s CDW and the ability to chain adjacent hospital admissions for accurate determination of hospitalization duration relevant to VBA benefits
  • 1+ years of experience with Cerner EHR and VA health data migrations efforts
  • Familiarity with major EHR systems (i.e., Epic, Cerner) and data exchange formats such as FHIR, Blue Button, and CCDA
  • Extensive experience in managing software development teams and proficiency with major database technologies including Oracle, SQL Server, Postgres, and MongoDB
  • Strong knowledge and experience in managing and controlling sensitive healthcare data (PHI, PII, etc.)
  • Well-versed in SDLC and project management methodologies
  • Exceptional analytical and problem-solving skills with the ability to manage complex data integration challenges
  • Strong leadership qualities with experience in mentoring and developing technical teams
  • Excellent communication skills, capable of engaging with technical and non-technical stakeholders alike
  • A proactive approach to staying informed on the latest technologies and best practices in database design and data management
Responsibilities
  • Database Design and Support: Lead the design, implementation, and maintenance of complex databases, ensuring high levels of data quality and accessibility for business intelligence, reporting, and decision-making processes
  • Enterprise Data Reporting: Develop and oversee enterprise data reporting strategies, utilizing advanced SQL querying techniques to extract, analyze, and report data critical to the determination of entitlement to VBA benefits under Title 38 of the Code of Federal Regulations
  • System Integration and Data Migration: Manage the integration of VA systems including SDP, VBMS, VHA’s CDW, VistA, CAPRI, and VBA’s Corporate Database with modern EHR systems like Cerner, ensuring seamless data migration and interoperability
  • Team Leadership: Lead and manage software development teams, fostering a collaborative environment and ensuring the successful delivery of database projects on time and within budget
  • Data Security and Compliance: Ensure the management and control of sensitive healthcare data, adhering to all relevant laws and regulations regarding PHI and PII, and implementing best practices in data security
  • Technology Proficiency: Stay current with major database technologies including Oracle, SQL Server, Postgres, and MongoDB, applying best practices in database design and maintenance
  • SDLC and Best Practices: Apply a deep understanding of the Software Development Life Cycle (SDLC) to all database projects, ensuring best practices in database architecture, design, and implementation

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

3%

1 year growth

3%

2 year growth

3%
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.

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

INACTIVE