Data and Dashboard Developer (15.50)

OCT Consulting, LLC•Washington, DC

2d•$80,000 - $100,000•Hybrid

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 developer will prepare and validate monthly program data and build dashboards that provide program leadership and customer organizations with visibility into cost, workload, and program status. 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 role supports data extraction and validation, dashboard and reporting development, and change and release management. The client’s IT organization makes all system changes and deployments. The developer also supports the program’s SharePoint repository, prepares user guidance, and contributes to ad hoc taskings and process improvement projects. The position requires U.S. citizenship and residence in the United States for at least three of the last five years. The employee must obtain and maintain a favorable preliminary and final fitness determination from the client agency before starting and 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. An active Secret or Top-Secret clearance is highly desired, and the client accepts reciprocity for an active clearance held with another federal agency. The employee must complete cybersecurity awareness and information protection training at onboarding and annually thereafter, sign a non-disclosure agreement for Sensitive But Unclassified information, and be fluent in reading, writing, speaking, and understanding English.

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 skills.
Experience with Power BI (DAX, Power Query) or Tableau.
Advanced Excel skills.
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 obtain and maintain a favorable preliminary and final client-agency fitness determination; a client-issued badge is required before work begins.
Must complete required cybersecurity awareness and information protection training and sign a non-disclosure agreement for Sensitive But Unclassified information.
Must be able to read, write, speak, and understand English fluently.

Nice To Haves

Federal change and release management experience.
Python or R.
Experience with activity-based costing or budget forecasting models.
Section 508 accessibility experience.
Microsoft PL-300 or PMP certification.
Federal experience.
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 for 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 program systems change and release management by gathering requirements, writing use cases, validating releases through before-and-after comparisons, 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 client cybersecurity awareness and information protection training at onboarding and annually, and sign a non-disclosure agreement for Sensitive But Unclassified information.

Benefits

Medical insurance.
Dental insurance.
Vision insurance.
Retirement savings 401(k) plan with 3% employer contributions of the employee’s gross salary.
Paid Time Off.
Standard Government Holidays.
Life insurance.
Short- and long-term disability benefits.
Training benefits.
Career growth and professional development.