Data and Dashboard Developer (15.50)

OCT Consulting, LLC; Washington (District of Columbia); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Health, Dental, Vision insurance

401K with 3% employer contributions

PTO & government holidays

Life Insurance

Disability benefits

Training benefits

Job summary

OCT Consulting is seeking a Data and Dashboard Developer to support a federal financial management program from our Washington, DC headquarters. The role focuses on building SQL data extracts, validating data, and delivering Power BI dashboards that show cost, workload, and program status for leadership and customer organizations.

The position requires US citizenship and the ability to obtain a favorable clearance.

Qualifications

• Bachelor’s degree in data analytics, information systems, computer science, finance, or related field.
• At least 2 years of experience in data analysis, dashboard development, or financial reporting.
• Advanced SQL; experience with Power BI or Tableau; advanced Excel.
• Experience with JIRA or similar change and release tracking; federal experience preferred.
• Experience maintaining SharePoint lists and libraries.
• Strong written and verbal communication skills.

Responsibilities

• Build and maintain SQL data extracts and queries for monthly close and analysis.
• Develop and run data validation rules and month-end checks.
• Build and refresh dashboards in Power BI or client-approved tools for program status and costs.
• Produce visuals for weekly, monthly, and six-month status reporting.
• Support change and release management; gather requirements and write use cases.
• Ensure dashboards meet Section 508 accessibility and protect PII/SCU information.
• Support SharePoint repository and create tip sheets for dashboard users.
• Handle ad hoc tasks and process improvement projects.

Skills

SQL

Power BI

Tableau

Excel

Data analysis

Dashboard development

Education

Bachelor’s degree

Tools

JIRA

SharePoint

SQL Server

Job description

Data and Dashboard Developer

OCT Consulting is a business management and technology consulting firm that supports Federal Government clients.

We provide consulting services in the areas of Strategy, Process Improvement, Change Management, Program and

Project Management, Acquisition/Procurement, and Information Technology.

OCT currently has an opening for a Data and Dashboard Developer to work with our federal client. This role supports

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 the program’s monthly data and build the dashboards that give program leadership and customer

organizations clear visibility into cost, workload, and program status.

This position is contingent upon contract award.

Day to day responsibilities include:

• Build and maintain SQL data extracts and queries from the program’s cost management system to support the monthly close, data validation, and analysis.
• Develop and run data validation rules and month-end checks, and report results against the program’s 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 change and release management for the program’s systems: gather requirements, write use cases, validate each release by comparing results before and after the change, and maintain configuration and release logs in JIRA. The client’s IT organization makes all system changes and deployments.
• Make sure 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.

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; advanced Excel
• Experience with financial data modeling and quality assurance validation
• Experience with JIRA or a similar tool for change and release tracking; federal change and release management experience preferred
• 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
• Preferred: Python or R; activity-based costing or budget forecasting models; Section 508 accessibility; Microsoft PL-300 or PMP certification; federal experience
• Must be a U.S. Citizen. Must 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 background investigation is for a Public Trust position and includes a questionnaire, fingerprinting, credit check, and law enforcement agency checks. A client-issued badge is required before any work begins.
• Highly desired: an active Secret or Top-Secret security clearance. The client has confirmed it will accept reciprocity for an active clearance held with another federal agency, which can shorten onboarding.
• Must complete the client’s cybersecurity awareness and information protection training at onboarding and every year after and sign a non-disclosure agreement for Sensitive But Unclassified information.
• Must be able to read, write, speak, and understand English fluently.
• This is a full-time position dedicated to this contract. Work is performed during standard Eastern Time business hours.
• Work is performed 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.

Benefits

• Medical, Dental, and Vision insurance
• Retirement savings 401K plan provided by an industry leading provider with 3% employer contributions of the employee’s gross salary
• Paid Time Off and Standard Government Holidays
• Life Insurance, Short- and Long-Term disability benefits
• Training Benefits

Salary Range: $80,000- 100,000 yearly commensurate with experience, education, etc.

About OCT Consulting

OCT Consulting LLC is a Small Business (SB) providing professional services and information technology solutions to

the Federal government and commercial clients. Founded in 2013, we bring the agility of operations and a management

team with a track record of leading successful engagements at major Federal government agencies.

At OCT we believe in creating a work environment where employees can thrive based on their abilities, skills, and

achievements. We are dedicated to providing career growth and professional development based on individual merit

and fostering a workplace where everyone’s contributions are valued and recognized.