Data Analytics Integrator (Power BI/Federal Financial Systems)

Opportunity Federal, a Service-Disabled Veteran-Owned Small Business, is seeking a Data Analytics Integrator in Marietta, GA. You will serve as the primary technical architect, bridging human resources and financial data - designing, building, and maintaining a suite of Power BI data products from the ground up that give senior leadership real-time and predictive visibility into manpower and budget execution. This is a greenfield build: no inherited dashboards, no existing data models. You own the pipelines, the models, and the products end-to-end, 1. Design, build, and maintain executive dashboards, including:

• Leave Without Pay (LWOP) / Return-to-Duty status tracking with integrated budget impacts;
• Awards and Quality Step Increase (QSI) monitoring with processing timelines;
• Military service credit deposit (buyback) tracking; and
• A Status of Funds dashboard with integrated views of available, committed, and obligated funds tied to personnel accounts.

1. Build reconciliation products identifying discrepancies between personnel systems and the accounting system of record.

2. Develop predictive models for vacancy fill timelines (“time-to-fill”) and multi-year workforce trends - retirements, attrition, and promotions - and their budget impact.

3. Create a workflow-visualization tool tracking personnel and budget actions from initiation to completion.

4. Sustain defined quality standards: 95-100% data accuracy and data refreshes within 24 hours of source-system updates.

5. Serve as the customer’s trusted analytics resource, working directly with senior Government leadership.

Do you have experience in SQL?, 1. Eligible for a Common Access Card (CAC) - requires a favorable FBI fingerprint check and Tier 1 federal background investigation (no security clearance required).

1. Four or more (4+) years designing and deploying Power BI solutions, including: * Advanced DAX and Power Query; * Data modeling; and * Workspace administration and row-level security.

2. Hands-on ETL experience - SQL required; SSIS, Azure Data Factory, or Power Platform dataflows a plus. You build data pipelines, not just reports.

3. Experience handling sensitive/PII data with appropriate access controls.

4. Ability to work on-site in Marietta, GA.

Preferred Qualifications

1. Experience with Army or DoD systems: GFEBS, DCPDS, FTSMCS, or comparable federal financial or HR systems of record.

2. DoD, National Guard, or federal workforce/manpower analytics background - veterans and Guard technicians strongly encouraged to apply.

3. Forecasting or predictive modeling experience (Python or R a plus).

4. Experience in standing up a BI capability from zero in a new environment

Pay: $90,000.00 - $120,000.00 per year

Application Question(s):

• Do you have hands-on experience building ETL/data pipelines (not just reports)?
• How many years of Power BI experience including DAX and data modeling?