As a Lead Data Analyst within the Finance Data Analytics team, you will own the design, build, and operational maturity of finance data products that turn business logic into reliable, enterprise‑grade analytics. You will convert business reports into Snowflake production views, deliver dynamic Tableau dashboards, and lead ETL/ELT solutions that unify disparate sources into trusted, auditable information for CFO and program decision‑making. You’ll pair rigorous data quality with advanced analytics (predictive modeling, anomaly detection) and agentic AI workflows to accelerate insight generation across the finance cadence. You will partner closely with Finance (FP&A, Controllership, Program Finance), Integrated Supply Chain, and Order Management to translate requirements into scalable solutions—grounded in aerospace controls, security, and compliance.
ResponsibilitiesKEY RESPONSIBILITIES
Data Product Engineering- Convert business reports and logic into enterprise‑grade reporting views in our cloud database. Building semantic layers and materialized views that are version‑controlled, documented, and performance‑tuned for finance workloads (variance, trend, forecast).
- Build dynamic, actionable dashboards in Tableau—with governed metrics, drill‑throughs, scenario views, and executive summaries for Finance leaders. Establish and publish certified data sources; monitor adoption and performance.
- Use Python and SQL to combine data from disparate sources (ERP/EPM, project controls, supply chain, CRM, flat files, APIs) into reconciled, trusted datasets that reduce manual effort and increase accuracy. Normalize and harmonize master data (CoA, cost centers, profit centers) for consistency across the finance lifecycle.
- Lead data validation, error checking, outlier analysis, reconciliations/tie‑outs to source systems, exception dashboards, and QA frameworks that support auditability and repeatability (SOX‑ready). Embed role‑based access controls, evidence trails, and control monitoring.
- Support program‑controls analytics including Earned Value Management (EVM) metrics (CPI/SPI, CV/SV), Estimates at Completion (EAC) trending, and contractual reporting (e.g., IPMDAR). Build dashboards and datasets that surface risk/opportunity and drive corrective actions with Program Finance.
- Use GitHub Copilot with Python to accelerate ETL, statistical modeling, and rapid analysis while maintaining secure coding and review practices; maintain reproducible notebooks and pipelines.
- Develop predictive models (forecast accuracy, anomaly detection, driver analysis) and agentic AI workflows (orchestrated assistants in Dataiku or equivalent) to automate repetitive analytics and triage root causes—aligned to responsible‑AI and governance standards.
- Design with SOX controls in mind (data integrity, evidence, continuous controls monitoring) and partner with Controllership/Internal Audit on automation of key reports and control testing.
- Run an agile backlog of finance analytics use cases; collaborate across Finance, ISC, OM, and IT.
YOU MUST HAVE
- 6+ years in data analytics/data engineering with Finance domain exposure (FP&A, Controllership, Program Finance).
- Advanced SQL; hands‑on Snowflake and Tableau experience building production‑grade views, models, and dashboards.
- Strong Python for data processing, automation, and statistical analysis; experience with ETL/ELT and orchestrating pipelines.
- Proven delivery of data validation, error checking, outlier analysis, and reconciliations that stand up to audit.
- Ability to translate complex business logic into scalable technical specifications and governed data products; excellent communication with Finance stakeholders.
WE VALUE
- Experience with Dataiku or Databricks and GitHub Copilot to accelerate secure development.
- Familiarity with ERP/EPM ecosystems (SAP/Oracle), master‑data harmonization, and finance data architecture.
- Prior work in SOX controls, continuous control monitoring, and audit analytics.
- Awareness of export controls (ITAR/EAR) and handling of controlled technical data; prior security clearance a plus.
- Experience optimizing Tableau performance and semantic layers.
US PERSONS REQUIREMENT
Due to U.S. export control laws, candidates must be U.S. citizen, U.S. permanent resident, or have protected status under asylum or refugee.
About us:
Join a company that's reintroducing itself to the aviation community we've helped advance for more than a century. At Honeywell Aerospace (NASDAQ: HONA), we're launching as an independent, publicly traded aerospace and defense company built on a legacy of operational excellence and mission-focused execution.
Our new brand identity pairs that heritage with real momentum, as we build technology that helps pilots navigate with confidence, aircraft operate more efficiently, and operators stay ahead of change. With our systems on board 90% of the world's aircraft, your work here has reach that's rare to find anywhere else.
Focusing on our customers, investing in innovation, and building a culture of accountability and performance is how we're shaping what comes next.
Every horizon. Every mission. Every day.
Benefits:
Beyond a performance-driven salary, you'll work alongside dedicated experts on technology that's advancing aviation. As a Honeywell Aerospace employee, you're eligible for a comprehensive benefits package that includes:
- Employer-subsidized medical, dental, vision and life insurance
- Short-term and long-term disability coverage
- 401(k) match, flexible spending accounts and health savings accounts
- Employee assistance program and educational assistance
- Parental leave and 12 paid holidays
- Paid time off for vacation, personal and sick time
Explore your benefits: https://honeywellaerospacebenefits.com/
POSTING TIMELINE
The application period for the job is estimated to be 40 days from the job posting date; however, this may be shortened or extended depending on business needs and the availability of qualified candidates.
Skills Required
- 6+ years in data analytics or data engineering with Finance domain exposure (FP&A, Controllership, Program Finance)
- Advanced SQL skills
- Hands-on Snowflake experience building production-grade views and models
- Hands-on Tableau experience building production-grade dashboards and certified data sources
- Strong Python for data processing, automation, and statistical analysis
- Experience with ETL/ELT and orchestrating pipelines
- Proven delivery of data validation, error checking, outlier analysis, and reconciliations suitable for audit (SOX-ready)
- Ability to translate complex business logic into scalable technical specifications and governed data products; strong communication with Finance stakeholders
- Must be a U.S. citizen, U.S. permanent resident, or have protected status (asylum/refugee)
The Aerospace Corporation Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about The Aerospace Corporation and has not been reviewed or approved by The Aerospace Corporation.
-
Retirement Support — The 401(k) plan provides a company‑paid contribution of 8–12% based on years of service with immediate eligibility and vesting, and eligible employees can access retiree medical benefits.
-
Leave & Time Off Breadth — Paid time off includes 15 vacation days (rising to 20 after five years), nine paid holidays, and unlimited sick time for exempt employees with accruals for non‑exempt staff.
-
Flexible Benefits — Flexible work models include a 9/80 schedule with alternating Fridays off, supported by backup care services, an EAP, relocation assistance, and home‑office stipends where applicable.
The Aerospace Corporation Insights
What We Do
The space enterprise has been transformed by rapid change and growth. New vehicles for national security space, a more rapid launch cadence, proliferated satellite constellations, the pursuit of interplanetary exploration, and thriving commercial ventures are changing the nature of the space industry. The Aerospace Corporation (Aerospace) is a leading architect for U.S. space programs, shaping efforts to outpace threats to our national security while cultivating the technologies needed to further this new era of space commercialization and exploration. Aerospace works across the space enterprise in service of the public interest. In addition to supporting the Department of Defense and the Intelligence Community, our customers include NASA, NOAA, numerous federal agencies, and commercial space — all of whom benefit from our deep technical knowledge. We only pursue business related to the space mission and complementary fields, operating as the nation’s trusted partner to solve the toughest challenges and develop reliable and innovative technologies. Innovation in space occurs when people have the freedom to imagine and do. At Aerospace, we take pride in our readiness to solve some of the most complex challenges in the space enterprise.
Why Work With Us
We are a non-profit corporation chartered by the government to work on the hardest problems in space. We employ technical experts in every discipline of space-related science and engineering who touch every part of the US space program. Come join us as we make an impact bigger than ourselves.
Gallery
