Senior Data Analytics Engineer

Role Description

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.

• 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.

Requirements

• 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.

Benefits

• 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.