Job details

Sr. Database Designer

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.

We are seeking a highly skilled and experienced Senior Database Designer to lead the design and support of complex databases within a critical program at the Department of Veterans Affairs (VA). This position demands extensive knowledge of VA systems, enterprise data reporting, and the ability to manage sensitive healthcare data securely. The ideal candidate will have a robust background in database technologies, experience with Electronic Health Records (EHR) systems, and proficiency in Structured Query Language (SQL) queries, especially in the context of VHA’s Clinical Data Warehouse (CDW). This role requires a strategic thinker with the ability to manage software development teams and navigate the complexities of major database technologies.

Please note, this position is contingent upon award (expected July/August 2024).

Primary 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.

Minimum 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.

Preferred Qualifications:

VA or VBA experience

Benefits (including but not limited to):

Health, dental, and vision plans
Optional FSA
Safe Harbor 401(k) with employer contributions 100% vested from day 1
Paid parental leave
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

$138,000 - $150,000 a year

This range is not a guarantee of compensation or salary, as Trilogy Federal conducts an individual equity review for every candidate based on experience, location, education, industry experience, and comparisons to internal pay bands. In addition to salary, Trilogy offers robust benefits including medical/dental/vision insurance coverage, 401(k) match, paid holidays, paid time off, tuition reimbursement, and a very supportive work/life balance.

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.

Trilogy Federal Glassdoor Company Review

4.0