Data Warehousing Director jobs in Lompoc, CA

Company Overview:
Integrated Data Services (IDS) is a leading provider of custom software products and Government financial management services. IDS was founded in 1997 in El Segundo, CA, and since that time has seen tremendous growth and success. Currently IDS has offices supporting customers nationwide. By providing customers with fast, efficient and reliable information systems and support services, IDS has become a preferred provider of financial and programmatic systems, services, and solutions across a wide variety of government agencies.

Position Description:
IDS is currently searching for Commitment/Obligation/Expenditure Reconciliation (C/O/E) Recon Analysts with experience in Department of Defense (DoD) financial management processes, government financial and accounting systems, acquisition and budgeting processes, and relational databases to provide support and training on-site to a government customer. This individual will analyze data from various Government accounting systems and Program Contractor inputs to support training which includes data collection, documentation, reconciliation of current, prior and cancelling year budgets, and budget execution.

Responsibilities include, but are not limited to, the following:

• C/O/E Reconciliation of all programs funding within AATS portfolio
• Recommend corrections to various organizations needed to update the information contained in databases used to monitor funds and ensure funding/budget information reported in the databases is current and accurate
• Compare the expenditure baseline to the obligation baseline to establish an Un-liquidated obligation (ULO) baseline
• Establish, maintain, and update a document-by-document C/O/E baseline for each contract
• Compare Government program office C/O/E records with Government accounting records to identify and record discrepancies found and identify the cause of the discrepancies and recommend corrective actions
• Research, generate, coordinate, and submit Corrective Action Instruction packages to resolve discrepancies and track the status of packages submitted to Defense Finance and Accounting Services and the Accounting and Finance Office
• Create a monthly report to track reconciliation actions completed and remaining and submit a final report summarizing all reconciliation efforts and unresolved discrepancies, with recommendations for corrective action
• Assist the Government with all financial reviews to ensure unliquidated obligations (ULOs) are recorded in the proper stage of accounting; valid and correct; not dormant; and ensure documentation exists to support the recording of the ULOs and Commitments
• Support all HHQ and SSC expiring/cancelling funds taskers
• Recommend remedial actions as necessary to resolve discrepancies to include reconciling and validating ULOs, 90-day MORDs (Miscellaneous 828 Obligation/Reimbursement Documents), Open Document List, DAR-Q Review, Analysis of Expiring and 829 Cancelling Year Funds, Year-End Contingent Liability and MIPR/MORD Validation.
• Interface with, at a minimum, the SSC financial management staff, Defense Finance and Accounting Services, and DCMA to resolve any anomalies identified during reconciliation
• Research and recommend potential corrective actions based upon expiring appropriations with the largest ULOs with NULO taking precedence over ULOs
• Collect all supporting documentation necessary to allow the Government to perform remedial action and monitor adequacy of resolution
• Work with with various Government organizations and agencies at all levels of the Department of Defense
• Otherwise support a government financial office

Knowledge and Skills:

• This position requires a minimum of two (2) years of government acquisition, finance or financial management, program management or related experience within a DoD organization and a minimum of one (1) year of DoD Space experience.
• The candidate must be proficient in the utilization of Government accepted, standardized and specialized software applications to include but not limited to: Microsoft Office, DoD Electronic Document Access, Defense Transaction Interface Module Systems, Wide Area Workflow (WAWF), myInvoice, General Accounting and Finance Systems (GAFS), Mechanization of Contract Administration Services (MOCAS), Project Management Resource Tools (PMRT), IDECS, Commander’s Research Integration System (CRIS), Procurement Integrated Enterprise Environment (PIEE), DEAMS, FM-Suite, ADVANA, PowerBI, the U.S. Treasury’s Collections Information Repository, Comprehensive Cost and Requirement System (CCaR™) experience and/or certification is preferred.

Education and Work Experience:

• This position requires a minimum of a Bachelor's degree in Management, Business, Economics, Finance, Accounting, Mathematics, Science, Technology, Engineering, or Statistics or other related discipline.

Physical & Mental Qualifications:

• Must be able to sit, type, hear, see, and speak for extended periods of time.
• Must consistently work and type on a computer for prolonged periods of time.
• Must be able to communicate accurate information and ideas so others will understand.
• Must be able to lift/carry at least 15 lbs.
• May be required to move about inside an office to access file cabinets, office supplies, etc.

Security Clearance:

• Applicants selected for employment will be subject to a Federal background investigation and must meet additional eligibility requirements for access to classified information or materials.

Travel:

• Some travel may be required.

Hours:

• Normal work schedule hours may vary, Monday through Friday. May be required to work additional hours and/or weekends, as needed, to meet deadlines or to fulfill travel obligations.

Salary Range:

• $70,000 - $110,000 per year
• The estimated salary range listed is a good faith determination of potential base compensation that may be offered to a successful applicant for this position at the time of this job posting and may be modified in the future. The disclosed salary range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. When determining an applicant’s compensation, various factors are taken into consideration including, but not limited to: geographic location, relevant prior work experience, relevant training, special skills/competencies, education, clearance, licenses/certifications, labor categories/contract rates and other business needs.

IDS offers a robust benefits package including employer paid health, dental, vision, disability, AD&D and life insurance plans for eligible employees. IDS also offers a variety of elective plans to eligible employees including flexible spending accounts, voluntary life insurance and supplemental insurance plans. Benefits become effective the first of the month following the start date of employment unless starting on the 1st of the month, in which case benefits are effective immediately upon the eligible employee’s start date. IDS offers eligible employees eleven (11) paid holidays, generous PTO accruals starting at three (3) weeks per year, as well as a 401(k) safe harbor contribution upon eligibility. IDS also offers generous employee referral bonuses.

IDS is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regards to age (40 and over), color, physical or mental disability, gender identity or expression, genetic information (including family medical history), national origin or ancestry, race, religion, sex, pregnancy (including childbirth and related medical conditions), sexual orientation, citizenship status, veteran status, uniformed service member status, or any other characteristic protected by federal, state, or local law. IDS participates in E-Verify. To learn more about E-Verify, including your rights and responsibilities, please visit www.e-verify.gov/. A submission of a resume is an expression of interest and not considered an application.

For more information, visit www.get-integrated.com.

**U.S. citizenship is required; H1-B visas and other visas are not being sponsored. Relocation expenses are NOT compensated. All jobs are employer paid; no fees to candidates. Third parties or agencies inquiries are not being accepted.**

#IDS