Data and Dashboard Developer (15.50)

OCT Consulting • Washington, DC

1d • Onsite

About The Position

OCT Consulting is hiring a Data and Dashboard Developer to support a federal financial management shared services program that provides cost allocation, customer billing, financial reporting, and customer service operations to multiple federal customer organizations. The position is contingent upon contract award and is full-time, dedicated to the contract. Work is performed during standard Eastern Time business hours at the client’s headquarters in Southwest Washington, DC. Remote work, including from OCT facilities, may be performed with the client’s prior approval. Infrequent travel to other client sites, such as Dallas, TX, and Williston, VT, may be required.

The developer prepares and validates monthly program data and builds dashboards that give program leadership and customer organizations visibility into cost, workload, and program status. The role supports monthly close, data quality and validation, reporting, dashboard development, system change and release management, accessibility and information protection, and user documentation. The client’s IT organization makes system changes and deployments.

Requirements

• Bachelor’s degree in data analytics, information systems, computer science, finance, business, or a related field.
• At least 2 years of experience in data analysis, dashboard development, or financial reporting.
• Advanced SQL; experience with Power BI (DAX, Power Query) or Tableau; and advanced Excel.
• Experience with financial data modeling and quality assurance validation.
• Experience with JIRA or a similar tool for change and release tracking.
• Experience maintaining SharePoint lists and libraries.
• Strong attention to detail and clear written and verbal communication.
• Proficiency in Microsoft Outlook, Teams, Word, Excel, PowerPoint, Project, and SharePoint.
• Must be a U.S. Citizen and have lived in the United States for at least three of the last five years.
• Must be able to obtain a favorable preliminary and final fitness determination from the client agency before starting work and maintain it throughout performance. The Public Trust background investigation includes a questionnaire, fingerprinting, credit check, and law enforcement agency checks.
• A client-issued badge is required before work begins.
• Must be able to read, write, speak, and understand English fluently.

Nice To Haves

• Federal change and release management experience.
• Python or R.
• Activity-based costing or budget forecasting models.
• Section 508 accessibility experience.
• Microsoft PL-300 or PMP certification.
• Federal experience.
• An active Secret or Top-Secret security clearance; the client accepts reciprocity for an active clearance held with another federal agency.

Responsibilities

• Build and maintain SQL data extracts and queries from the program’s cost management system to support monthly close, data validation, and analysis.
• Develop and run data validation rules and month-end checks, and report results against program data quality targets for accuracy and completeness.
• Build and refresh dashboards in Power BI or other client-approved tools for program status, monthly cost and workload trends, data-provider response times, and customer-facing views.
• Produce visuals for weekly, monthly, and six-month status reporting and schedule tracking.
• Support system change and release management by gathering requirements, writing use cases, validating releases by comparing results before and after changes, and maintaining configuration and release logs in JIRA.
• Ensure dashboards and reports meet Section 508 accessibility requirements and protect PII and Sensitive But Unclassified information.
• Support the program’s SharePoint document repository and create tip sheets and short guides for dashboard users.
• Support ad hoc taskings and process improvement projects as assigned.
• Complete the client’s cybersecurity awareness and information protection training at onboarding and annually thereafter, and sign a non-disclosure agreement for Sensitive But Unclassified information.

Benefits

• Medical, dental, and vision insurance.
• 401(k) retirement savings plan with 3% employer contributions of the employee’s gross salary.
• Paid time off and standard government holidays.
• Life insurance and short- and long-term disability benefits.
• Training benefits.
• Career growth and professional development.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level