Data Engineer

Data Engineer

US Citizenship required

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 Data Engineer 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 cloud-based database design, data pipeline design, operations, data extraction and transformation, automation (including macros), and advanced Excel reporting.

Compensation & Benefits:

Estimated Starting Salary Range for Database Engineer: $110,000 to $120,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.

Data Engineer Responsibilities Include:

• Extract and integrate data from large SharePoint lists, libraries, and Excel spreadsheets into Azure SQL databases.

• Develop, document, and design database pipelines to automate data extraction and transformation processes.

• Manage, update, and optimize Azure SQL database schemas 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 pipeline, database, and reporting scripts processes and workflows to support knowledge transfer and operational continuity.

Data Engineer Experience, Education, Skills, Abilities requested:

• 5+ years of experience in database management and reporting.

• Strong proficiency in Azure SQL Database (design, 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.

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

#CherokeeFederal #LI

#LI-RA1

Cherokee Federal is a military friendly employer. Veterans and active military transitioning to civilian status are encouraged to apply.

Similar searchable job titles:

• Data Engineer

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