Data Analyst / Business Analyst For Financial Services - Contractor

Riskspan Washington , DC 20319

Posted 2 months ago

Business Analyst/Data Analyst

About RiskSpan

RiskSpan is a leading source of analytics, modeling, data and risk management solutions for the Consumer and Institutional Finance industries. We solve business problems for clients such as banks, mortgage-backed and asset-backed securities issuers, equity and fixed-income portfolio managers, servicers, and regulators that require our expertise in the market risk, credit risk, operational risk and information technology domains.

Job Description:

  • Perform analysis of large datasets created and used in the financial models and calculations; analyze the data elements and document the business user cases and detailed data requirements.

  • Assist with data modeling of tables in existing and new databases; create/review logical and physical attribute and table names, propose data type and display format, document table relationship and primary/foreign keys.

  • Lead cross-functional teams to migrate legacy databases to new databases (such as oracle and cloud databases); review the table structure, data inputs and data availability of the legacy and new databases, and perform manual testing to ensure data quality and integrity.

  • Perform data validation and reconciliation of different data sources to ensure data consistency and accuracy. Extract, query, analyze and transform source data using SAS and SQL and compare with outputs.

  • Assis project manager and product owner in managing work streams, documenting user stories and leading cross-functional team meetings. Act as the liaison between technical and business teams to collect, document and translate requirements; coordinate with developers, testers and manage delivery and acceptance of final products

  • Train/coach junior analysts and new hires

Qualifications:

  • Microsoft Office (Excel, Word, PowerPoint)

  • Database (Oracle, Netezza, AWS)

  • SQL and SAS programming

  • Project management and leadership experience

  • Outstanding written and communication Skills

  • Agile experience

  • Understanding of data modeling and financial/mortgage industry preferred

RiskSpan is proud to be an Equal Opportunity/Affirmative Action employer committed to hiring a diverse workforce and sustaining an inclusive culture. Qualified candidates must be legally authorized to be employed in the United States on an unrestricted basis.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Financial Management Analyst (Inl PSS Wash DC)

Atsg Corporation

Posted Yesterday

VIEW JOBS 12/10/2019 12:00:00 AM 2020-03-09T00:00 <strong>Financial Management Analyst</strong><br /> United States Department of State<br /> INL office at State Annex-1 (SA-01),<br /> Columbia Plaza, 2401 E Street NW<br /> Washington, DC<br /> <strong>Requires: Secret Security Clearance (May begin work with an Interim Secret Clearance)</strong><br />  <br /> ATSG Corporation is seeking qualified candidates to fill a position for a Financial Management Analyst to support the INL’s Management Assistance and Post Support (MAPS) division (INL/EX/MAPS).<br />  <br /> The U.S. Department of State is the lead institution for the conduct of American diplomacy and the Secretary of State is the President’s principal foreign policy advisor. The Department of State’s mission is to advance U.S. national security interests, fight terrorism, protect U.S. interests abroad, and implement foreign policy initiatives that build a freer, prosperous and secure world.<br />  <br /> The Bureau of International Narcotics and Law Enforcement Affairs (INL) keeps Americans safe at home by countering international crime, illegal drugs, and instability abroad. INL helps countries deliver justice and fairness by strengthening their police, courts, and corrections systems. These efforts reduce the amount of crime and illegal drugs reaching U.S. shores.<br />  <br /> INL’s Management Assistance and Post Support (MAPS) division is responsible for supporting the post-award contract management function. The division’s customers include INL program managers, contracting officers (CO), and contracting officer’s representatives (COR). MAPS professionals serve as information brokers between contract management stakeholders in acquisition, resource management, and corporate communities. MAPS closely teams with stakeholders to monitor contractor performance, ensure that cost, service quality and delivery schedules are in compliance with terms and conditions of the contract, and to ensure the application of sound financial management and administrative control.<br />  <br /> <strong>Duties and Responsibilities:</strong><br />   <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Review purchase requests and miscellaneous obligation document requests to assist in the determination of the appropriate accounting data (fiscal year (FY), appropriation, allotment codes, function codes, object classification codes, project codes) and certify fund availability based on apportionments and allotments.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Determine if funds are available for de-obligation based on reviews of Unliquidated Obligations (ULOs).</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Determine amounts available for reclassification or reprogramming. The contractor shall determine the type, country, purpose and status of obligations, points of contact and supporting documentation. Determine which obligations are available for reclassification/reprogramming.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Create and run reports from the Department’s accounting system of record reporting system. Run reports for specific accounting data and fiscal years and export spreadsheets to create workbooks for future reference and/or verify data between two workbooks/worksheets using formulas or other Microsoft functionality to identify the benefiting country or program.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Determine the original funding of obligation document numbers to include analyzing and tracking approved apportionments, researching electronic or paper files and coordinating with other Department offices to acquire necessary information. Create spreadsheet presentations, which track beginning funding, amounts that have been obligated, expended, de-obligated, reclassified, reprogrammed, transferred, and remaining balances and use these spreadsheets to prevent Anti Deficiency Act violations.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Respond timely to requests for information regarding the reconciliation of agreements, amendments, and reprogramming of funds and track all pertinent information relating to these activities in established Department-wide financial system and Excel spreadsheet logs.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;"> Interact positively and work cooperatively with team members and points of contact to accomplish assigned work in a timely and efficient manner.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Comply with all internal controls and procedures to protect organizational integrity and prevent unauthorized use or misappropriation of all classified and sensitive material and equipment in assigned areas.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Provide financial guidance to program officers and project managers, as well as to personnel in program countries, as appropriate. Provide advice and assistance to other staff members, and senior managers on financial management and processing problems or issues.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Assist in the formulation and implementation of major policies for the accounting of INL country program funds (e.g. imposition of internal limitation on expenditures, tracking and monitoring requirements, and prepares recommendations to senior management, to include the Assistant Secretary on areas where funds may be reprogrammed and how best to account for fund usage, etc.).</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Perform studies and audits on internal controls and use of funds throughout the year to ensure appropriateness of obligations incurred and that resulting expenditures of funds are in accordance with pertinent laws, e.g. Foreign Assistance Act, appropriations laws, legislation, and other specific, INL related regulations</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Identify areas requiring process improvement. Develop and recommend modifications of methods, processes, and techniques to resolve accounting or auditing problems and explain changes to all staff members and overseas posts, when appropriate, to ensure awareness of and familiarity with new procedures.</li> </ul> <strong>Minimum Qualifications:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">U.S. Citizenship.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Secret Security Clearance. </li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Bachelor's degree from an accredited institution and two to ten years’ experience at the equivalent GS-12 or higher level; <u>or</u> an Associate's degree from an accredited institution and a minimum of twelve (12) years’ experience at the equivalent GS-12 or higher level.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Proficient in Microsoft Office Suite; strong multi-tasking and organizational skills.</li> </ul> <strong>Preferred Qualifications:</strong> <ul> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Knowledge of bookkeeping and Generally Accepted Accounting Principles to maintain/monitor control of funds, including reconciliation of variances between system records and obligation ledgers.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Ability to communicate effectively both orally and written.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">A Bachelor’s Degree from an accredited university in Business Administration, Accounting, Financial Management or related finance field.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience with Department of State (DOS) financial systems to include: GFMS, RFMS, Data Warehouse, COAST and the peripheral systems used by the Department.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience with Federal Government No-Year, Multi-Year and Annual Appropriations.</li> <li style="padding: 0; margin: 0;" style="padding: 0; margin: 0;">Experience with Federal Regulations, such as Appropriation Law, Federal Travel Regulation, Federal Acquisition Regulation, etc.</li> </ul>  <br />  <strong><em>*Candidates are encouraged to submit a .doc or .docx resume that explicitly addresses each of the requirements listed above.</em></strong><br /> <br /> <em>As an Equal Opportunity Employer, our applicants and employees are protected from discrimination. Visit </em><a href="http://bit.ly/FederalEEO"><em>http://bit.ly/FederalEEO</em></a><em> for more information.</em><br />  <br /> <em>Equal access to programs, services and employment is available to all persons. Those applicants requiring reasonable accommodation to the application and/or interview process should notify a representative of the Recruiting Team. </em><br />  <br /> <em>This contractor and subcontractor shall abide by the requirements of 41 CFR 60-300.5(a) and 60-741.5(a). These regulations prohibit discrimination against qualified individuals on the basis of protected veteran status or disability and require affirmative action by covered prime contractors and subcontractors to employ and advance in employment qualified protected veterans and individuals with disabilities. To comply with Federal law, ATSG Corporation participates in E-Verify.  Successful candidates must pass the E-Verify process after hire. <br />  <br /> We respectfully request not to be contacted by recruiters and/or staffing agencies.</em><br />  <br />   Atsg Corporation Washington DC

Data Analyst / Business Analyst For Financial Services - Contractor

Riskspan