Google Apps Script Jobs in Oregon (NOW HIRING)

DMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. With a focus on end-to-end managed IT services, including managed mobility, cloud, cybersecurity, network operations, and application development, DMI supports public sector agencies and commercial enterprises around the globe. Recognized as a Top Workplace, DMI is committed to delivering secure, efcient, and cost-effective solutions that drive measurable results. Learn more at www.dminc.com

DMI, LLC is seeking an IT Budget & Financial Governance Analyst to support the daily financial execution, data integration, and governance enforcement for the OCIO budget. Operating within a hybrid and evolving tool ecosystem, this role ensures data compliance with newly established financial structures and validation rules. You will work closely with the Senior Lead to track allocations, reconcile core ledger data, assist with the Front Office spend plan, and act as the front-line resource helping program offices execute their validation battle rhythms.

Duties and Responsibilities:

• Pulling, cleaning, and manually or semi-automatically ingesting raw data exports from core enterprise financial networks, data warehouses, and procurement modules into the central budget system.
• Executing day-to-day transaction logging, ledger balance checks, and tracking for the Front Office spend plan alongside broader consolidation efforts.
• Monitoring and facilitating the upcoming division validation process, acting as the primary point of contact for program staff during reporting cycles.
• Tracking division compliance against established reporting timelines, ensuring program teams verify their ingested ledger data within the mandatory windows.
• Analyzing contract Periods of Performance (POPs), processing purchase requisitions, and flagging execution delays that could disrupt executive disbursement strategies.
• Populating, updating, and verifying the underlying data integrity behind executive Quad Charts, pivot tables, and visual tracking dashboards.
• Working across a flexible toolset to reconcile disparate reports originating from various offices utilizing different software platforms.
• Identifying and documenting system inefficiencies, manual data bottlenecks, and opportunities where automated tools or APIs could streamline operations.
• Leveraging Generative AI platforms to draft rapid variance explanations, build data-cleaning logic, and create notification templates for division stakeholders.
• Maintaining organized digital repositories of historical spend plans, Inter-Agency Agreements (IAAs), Service Level Agreements (SLAs), and signed financial allocations.
• Conducting routine variance analysis on an individual project level to spot underspending or overspending trends early in the fiscal year.

Education and Years of Experience:  

• Bachelor's degree and 8 years of professional experience
• At least 3 years of professional experience in financial analysis, budgeting, or a data-intensive role.
• Advanced proficiency in either Microsoft Excel or Google Sheets (e.g., complex lookups, nested logic, pivot tables, data cleaning).
• Experience manually exporting, cleaning, and validating large, unformatted raw datasets from enterprise databases or core financial systems.
• Direct experience tracking multi-phased project timelines, contract periods of performance (POPs), or multi-year project allocations.
• Familiarity with integrating artificial intelligence and Large Language Models (LLMs) into daily workflows (e.g., using Gemini or Microsoft Copilot for drafting variance narratives or formatting data).
• Exposure to the federal budget lifecycle, financial execution phases, or public sector spend planning.
• Strong verbal and written communication skills with a track record of coordinating across diverse teams to gather data or enforce submission deadlines.

Required Skills & Certifications: 

• Bachelor's degree in related field such as Finance, Accounting, Business Administration, Economics, or Data Analytics.
• Advanced mastery of Smartsheet architecture, including cross-sheet referencing, automated approval workflows, and executive dashboard design.
• Proven capability in building advanced Excel Macros (VBA) or Google Apps Script to automate repetitive data manipulation tasks.
• Advanced skill in leveraging Generative AI (e.g., prompt engineering for complex financial trend analysis, script generation, or dataset cross-referencing).
• Prior experience working with or manipulating data directly originating from the Business Applications Solution (BAS) ecosystem, specifically EBS, EDW, or PRISM modules.
• Experience designing high-density visual reporting layouts, such as corporate Quad Charts or interactive business intelligence dashboards, for C-suite or executive leadership briefings.
• Ability to analyze fragmented, legacy workflows (e.g., tracking sheets scattered across Excel and Google Sheets) and provide recommendations on how to centralize and consolidate them into a unified system.

Citizenship Status Required: Must be a U.S. Citizen

Physical Requirements: None required for this position.

Location: Remote, but candidate needs to live in the DMV area

DMI is a diverse, prosperous, and rewarding place to work. Our culture is shaped by five core values that guide how we work, grow, and succeed together:

• Do What's Right - We lead with honesty and integrity.
• Own the Outcome - We take responsibility and deliver.
• Deliver for Our Customers - We are relentless about delivering value.
• Think Bold, Act Smart - We innovate with purpose.
• Win Together - We collaborate and celebrate our success.

These values aren't just ideals-they show up in how we support every part of your well-being:

• Convenience/Concierge - Virtual health visits, commuter perks, pet insurance, and entertainment discounts that make life easier.
• Development - Annual performance reviews, tuition assistance, and internal career growth opportunities to help you thrive.
• Financial - Generous 401(k) matches, life and disability insurance, and financial wellness tools to support your future.
• Recognition - Annual awards, service anniversaries, referral bonuses, and peer-to-peer shoutouts that spotlight your achievements.
• Wellness - Healthcare coverage, wellness programs, flu shots, and biometric screenings to support your health.

DMI values employees for their talents and contributions, and we take pride in helping our customers achieve their goals. Because when we live our values, we all win together.

***************** No Agencies Please *****************

Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.