Back to Job Search

Functional Data Analyst - REMOTE

  • Location: Bethesda, 60606
  • Salary: 62.0
  • Job Type:Contract

Posted about 1 month ago

MATRIX has partnered with a premier client in filling an urgent - LONG TERM REMOTE CONTRACT position. This is a great opportunity to expand your career and work with a well-known government agency.

Are you a Functional Data Analyst who LOVES working with manipulating data within Excel utilizing Macros, Power Queries, Pivots, Charts, etc?  Does your data analysis extend to setting up and maintaining Dashboards using Tableau and coding using Python?  Do you have an in depth understanding of budgeting?  Do you enjoy working in a team environment? If the answers are yes, this job is yours!

 

  • Will be Liaison between Stakeholders, Delivery Manager, and technical team
  • Work with Stakeholders and end users to understand KPI’s
  • Document process and goals
  • Translate functional needs to technical delivery
  • Designing Workflow experiences
  • Heavy process experience
  • Should be able to write documentation – user manuals
  • Reverse Engineering process experience
  • Strong budgeting skills – Must understand CapX vs OpsX budgeting in depth analysis

Technical Skills Required:

  • Advanced Excel Skills (Macros, Power Queries, Pivots, charts)
  • SQL – should be able to write basic SQL statements
  • Must understand dashboards
  • Good PowerPoint Skills

Pluses:

  • Python
  • Tableau or PowerBI
  • Experience with developing and supporting Federal grants, contracting, or administrative systems
Job Duties
  • Must understand CapX vs OpsX budgeting in depth analysis
  • Prepare actual versus forecast Budget Report with explanations of period variances for the entire data sets per program or project
  • Assist with budget reviews to include participation in discussions with administrative and program staff to obtain and clarify information
  • Gather budget information and perform analysis, Verify the accuracy of data; identify errors and perform corrections
  • Prepare summary analyses and spending projections for current and future year budgets
  • Strong Excel Skills (Macros, Power Queries, Pivots, charts)
  • Working Knowledge of data analysis using Python and similar languages – CODING
  • Experience with Sql server DB management required including performance tuning and troubleshooting
  • Prepare actual versus forecast Budget Report with explanations of period variances for the entire data sets per program or project
  • Assist with budget reviews to include participation in discussions with administrative and program staff to obtain and clarify information
  • Gather budget information and perform analysis, Verify the accuracy of data; identify errors and perform corrections
  • Prepare summary analyses and spending projections for current and future year budgets
  • Develop and maintain interactive dashboard tools (e.g., Tableau dashboard) to meet the needs and requirements of the client. – Developing, analysis, dashboarding
  • Develop process models using standard process analysis methodologies for current state analysis and the development of future state conceptual models.
  • Develop and deliver reports (ex. Excel, PowerPoint) to client in response to their requests and requirements.
  • Develop and maintain Document Tracking Report for ease of tracking and retrieval
  • Support Federal Manager through the analysis of process data to improve IT processes.
  • Define best practice process KPIs and monitor over time.
  • Must be able to pass government public trust clearance

 

Candidates will be responsible for following the client's COVID-19 protocols. Please refer to your MATRIX representative for specifics.

About Us

At MATRIX, we expertly match talented professionals with job opportunities to elevate careers. Since 1983, we have placed thousands of professionals at innovative clients across every industry ranging from small startups to Fortune 50 companies. It’s why we’re consistently in the top 25 of all U.S. IT staffing firms and why our consultants rate us well above the industry average, earning us ClearlyRated's Best of Staffing awards year after year. People come to us for a job, and stay with us because of our top-notch consultant care.

MATRIX is and Equal Employment Opportunity employer including disability and veteran and provides reasonable accommodations for all qualified individuals.  Supporting medical or religious documentation will be required where applicable. If you are a qualified individual you may request a reasonable accommodation under the American Disability Act (ADA). If you are a person with a disability needing assistance applying, or at any point in the hiring process, please email us at MATRIX_HR@MatrixRes.com. To ensure a quick response to your request, please use the words “Accommodation request” as the subject line of your email.