Cherokee Nation Strategic Programs (CNSP) is seeking a Data Engineer to support large-scale data management and reporting efforts for a critical Air Force environmental project. The role involves integrating, managing, and transforming data from various sources into an Azure SQL database and producing client-facing reports.
Requirements
- 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.
- 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.
Responsibilities
- 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.
Other
- US Citizenship required
- This position requires successfully passing a NACI (National Agency Check with Inquiries) investigation to obtain a CAC (Common Access Card).
- 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.
- Experience working in government contracting environments, especially supporting DoD projects.
