Great Hill Solutions is part of the Seneca Nation Group (SNG) portfolio of companies. SNG is the federal government contracting business wholly owned by the Seneca Nation. SNG meets mission-critical needs of federal civilian, defense, and intelligence community customers across a variety of domains. The SNG portfolio receives shared services support from its parent company Seneca Holdings and is comprised of multiple companies that participate in the Small Business Administration 8(a) program. To learn more visit www.senecanationgroup.com and follow us on LinkedIn.

The Seneca Nation Group companies offer competitive compensation and a strong benefits package including comprehensive medical and dental care, matching 401K, paid time off, flexible spending accounts, disability coverage, and other benefits that help provide financial protection for you and your family. We pride ourselves on our collaborative work environment and culture which embraces our mission of providing financial and non-financial benefits back to the members of the Seneca Nation.

Great Hill Solutions is seeking a highly motivated Data Management/SharePoint Specialist. The candidate will provide direct support to the DSCA to track and manage use case requirements for Security Cooperation (SC) data and identify opportunities to improve workflow, individual productivity, and time-to-market for data and analytic products. The candidate will be responsible for providing subject matter expert assigned in support of the Regional Portfolio Directors (RPDs) or Country Portfolio Directors (CPDs) in their oversight of the U.S. Government’s Security Cooperation (SC) programs. Services will include, maintaining automated SC management processes and their accompanying business rules to make advanced technology solutions more accessible; assist the GCD team with data-intensive RFIs to identify the appropriate data source for information, analyze the data, and present the data in an accessible manner; build common resources to ease program management for RPDs and support teams including program trackers and case trackers that allow information to be accessed more rapidly; apply the capabilities of such tools as Microsoft Power BI (Business Intelligence) and Power Automate to identify potential process improvements in displaying data and creating workflows models for developers to incorporate into Socium; learn the capabilities of Socium workflows to identify process improvements and ease the transition of Socium users to the new product; conduct final reviews on Training & Equipment List formulas to verify consistency and accuracy across all GCCs to foster the creation of CN Table information; Identify additional areas in need of data analysis or process innovation; Lead tutorials for DSCA government and contractor personnel related to data acquisition, management, analysis, and presentation. 

Responsibilities include but are not limited to:  

• Preparation of PowerPoint briefings, Excel spreadsheets, and Word documents; provide input and update FMS management programs on both NIPR (unclassified) and SIPR (classified) systems to include the Security Cooperation Management System (SCMS) and the Security Cooperation Information Portal (SCIP); analyze FMS case data and research FMS policy issues.

• Provide research and analysis of data to develop draft response packages for RPDs/CPDs, and Program Leads to fulfill country unique congressional reporting requirements via the appropriate committees. 

• Organize and maintain data in clear, accurate format for easy access and use. 

• Perform regular data reviews and updates to ensure information remains accurate. 

• Collect and organize data sent by email from customers and stakeholders or arriving by other means. This data usually arrives in spreadsheets, Word documents, or email text. Export or transfer data to database systems and/or spreadsheets as requested to agency leadership and stakeholders of current information. In coordination with DSCA personnel, develop, test, and implement process and technical improvements to enhance the efficiency and transparency of the management of data and other information associated with the planning, execution, funding, and reporting on of BPC and other DSCA programs. 

• Produce SCIP, SCMS, DSAMS, SOCIUM, and Advana generated reports, staff meeting and Combatant Commander Priority Slides; Produce Trip Books and Read-Ahead packages. Support for Requests for Information (RFIs) to support internal DSCA requirements, and external agencies, including DOD IG and GAO Audits. Support preparation of Congressional Notification and other formal documents. 

• Update Staff Meeting slides, develop and share weekly program telecom agenda and updates, SCMS reports, including the Pending Case Tracking Report (SCMS); Equipment Transfer Reports (Word) and others. 

• Pull and review DSAMS reports, such as RP069, and case status and milestone reports. Review and update inputs for Combatant Commander Priority Slides and other requested reports. 
• Produce Equipment Transfers under Section 333 Authority (Congressional Report), Special Inspector General for Iraq Reconstruction Reports (DoD Report), or other reports. 

Requirements and Qualifications  

• A current active SECRET clearance.

• A master’s degree is required in a related field of study and 5+ years’ experience supporting Federal or DoD enterprise data management projects in a security cooperation environment.

• Additional certifications in teaching quantitative methods and prior experience teaching or presenting topics related to data analysis, technology, mathematics, or similar topics is capability above threshold minimum requirements.
• Knowledge of current Security Cooperation data platforms including Socium, SCIP, DSAMS, Advana, SC- COP, DAI, and/or OHASIS is a capability above threshold minimum requirements.
• Advanced proficiency with Excel including the ability to analyze and evaluate data, write complex formulas, combine data from multiple sources, write basic macros using VBA to automate repetitive tasks, clean data, create pivot tables, transform data using Power Query, and develop statistical models to present data is required. Proficiency in MS Office Suite applications Outlook, Word, and PowerPoint is required. 
• Experience in developing SharePoint applications using designer and other SharePoint technologies.

Desired Qualifications  

• Self-motivated, detail oriented, responsible team player able to work independently with minimal daily direction
• Ability to work with web development tools and languages such as JavaScript, HTML, or CSS
• Strong communication and collaboration skills to interact effectively with technical and non-technical stakeholders.
• Other duties as assigned