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.

Your responsibilities as a Financial Reporting Consultant. 

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

Your background will include. 

·        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: 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. To learn more about our other exciting opportunities, visit our Jobs Page at www.atorchard.com.