Senior Data Analytics Engineer - Federal Financial and Budget

Orchard LLC; Chicago (IL); Remote; USD 140,000 - 185,000; Full time

Benefits offered by this job

Bonus eligibility

Professional development

Generous benefits

Job summary

Orchard LLC is seeking a Senior Analytics Engineer to join a DoW client team to build and govern enterprise financial data pipelines and analytical datasets. The role emphasizes transforming complex datasets into actionable decision-support products and executive-level reporting for budget execution and planning.

The ideal candidate will implement data pipelines with Python/SQL, leverage Databricks and PySpark, develop dashboards with ADVANA/Qlik, and collaborate with stakeholders to deliver

Qualifications

• Bachelor's degree in business, data, or a relevant field.
• 5+ years of experience supporting enterprise analytics, data engineering, BI, or financial data initiatives.
• Strong proficiency with Python and SQL.
• Experience with Databricks, Spark, PySpark, or similar modern data platforms.
• Experience integrating, transforming, and reconciling data from multiple enterprise systems including DoW entities.
• Experience developing dashboards/visualizations using ADVANA or Qlik.
• Ability to translate business requirements into practical technical solutions.
• Ability to communicate technical findings clearly to non-technical stakeholders.

Responsibilities

• Develop, maintain, and optimize enterprise data pipelines using Python, SQL, PySpark, Databricks, and related technologies.
• Integrate, reconcile, and validate data from multiple authoritative financial, operational, and programmatic systems.
• Design and maintain analytical datasets, data models, semantic layers, and data marts for reporting needs.
• Support PPBE, budget execution, financial analysis, spending plan, obligation, and expenditure reporting.
• Build and maintain executive dashboards, scorecards, and visualizations using ADVANA/Qlik.
• Perform data profiling, cleansing, validation, and quality assessment.
• Support data governance, including data dictionaries, lineage, metadata, and quality metrics.
• Collaborate with stakeholders to gather requirements and translate needs into technical solutions.
• Develop documentation, SOPs, user guides, testing artifacts, and technical materials.
• Prepare analytical products and briefing materials for technical and non-technical audiences.

Skills

Python

SQL

ADVANA/Qlik

Data visualization

Stakeholder communication

Requirements gathering

Data transformation

Education

Bachelor's degree in business/data/relevant field

Tools

Databricks

Spark

PySpark

Job description

Senior Data Analytics Engineer

Federal Financial & Budget Data Remote/Work from Home within the United States Must be a U.S. Citizen with an active or interim Secret Clearance.

@Orchard LLC has an immediate need for a Senior Analytics Engineer to support a Department of War client in the integration, engineering, governance, analysis, and visualization of enterprise financial and programmatic data. This role is ideal for a hands‑on technical professional who can build and maintain data pipelines, transform complex financial datasets into actionable decision-support products, and support executive‑level reporting for budget execution, resource management, and planning activities.

Responsibilities

• Develop, maintain, and optimize enterprise data pipelines using Python, SQL, PySpark, Databricks, and related technologies.
• Integrate, reconcile, and validate data from multiple authoritative financial, operational, and programmatic systems.
• Design and maintain analytical datasets, data models, semantic layers, and data marts that support recurring and ad hoc reporting needs.
• Support PPBE, budget execution, financial analysis, spending plan, obligation, and expenditure reporting activities.
• Build and maintain executive dashboards, scorecards, and visualizations using ADVANA/Qlik.
• Perform data profiling, cleansing, validation, and quality assessment to improve accuracy, completeness, and reliability.
• Support data governance activities, including data dictionaries, lineage, metadata, business rules, and quality metrics.
• Collaborate with client stakeholders to gather requirements and translate business needs into technical solutions.
• Develop documentation, SOPs, user guides, testing artifacts, and technical materials that support sustainment and auditability.
• Prepare analytical products and briefing materials that communicate findings and recommendations to technical and non-technical audiences.

Qualifications

• Must be a U.S. Citizen
• Must possess and maintain a(n) (Interim) Secret Clearance. Given lead time, Iberia will not sponsor new clearance investigations for this role.
• Bachelor's degree in business, data, or a relevant field
• 5+ years of experience supporting enterprise analytics, data engineering, business intelligence, or financial data initiatives.
• Strong proficiency with Python and SQL.
• Experience with Databricks, Spark, PySpark, or similar modern data platforms.
• Experience integrating, transforming, and reconciling data from multiple enterprise systems. This must include experience with DAI at USMC or another DoW entity.
• Experience developing dashboards or visualizations using ADVANA/Qlik.
• Ability to translate business requirements into practical technical solutions.
• Ability to communicate technical findings clearly to non-technical stakeholders.

Preferred Knowledge, Skills & Abilities

• Experience supporting Department of War organizations, especially financial management, comptroller, resource management, or PPBE functions.
• Experience with data governance, metadata management, data lineage, and data quality controls.
• Experience with Git, GitHub, GitLab, Jira, or similar version control and delivery management tools.
• Experience with workflow automation, Power Platform, UiPath, Celonis, or process intelligence tools.
• Experience producing executive‑level briefings, dashboards, and decision‑support materials.

Compensation for this role will be determined based on experience and qualifications. The expected base salary range is between $140K and $185K. Generous benefits, bonus eligibility, and significant professional development support are all available.

Established in 2010, @Orchard has an exceptional reputation, providing staffing solutions to time‑sensitive, talent‑scarcity issues to deliver better talent management ROI. Our specialty lies in the critical area of program talent acquisition and resource management, not in one narrow skillset, but across many areas of technical and functional delivery.