Remote Senior Analytics Engineer—Budget Data & Dashboards

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

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