Contract Database Analyst/SME

Contract Database Analyst / Subject Matter Expert (SME) Job Type: Full-Time (FTE) Location: Remote Clearance: Public Trust (Required; Active Preferred) Experience Level: Senior (7 10 years) Position Overview The Contract Database Analyst/SME provides comprehensive support for the agency s contract data environment. Serving as the primary technical expert for all database-related activities, this individual ensures the accuracy, usability, security, and long-term viability of the agency s contract and procurement data. This role manages the full data lifecycle including database maintenance, PRISM data extraction, analytics and reporting development, and support for future system migration efforts. Key Responsibilities Database Development & Maintenance • Design, develop, and maintain database structures, tables, forms, queries, and dashboards • Utilize SQL Server, SharePoint Online, Microsoft Power Platform (Power Automate, Power Apps), and advanced Excel • Implement version-controlled change management processes with testing and documentation PRISM Data Extraction & Validation • Extract and validate procurement and contract data from PRISM and related systems • Reconcile data with FPDS-NG and OCFO financial records • Identify and resolve discrepancies to ensure audit readiness • Support Contracting Officers (COs) and CORs with data interpretation Reporting, Analytics & Dashboards • Develop and enhance Power BI dashboards for real-time contract visibility • Analyze trends in obligations, expenditures, and contract actions • Identify anomalies, risks, and inefficiencies • Respond to ad hoc data requests from leadership and program offices Transition & Legacy Data Support • Support migration to new contract writing or financial management systems • Develop data conversion strategies and legacy data repositories • Ensure integrity and accessibility of historical contract data • Collaborate with government stakeholders and system vendors Testing, QA & Documentation • Perform functional and regression testing of database updates • Develop and maintain technical documentation, workflows, and user guides • Provide SME-level troubleshooting for database and reporting issues Required Qualifications Education • Bachelor s degree in Information Technology, Computer Science, Information Systems, Data Analytics, Business Analytics, or related field Experience • Minimum 7 years of experience in database development, data analytics, or information management • Minimum 3 years of experience in a federal government or government contracting environment • Minimum 2 years of experience with Microsoft Power BI and/or SharePoint Online Required Technical Skills Database & Analytics • SQL Server (query development, data modeling, reporting) • Microsoft Power BI (dashboard and report development) • Advanced Excel (pivot tables, Power Query, complex formulas) • SharePoint Online (lists, libraries, administration) • Microsoft Power Platform (Power Automate, Power Apps) • Functional and regression testing of databases Data & Federal Systems • Experience with federal contract writing systems (PRISM, EZSource, or equivalent) • FPDS-NG data extraction and reconciliation • Knowledge of federal data governance and security frameworks • Technical documentation development • Data migration and system transition planning • Strong communication skills with both technical and non-technical stakeholders Preferred Qualifications Preferred Experience • Direct experience with PRISM (strongly preferred) • Experience supporting IBC (Interior Business Center) or similar shared service providers • Experience supporting federal financial or regulatory agencies • Knowledge of Oracle Federal Financials, SAP, or similar systems • Familiarity with Federal Acquisition Regulations (FAR) • Experience with federal data standards (DATA Act, FFMIA) • Experience with legacy data repositories and ERP/system migrations • Section 508 compliance awareness • FedRAMP/GovCloud awareness for Microsoft environments Preferred Certifications • Microsoft Certified: Power BI Data Analyst Associate (PL-300) • Microsoft Certified: Power Platform Developer Associate (PL-400) or Fundamentals (PL-900) • Microsoft Certified: Azure Data Fundamentals (DP-900) or Azure Database Administrator (DP-300) • Microsoft Certified: Information Protection and Compliance Administrator (SC-400) About The Company Headquartered in Leesburg, Virginia, Zenius Corporation is a HUBZone-certified small business. Zenius specializes in providing Grants Management, IT Modernization, Acquisition Management, and Financial Management services to Federal agencies. Zenius is selected by Inc 5000 as one of the fastest-growing companies in the DC Metro Area, awarded in 2025, 2024, 2021, and 2020. Zenius is also listed by Financial Times as one of the fastest-growing companies in the Americas in 2021. Zenius is an awardee of 2019 Best of Leesburg winner (Business Management Consultant category). Benefits Zenius Corporation is an employee-oriented company. Join us now and help us grow! We offer a competitive benefits package that includes paid holidays and paid time off, medical insurance including health, vision, dental insurance, 401K matching, Flexible Spending Account and flexible schedules, as per business needs. We also work with our employees on training and professional certification plans that benefit the employee. Equal Opportunity Employer Zenius Corporation provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws. Zenius complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training. Zenius Corporation expressly prohibits any form of unlawful employee harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status.