Senior Program Analyst

Dextera-Corporation; Indiana (PA); Hybrid; USD 54,000 - 66,000; Full time

Job summary

Dextera-Corporation seeks a Senior Program Analyst in Indianapolis, IN to provide advanced financial data analysis, reporting, and tool development for budget formulation and execution. The role emphasizes Excel-based automation, data visualization, and compliance with financial regulations. Remote work is primary, with onsite reporting as required.

Qualifications include a Bachelor's degree, 5+ years of experience, and strong communication skills. U.S.

Qualifications

• Bachelor’s degree in a related field.
• Minimum 5 years of work experience in business analysis/finance.
• Expert-level Excel for advanced data analysis, automation, and visualization.

Responsibilities

• Develop, maintain, and update financial tools and trackers.
• Support budget formulation and execution with data analysis.
• Prepare financial reports and data summaries for management.

Skills

Advanced Excel

Data analysis

Financial reporting

Budgeting

Communication

ERP systems

Analytical thinking

Microsoft Office

Education

Bachelor's degree

Tools

SAP

ServiceNow

Concur

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior Program Analyst

Full Time Salaried Full-Time Professional Indianapolis, IN, Indianapolis, IN, US

10 days ago Requisition ID: 1771

Salary Range: $60,000.00 To $60,000.00 Annually

This position is primarily remote; however, the employee may be required to report to the designated CBP office as needed to support contract requirements, meetings, training, audits, or other business needs. Candidates must reside within a 50-mile radius of the designated CBP office and be able to report onsite when required.

Position Summary

The Sr. Program Analyst provides advanced financial data analysis, reporting, and technical support to the CBP Office of Finance. This role is responsible for developing, maintaining, and updating interactive tools and trackers for financial reporting and data analysis, supporting budget formulation and execution, and ensuring compliance with financial laws and regulations. The Sr. Program Analyst collaborates with stakeholders to deliver accurate, actionable financial insights and process improvements.

Essential Functions

• Develop, maintain, and update interactive tools and trackers for financial reporting and data analysis using advanced Microsoft Excel features (pivot tables, Power Query, complex formulas, and data visualization tools).
• Ensure all tools are user-friendly, accurate, and updated according to financial reporting requirements.
• Perform data analysis and summarization to support budget formulation and execution processes.
• Provide technical assistance and analysis for budget formulation and financial transaction processing.
• Interpret and apply financial laws, regulations, and accounting principles to ensure compliance.
• Develop and maintain financial reports and data summaries for management and stakeholders.
• Communicate financial analysis and findings clearly in both written and verbal formats.
• Perform other duties as assigned in support of finance and revenue operations.

JOB SPECIFICATIONS/Qualifications

• Must be a U.S. citizen.
• Bachelor’s degree (four-year degree) with a major in a related field.
• A minimum of five years of work experience performing similar business analysis work.
• Expert-level proficiency in Microsoft Excel, specifically for advanced data analysis, automation, and visualization.
• Proficiency with Microsoft Teams, Word, Outlook, Access and use of multiple monitors.
• Strong written and verbal communication skills, particularly in financial contexts.
• Experience in financial analysis, transaction processing, and budget execution.
• Experience in developing and maintaining financial reports and data summaries.
• Advanced analytical and problem-solving skills for financial data analysis.
• Ability to design and automate financial tools and trackers in Excel.
• Strong attention to detail and accuracy in financial reporting.
• Excellent communication and interpersonal skills.
• Ability to manage multiple tasks and prioritize effectively.
• Professional demeanor and adherence to CBP’s standards of conduct.
• Prior experience with SAP, ServiceNow, and Concur software systems is desired, but not required.
• Must be able to successfully complete the required U.S. Government background investigation and security clearance process. The selected candidate must be able to obtain and maintain the security clearance required for the position as a condition of employment and continued employment.

OTHER ESSENTIAL REQUIREMENTS

Computer Skills:Proficiency with computers and ability to navigate/enter information into established databases and Microsoft Office products.

Language:Knowledge of the structure and content of the English language including the meaning and spelling of words, rules of composition, and grammar.

Communication:Ability to communicate effectively in writing and in person as appropriate for the needs of the audience.

Customer Service: Ability to address all customer inquiries with a pleasant and patient demeanor.

Math Ability:Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions and decimals. Ability to compute rates, ratio, and percent and to draw and interpret information. Ability to choose the right mathematical methods or formulas to solve a problem.

Reasoning Ability:Ability to collect data, define problems, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of instructions dealing with several abstract and concrete variables.

Work Environment:When on site, work is performed in an office cubicle environment with low noise level.

Physical Demands:Employee will have consistent and direct visual contact with multiple computer monitors.

Other Demands:Must comply with all CBP security, training, and onboarding requirements.

• May be required to work overtime during peak periods and perform mission-essential functions during government furloughs or shutdowns.