MAR, the Division of Oasis Systems has an exciting opportunity for a Senior Data Analyst/Project Manager to support the Commodity Futures Trading Commission (CFTC) in Washington, DC. The contractor shall provide support in data analytics, data mining, large data manipulation, data exploration, data visualization and use of data analytic tools including descriptive, prescriptive, predictive analytics. Activities which the contractor may be requirement to perform include requirements analysis, system and database design, software development, testing, documentation, maintenance and production operations.
LOCATION: Washington, DC
SECURITY CLEARANCE: Ability to pass a Special Agreement Check (SAC) and a National Agency Check and Inquires (NACI) Background Investigation
JOB STATUS: Full-Time This position is contingent upon program award.
RESPONSIBILITIES: Under this task order the contractor shall:
- Meet with the Contracting Officer’s Representative (COR) within one week after task order award to deliver and discuss the preliminary transition-in plan.
- Draft a “challenge areas” deliverable that shall document and describe areas or tasks which the contractor believes could slow progress or need to be addressed as a critical path for the success of the task order.
- Submit a Master Program document which identifies each challenge area and submit to the COR.
- Meet weekly with the COR to review the contractor’s current status report of all ongoing and completed work, identifying impacts to schedule and task order budget.
- Provide meeting minutes for each meeting, including analyst design and close out
- Prepare all required reports, deliverables and other documentation in conformance with the Chicago Manual of Style (16th ed.) and the Microsoft Manual of Style which comprise the ODT Documentation Standards.
- Adhere to the CFTC Project Management Lifecycle (PMLC) process and use the
- SharePoint site and document templates provided by the COR.
- Ensure all programming/coding files are stored in the Team Foundation Server (TFS).
- For each analyst project, create a project management plan and schedule based on high level requirements. Continuously update the plan based on discussions with stakeholders, data analyst findings, and in depth understanding of user requirements.
- Work closely with the customer to gather and document project requirements.
- Perform data analysis to learn/understand the data and the question being answered.
- Independent research may be required to facilitate understanding.
- Perform data processing to manipulate the data to ready it for reporting or visualizations. Manipulation may involve standardizing the data, filtering the data, supplementing the data with reference data, linking the data to other data sources and/or formatting the data. This task may require data modelling skills and the use of intermediary tables to store the cleansed/manipulated data set.
- Create data reports and/or visualizations to present the data in ways that are meaningful, actionable and understandable to the customer. This tasks includes the use of charts, graphs, pivot tables, drill down reports, etc., to present the information.
- Test each project thoroughly before presenting it to the task order project manager for quality control. Document test results as part of the project closeout documentation.
- Create user document and project close out documentation. Host project close out meeting with the COR, customer and contract project manager to present documentation and to demo the final analytics.
- Create documentation as required under the PMLC and the Configuration Change Board (CCB) in order to move projects to the production environment.
- Coordinate with internal and external organizations providing data to understand and resolve improper data formatting and other integration issues.
- When using SAS to create analytics, create and maintain customized SAS stored processes and SAS Macro libraries.
- Participate in facilitated meetings between stakeholders at CFTC which may include regular status meetings, user acceptance testing meetings and ad hoc development discussions.
- Data analysis tasks may be varied. They will include complex data requests that require data mining, extraction, and query optimization services from Divisions throughout the CFTC.
- Perform risk analysis which may include a broad range of risk measures, (such as Value at Risk (VaR): computation and evaluation, VaR tracking (VaR evolution over time), Incremental (and marginal) VaR calculation for individual asset classes /positions, conditional VaR, stress testing).
- Assist business users, economists, statisticians, and others, as required, to support effective use of analytic techniques and CFTC-approved tools.
- As necessary, develop prototype procedures as well as design database tables, queries and views in MS SQL Server. Should the COR determine that the prototype should be enhanced to perform additional functionality or made available for a larger number of users.
- Conduct performance tuning and troubleshooting on data analytic packages such as SAS stored processes.
QUALIFICATIONS: The ideal candidate will have:
- A minimum of 8 years of relevant experience as a Data Analyst
- At least 2-4 years of Project Management experience to include defining and staying within the scope of the project, developing project schedules, monitoring overall progress and use of resources, and developing the budget.
MAR, the Division of Oasis Systems is an equal opportunity employer and does not discriminate in hiring or employment on the basis of any legally protected characteristic including, but not limited to, race, color, religion, national origin, marital status, gender, sexual orientation, ancestry, age, medical condition, military veteran status or on the basis of physical handicap which, with reasonable accommodation, render the application to satisfactorily perform the job available.