Database Specialist with Security Clearance

Database Specialist This position requires successfully passing a NACI (National Agency Check with Inquiries) investigation to obtain a CAC (Common Access Card). We are seeking a skilled and detail-oriented Database Specialist to support large-scale data management and reporting efforts for a critical Air Force environmental project. This individual will be responsible for integrating, managing, and transforming data from SharePoint lists and libraries into an Azure SQL database and producing client-facing reports based on that data. The role requires strong technical expertise in database operations, data extraction and transformation, automation (including macros), and advanced Excel reporting. Compensation & Benefits: Estimated Starting Salary Range for Database Specialist: $105,000 to $125,000 Pay commensurate with experience. Full time benefits include Medical, Dental, Vision, 401K, and other possible benefits as provided. Benefits are subject to change with or without notice. Database Specialist Responsibilities Include: Extract and integrate data from large SharePoint lists, libraries, and Excel spreadsheets into Azure SQL databases. Develop, document, and maintain macros or scripts to automate data extraction and transformation processes. Manage, update, and optimize Azure SQL database structures to support high-volume data ingestion (100,000+ rows, 25+ columns) across multi-site, multi-year project data. Prepare and maintain efficient, reusable, and reliable VBA for Microsoft Office (Excel, Access, SharePoint, Outlook, and Word) applications Investigate and troubleshoot issues, monitor defect tracking system, and create and maintain resolution to known problems or errors. Create, maintain, and automate generation of client-facing reports, including balance sheet reports, detailed cost estimates, and year over year data comparisons. Ensure data quality, consistency, and traceability across complex datasets involving site-level phases, multi-year cost tracking, and historical versions. Collaborate with project managers, technical leads, senior cost estimators, and leadership to support reporting deadlines and client requirements. Document database processes and workflows to support knowledge transfer and operational continuity. Performs other job-related duties as assigned Database Specialist Experience, Education, Skills, Abilities requested: 5+ years of experience in database management and reporting. Strong proficiency in Azure SQL Database (data ingestion, transformation, optimization). Experience pulling and manipulating data from large SharePoint lists and libraries. Experience pushing data from SQL to SharePoint lists to provide status updates over the course of each project's lifecycle Advanced Excel skills, including macro development and complex data processing. Experience working with large datasets (100,000+ rows) with attention to performance and scalability. Ability to translate raw data into client-ready reports with a focus on clarity and accuracy. Strong analytical, troubleshooting, and problem-solving skills. Ability to work in a high paced environment. Ability to communicate effectively, both orally and in writing. Excellent attention to detail and commitment to meeting deadlines. Experience working in government contracting environments, especially supporting DoD projects. Familiarity with environmental project data, cost estimation reporting, or similar financial reporting. Experience with Power BI, SSIS (SQL Server Integration Services), or other ETL (Extract, Transform, Load) tools. Knowledge in Adobe Acrobat including form development and maintenance. Must pass pre-employment qualifications of Cherokee Federal Company Information: Cherokee Nation Strategic Programs (CNSP) is a part of Cherokee Federal - the division of tribally owned federal contracting companies owned by Cherokee Nation Businesses. As a trusted partner for more than 60 federal clients, Cherokee Federal LLCs are focused on building a brighter future, solving complex challenges, and serving the government's mission with compassion and heart. To learn more about CNSP, visit Cherokee Federal is a military friendly employer. Veterans and active military transitioning to civilian status are encouraged to apply. Similar searchable job titles: Data Analyst Data Coordinator Data Manager Data Technician Data Administrator Disclaimer: All qualified applicants will receive consideration for employment without regard to protected veteran status, disability or any other status protected under applicable federal, state or local law. Many of our job openings require access to government buildings or military installations. Candidates must pass pre-employment qualifications of Cherokee Federal. Many of our job openings require access to government buildings or military installations. Candidates must pass pre-employment qualifications of Cherokee Federal.