Database Specialist
Database Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 105000 - 125000
1 Vacancy
Job Description
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 detailoriented Database Specialist to support largescale 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 clientfacing 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: $105000 to $125000
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 highvolume data ingestion 100000 rows 25 columns) across multisite multiyear 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 clientfacing reports including balance sheet reports detailed cost estimates and year over year data comparisons.
- Ensure data quality consistency and traceability across complex datasets involving sitelevel phases multiyear 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 jobrelated 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 projects lifecycle
- Advanced Excel skills including macro development and complex data processing.
- Experience working with large datasets 100000 rows) with attention to performance and scalability.
- Ability to translate raw data into clientready reports with a focus on clarity and accuracy.
- Strong analytical troubleshooting and problemsolving 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 preemployment 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 governments mission with compassion and heart. To learn more about CNSP visit .
#CherokeeFederal #LI
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
Keywords:
- Data Management
- Data Analysis
- Database Administration
- Data Integrity
- Data Reporting
Legal 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 preemployment qualifications of Cherokee Federal.
Many of our job openings require access to government buildings or military installations. Candidates must pass preemployment qualifications of Cherokee Federal.
Required Experience:
Unclear Seniority
Employment Type
Full-Time
